Christopher Kings-Lynne wrote: > > > > Hrm - last time I checked it did... > > > > Two questions : > > > > When was the last time ? > > 7.1 > > > It did what ? > > Drops triggers and stuff. > > OK, I did a check and it looks like it's fixed in 7.2 at least. Sorry for > the false alarm...
It has never "dropped triggers and stuff", so there was nothing to fix. All TRUNCATE TABLE has ever done, since the patch was submitted, was to truncate the underlying relation file and the associated index files, and reinitialize the indexes. It has been changed to be disallowed in transactions involving tables not created in the same transaction, but that's about it. People have argued that if there are *RI* triggers on a table, that TRUNCATE should be disallowed, as in Oracle. But TRUNCATE from inception to date has never dropped triggers... Mike Mascari [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])