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

Re: trigger for TRUNCATE?

From: Gerardo Herzig <gherzig(at)fmed(dot)uba(dot)ar>
To: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
Cc: Chris Browne <cbbrowne(at)acm(dot)org>, pgsql-sql(at)postgresql(dot)org
Subject: Re: trigger for TRUNCATE?
Date: 2008-01-10 16:40:11
Message-ID: 47864A6B.3070902@fmed.uba.ar (view raw or flat)
Thread:
Lists: pgsql-sql
Pavel Stehule wrote:

>On 08/01/2008, Chris Browne <cbbrowne(at)acm(dot)org> wrote:
>  
>
>>gherzig(at)fmed(dot)uba(dot)ar (Gerardo Herzig) writes:
>>    
>>
>>>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?
>>>      
>>>
>>I think there's some sort of "to do" on that...
>>
>>It ought to be not *too* difficult (I imagine!) to be able to
>>associate a trigger with the TRUNCATE action, and therefore run some
>>stored function any time TRUNCATE takes place.
>>
>>For the Slony-I replication system, it would be attractive for this to
>>lead to attaching two functions:
>>  - One function would return an exception so that TRUNCATE against
>>    a subscriber node would fail...
>>
>>  - Another would pretty much be as simple as submitting an event;
>>    perform createEvent('_ourcluster', 'TRUNCATE_TABLE', table_id);
>>
>>A new event, TRUNCATE_TABLE, would do a TRUNCATE against the
>>subscribers.
>>
>>This represents a pretty easy enhancement, given the new kind of
>>trigger.
>>--
>>(reverse (concatenate 'string "moc.enworbbc" "@" "enworbbc"))
>>http://www3.sympatico.ca/cbbrowne/nonrdbms.html
>>Frisbeetarianism: The belief that when  you die, your  soul goes up on
>>the roof and gets stuck...
>>
>>Hello
>>
>>theoretically you can have trigger on any statement, but I am not sure
>>about conformance with std. But, you can wrap TRUNCATE statement into
>>some procedure, and then call this procedure with some other actions.
>>
>>Regards
>>Pavel Stehule
>>
>>    
>>
Yes, the TRUNCATE statement is not sql ansi, maybe is a more low level 
thing than i think.
Gerardo


In response to

Responses

pgsql-sql by date

Next:From: Alvaro HerreraDate: 2008-01-10 17:10:27
Subject: Re: trigger for TRUNCATE?
Previous:From: Richard Broersma JrDate: 2008-01-10 13:56:44
Subject: Re: Support for SQL TOP clause?

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