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

trigger for TRUNCATE?

From: Gerardo Herzig <gherzig(at)fmed(dot)uba(dot)ar>
To: "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Subject: trigger for TRUNCATE?
Date: 2008-01-08 18:19:21
Message-ID: 4783BEA9.3020507@fmed.uba.ar (view raw or flat)
Thread:
Lists: pgsql-sql
Hi all. Acording to the docs, TRUNCATE will not fire a DELETE trigger on 
the table being truncated.
There is a way to capture a TRUNCATE in any way?

Thanks!
Gerardo

Responses

pgsql-sql by date

Next:From: Erik JonesDate: 2008-01-08 18:28:52
Subject: Re: How to keep at-most N rows per group? periodic DELETEs or constraints or..?
Previous:From: codeWarriorDate: 2008-01-08 17:53:57
Subject: Re: How to keep at-most N rows per group? periodic DELETEs or constraints or..?

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