On 8/22/06, marcelo Cortez <jmdc_marcelo@xxxxxxxxxxxx> wrote:
I think my trigger need transaction ,but the pgsql compiler refuse to compile 'begin .. commit ' sequence I use the perform , to do the works
Stored functions already execute inside the context of some already-running transaction. You don't run multiple transactions inside a function. Further, when this is a trigger function, there is a very clear transaction with which the activity of the trigger is already associated. If you were to start another transaction at the point where you try to do so, that would break the processing of any further triggers that might run after this one... -- http://www3.sympatico.ca/cbbrowne/linux.html Oddly enough, this is completely standard behaviour for shells. This is a roundabout way of saying `don't use combined chains of `&&'s and `||'s unless you think Gödel's theorem is for sissies'.
