How to disable trigger within itself? (to prevent recursion/loop)

#1

Hello

I have this trigger which ON INSERT inserts more rows into the very
same table it "sits" on. To avoid an INSERT-recursion I would like to
disable all triggers on that table from within my trigger-function.
But what I get is an ERROR saying that I can not alter table because
it is being used.
Is there something I can do about this?
(I do have a workadound, there is one field by which I can tell
whether the insert comes from a trigger or not.)

Best regards
J. Záruba

#2

Jaroslav Záruba wrote:

Quote:

I have this trigger which ON INSERT inserts more rows into the very
same table it "sits" on. To avoid an INSERT-recursion I would like to
disable all triggers on that table from within my trigger-function.
But what I get is an ERROR saying that I can not alter table because
it is being used.
Is there something I can do about this?
(I do have a workadound, there is one field by which I can tell
whether the insert comes from a trigger or not.)

Your workaround is the only option I can think of.

Yours,
Laurenz Albe

#3

On Nov 11, 4:11*pm, "Laurenz Albe" <inv... (AT) spam (DOT) to.invalid> wrote:

Quote:

Jaroslav Záruba wrote:
I have this trigger which ON INSERT inserts more rows into the very
same table it "sits" on. To avoid an INSERT-recursion I would like to
disable all triggers on that table from within my trigger-function.
But what I get is an ERROR saying that I can not alter table because
it is being used.
Is there something I can do about this?
(I do have a workadound, there is one field by which I can tell
whether the insert comes from a trigger or not.)

Your workaround is the only option I can think of.

Yours,
Laurenz Albe

OK, thank you.

regards
JZ

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

How to disable trigger within itself? (to prevent recursion/loop)

comp.databases.postgresql comp.databases.postgresql

How to disable trigger within itself? (to prevent recursion/loop) - 11-11-2009 , 03:39 AM

Re: How to disable trigger within itself? (to prevent recursion/loop) - 11-11-2009 , 09:11 AM

Re: How to disable trigger within itself? (to prevent recursion/loop) - 11-11-2009 , 09:21 AM