From: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> |
---|---|
To: | pgsql-php(at)postgresql(dot)org |
Cc: | Mario Medina <mario(at)soweb(dot)com(dot)mx> |
Subject: | Re: disabling triggers temporaly |
Date: | 2006-06-04 14:15:49 |
Message-ID: | 200606041015.49731.xzilla@users.sourceforge.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-php |
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
From | Date | Subject | |
---|---|---|---|
Next Message | John Mohr | 2006-06-07 18:26:11 | Conventions for XML? |
Previous Message | Alvaro Herrera | 2006-06-02 17:51:47 | Re: php|works / db|works call for papers ends June |