Skip site navigation (1) Skip section navigation (2)

Re: Triggers on TRUNCATE?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Daniel Baldoni <pgsql(at)lcds(dot)com(dot)au>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Triggers on TRUNCATE?
Date: 2004-07-26 14:59:06
Message-ID: 27539.1090853946@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Daniel Baldoni <pgsql(at)lcds(dot)com(dot)au> writes:
> Forgive this if it's totally "out there" but I was wondering why there's no
> support for triggers on a TRUNCATE operation.

Because the entire point of TRUNCATE is not to scan the table contents.

If you want to fire triggers, just use "DELETE FROM foo".

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Marc G. FournierDate: 2004-07-26 15:34:56
Subject: Re: CVS web interface error
Previous:From: Tom LaneDate: 2004-07-26 14:46:56
Subject: Re: Weird...but correct?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group