Thread: pgsql: Fix overly-strict sanity check in BeginInternalSubTransaction

pgsql: Fix overly-strict sanity check in BeginInternalSubTransaction

From
tgl@postgresql.org (Tom Lane)
Date:
Log Message:
-----------
Fix overly-strict sanity check in BeginInternalSubTransaction that made it
fail when used in a deferred trigger.  Bug goes back to 8.0; no doubt the
reason it hadn't been noticed is that we've been discouraging use of
user-defined constraint triggers.  Per report from Frank van Vugt.

Modified Files:
--------------
    pgsql/src/backend/access/transam:
        xact.c (r1.243 -> r1.244)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/transam/xact.c.diff?r1=1.243&r2=1.244)

Re: pgsql: Fix overly-strict sanity check in BeginInternalSubTransaction

From
Heikki Linnakangas
Date:
Tom Lane wrote:
> Log Message:
> -----------
> Fix overly-strict sanity check in BeginInternalSubTransaction that made it
> fail when used in a deferred trigger.  Bug goes back to 8.0; no doubt the
> reason it hadn't been noticed is that we've been discouraging use of
> user-defined constraint triggers.  Per report from Frank van Vugt.

Since no-one seems to be testing that, should we add a regression test?

--
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com