Frank van Vugt <[EMAIL PROTECTED]> writes:
> FATAL:  BeginInternalSubTransaction: unexpected state END

Hmm, do you get the impression that user-written constraint triggers
aren't very well tested ;-) ?

It looks to me like BeginInternalSubTransaction simply needs to allow
TBLOCK_END (and TBLOCK_PREPARE too) as acceptable initial states,
because these could be seen by a function executed during COMMIT or
PREPARE TRANSACTION-time processing of deferred triggers.  I think that
the other states it rejects are OK, because we don't try to execute any
user-written code while transiting through those TBLOCK states.

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

Reply via email to