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: (view raw, whole thread or download thread mbox)
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


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-2017 The PostgreSQL Global Development Group