Re: disabling triggers temporaly

On Friday 02 June 2006 00:54, Mario Medina wrote:
> Hi! does it exists any way to make that a trigger be disabled only for
> one insert and for other inserts not?
>
> I have a table, every insert,update or delete on it activates a trigger
> that do some tasks, but i wish that when i call special
> insert/update/delete on that table the trigger doesn't starts...
>
> The only way i think to do that is to start a transaction, delete the
> trigger, do the insert on the table, create the trigger again an commit
> the transaction..., and another is to make the trigger to check some
> value, and if that value is 1 the trigger works, if it is 0 the trigger
> doesn't, but i wish to know if it is a better way.
>

You can do this with alter table... see 
http://www.postgresql.org/docs/8.1/interactive/sql-altertable.html

-- 
Robert Treat
Build A Brighter Lamp :: http://www.brighterlamp.org