Re: TRUNCATE question - Mailing list pgsql-hackers

From Rod Taylor
Subject Re: TRUNCATE question
Date
Msg-id 03f001c11bc1$962dda30$2205010a@jester
Whole thread Raw
In response to TRUNCATE question  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
List pgsql-hackers
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
>



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: AW: OID wraparound: summary and proposal
Next
From: Mike Mascari
Date:
Subject: Re: TRUNCATE question