Re: loop on trigger - Mailing list pgsql-general

From Richard Huxton
Subject Re: loop on trigger
Date
Msg-id 20010419082916.498292A3AB@mainbox.archonet.com
Whole thread Raw
In response to loop on trigger  (mgermoni@uniautomation.it)
List pgsql-general
mgermoni@uniautomation.it said:

> following your indication I found what I was looking for...Thank you.
>
> I made a simple trigger/function that:
> on insert check if a particular field is already on one table if not it
> will procede to make the insert otherwise not.
> But it goes on loop. Now just because I do not have experience, I'm
> wondering if it possible to do it without going in loop, because if the
> trigger is build up to get fired before the action and inside itself,
> actualy, there is again the continuos of the action it is called again
> and so on. There is a method to do without using the same table to
> do the control and then the action? In other words interception an
> insert to a specific table if the control is true to procede with the
> action itself without hitting any loop?
> TX

Had the same problem myself. I don't believe there is a way to "short-circuit"
the loop.

See if you can't replace the trigger with a view and a couple of rules. You'll
need one rule to handle the default case and a second to deal with the special
case.

If you need more information, could you please provide the details of your
tables and trigger.

HTH

- Richard Huxton

pgsql-general by date:

Previous
From: Adam Rossi
Date:
Subject: 7.1 RPM has old JDBC driver - SQL statement too long
Next
From: Matthew Hixson
Date:
Subject: syntax error 44 : ->