>From my limited understanding of truncate in Oracle is it requires the user to first disable integrity constraints on the table before truncate will run.
In SQL Server that truncate will not allow truncate if foreign key constraints exist, but does not execute user delete triggers. Can't remember nor confirm either of these now. But, for consistency sake we should enforce the foreign key case. But I really think it should apply to all constraints, system or user enforced (rules, user written triggers). Besides that, theres always Codds twelfth rule which I've always liked: The nonsubversion rule: If low-level access is permitted it should not bypass security or integrity rules. -- Rod ----- Original Message ----- From: "Joel Burton" <[EMAIL PROTECTED]> To: "Tom Lane" <[EMAIL PROTECTED]>; "Rod Taylor" <[EMAIL PROTECTED]> Cc: "Hackers List" <[EMAIL PROTECTED]> Sent: Sunday, May 12, 2002 3:48 PM Subject: RE: [HACKERS] TRUNCATE > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED]]On Behalf Of Tom Lane > > Sent: Sunday, May 12, 2002 12:30 PM > > To: Rod Taylor > > Cc: Hackers List > > Subject: Re: [HACKERS] TRUNCATE > > > > > > "Rod Taylor" <[EMAIL PROTECTED]> writes: > > > I'm thinking it should check for an on delete rule as well as user > > > triggers. > > > > Seems reasonable to me. > > > > Should there be a "FORCE" option to override these checks and do it > > anyway? Or is that just asking for trouble? > > I've relied on being able to TRUNCATE w/o having RI kick in to lots of data > clean ups, forced sorts, etc. I'd find it annoying if I couldn't do this > anymore (or had to do equally-annoying things, like manually drop then > recreate the triggers, etc.) > > I'm happy w/o the FORCE option (just let TRUNCATE do it), but if enough > people think that the FORCE keyword should be added to allow overriding of > triggers, that could be a good compromise. > > But, please, don't take away the ability to TRUNCATE. Doing it when there > are triggers is one the strengths of TRUNCATE, IMNSHO. > > - J. > > Joel BURTON | [EMAIL PROTECTED] | joelburton.com | aim: wjoelburton > Knowledge Management & Technology Consultant > ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
