Re: [GENERAL] Plperl & create contstraint trigger

2007-06-13 Thread Tom Lane
"Chris Coleman" <[EMAIL PROTECTED]> writes: > When I run the trigger then this error appears in the logs: > FATAL: BeginInternalSubTransaction: unexpected state END See http://archives.postgresql.org/pgsql-committers/2007-05/msg00383.php regards, tom lane ---

[GENERAL] Plperl & create contstraint trigger

2007-06-13 Thread Chris Coleman
Hi, I have written a trigger in plperl (I could not use pgsql due to the nature of the trigger). I know CREATE CONSTRAINT TRIGGER is not intended for general use, but it is pretty important that this trigger be run on commit of the transaction, as it needs to use data in other tables that can onl