Hello Tom,
in the mean time I've traced the problem down to a 'CONSTRAINT' declared
as 'DEFERRABLE INITIALLY DEFERED'. As soon as I remove that constraint
the transaction commits nicely. BTW: I'm running in ISOLATION LEVEL
SERIALIZABLE, if that matters.
Has something changed so that it's worth trying current CVS? I'll try to
come up with a test case, the problem is not easy to isolate, though.
Regards
Markus
Tom Lane wrote:
Markus Schiltknecht <[EMAIL PROTECTED]> writes:
I'm getting the following error from my python script, which tries to
insert lots of data in one transaction:
libpq.OperationalError: ERROR: failed to fetch new tuple for AFTER trigger
That's not supposed to happen. Can you provide a test case?
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
