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

DROP TRIGGER in trigger

From: Peter Chekunaev <forlists(at)fbd(dot)ru>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: DROP TRIGGER in trigger
Date: 2004-10-19 20:31:25
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-interfaces
     I have a problem. Trigger changes data in the table of this
     trigger. To avoid recursion I must disable this trigger or drop
     it. As I know postgres doesn't support disabling triggers. In the
     trigger I try drop it, but postgres does nothing a long time and it
     finishes only when I stop the postgres. What can I do to solve
     this problem?

Best regards,

pgsql-interfaces by date

Next:From: Peter ChekunaevDate: 2004-10-19 20:51:13
Subject: plperl & large objects
Previous:From: K. Richard PixleyDate: 2004-10-19 07:12:38
Subject: Er... what's up and what's current?

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