pgsql-server/src backend/access/heap/heapam.c ... - Mailing list pgsql-committers

CVSROOT:    /cvsroot
Module name:    pgsql-server
Changes by:    tgl@svr1.postgresql.org    03/10/01 18:30:53

Modified files:
    src/backend/access/heap: heapam.c
    src/backend/commands: async.c
    src/backend/executor: execMain.c execUtils.c nodeSubplan.c
                          nodeSubqueryscan.c spi.c
    src/backend/storage/ipc: sinval.c
    src/backend/utils/adt: ri_triggers.c
    src/backend/utils/time: tqual.c
    src/include/access: heapam.h
    src/include/executor: executor.h spi.h
    src/include/nodes: execnodes.h
    src/include/utils: tqual.h

Log message:
    Repair RI trigger visibility problems (this time for sure ;-)) per recent
    discussion on pgsql-hackers: in READ COMMITTED mode we just have to force
    a QuerySnapshot update in the trigger, but in SERIALIZABLE mode we have
    to run the scan under a current snapshot and then complain if any rows
    would be updated/deleted that are not visible in the transaction snapshot.