Re: TRUNCATE question

Makes for a real pain when the nice and safe foreign keys aren't
really nice and safe anymore.
--
Rod Taylor

Your eyes are weary from staring at the CRT. You feel sleepy. Notice
how restful it is to watch the cursor blink. Close your eyes. The
opinions stated above are yours. You cannot imagine why you ever felt
otherwise.

----- Original Message -----
From: "Mike Mascari" <mascarm@mascari.com>
To: "Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
Cc: "Hackers" <pgsql-hackers@postgresql.org>
Sent: Thursday, August 02, 2001 9:56 PM
Subject: Re: [HACKERS] TRUNCATE question


> Christopher Kings-Lynne wrote:
> >
> > Is TRUNCATE supposed to be equivalent to DELETE FROM blah?
> >
> > Because I notice that DELETE triggers are not called when you
truncate a
> > table...  Isn't that a bad thing?
>
> It's supposed to work that way - same as Oracle.
>
> Mike Mascari
> mascarm@mascari.com
>
> ---------------------------(end of
broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>