CVSROOT: /cvsroot
Module name: pgsql-server
Changes by: [EMAIL PROTECTED] 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.
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
