Re: unknown error message

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 <markus@bluegap.ch> 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 majordomo@postgresql.org so that your
>        message can get through to the mailing list cleanly
>