• Tom Lane's avatar
    Fire non-deferred AFTER triggers immediately upon query completion, · b339d1ff
    Tom Lane authored
    rather than when returning to the idle loop.  This makes no particular
    difference for interactively-issued queries, but it makes a big difference
    for queries issued within functions: trigger execution now occurs before
    the calling function is allowed to proceed.  This responds to numerous
    complaints about nonintuitive behavior of foreign key checking, such as
    http://archives.postgresql.org/pgsql-bugs/2004-09/msg00020.php, and
    appears to be required by the SQL99 spec.
    Also take the opportunity to simplify the data structures used for the
    pending-trigger list, rename them for more clarity, and squeeze out a
    bit of space.
    b339d1ff
portalcmds.c 11.8 KB