Re: trigger for TRUNCATE? - Mailing list pgsql-sql

From Alvaro Herrera
Subject Re: trigger for TRUNCATE?
Date
Msg-id 20080110171027.GK6465@alvh.no-ip.org
Whole thread Raw
In response to Re: trigger for TRUNCATE?  (Gerardo Herzig <gherzig@fmed.uba.ar>)
Responses Re: trigger for TRUNCATE?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Gerardo Herzig escribió:

> Yes, the TRUNCATE statement is not sql ansi, maybe is a more low level 
> thing than i think.

TRUNCATE currently does not fire triggers, but that doesn't mean it's
impossible to do it.  I think it would be fairly easy to add support
for that.

Currently, Mammoth Replicator does replicate TRUNCATE commands.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.


pgsql-sql by date:

Previous
From: Gerardo Herzig
Date:
Subject: Re: trigger for TRUNCATE?
Next
From: Tom Lane
Date:
Subject: Re: trigger for TRUNCATE?