git.osdn.net Git - pg-rex/syncrep.git/commit

author	Tom Lane <tgl@sss.pgh.pa.us>
	Wed, 1 Oct 2003 21:30:53 +0000 (21:30 +0000)
committer	Tom Lane <tgl@sss.pgh.pa.us>
	Wed, 1 Oct 2003 21:30:53 +0000 (21:30 +0000)
commit	55d85f42a891a812a9bbd69ebe530651a2f31624
tree	cc2cb842242c7f683b73f6ac297a9939eb031976	tree \| snapshot
parent	6099bc03f34b02fd5cf99f4187c9c6c189cd3c66	commit \| diff

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.

15 files changed:

src/backend/access/heap/heapam.c		diff \| blob \| history
src/backend/commands/async.c		diff \| blob \| history
src/backend/executor/execMain.c		diff \| blob \| history
src/backend/executor/execUtils.c		diff \| blob \| history
src/backend/executor/nodeSubplan.c		diff \| blob \| history
src/backend/executor/nodeSubqueryscan.c		diff \| blob \| history
src/backend/executor/spi.c		diff \| blob \| history
src/backend/storage/ipc/sinval.c		diff \| blob \| history
src/backend/utils/adt/ri_triggers.c		diff \| blob \| history
src/backend/utils/time/tqual.c		diff \| blob \| history
src/include/access/heapam.h		diff \| blob \| history
src/include/executor/executor.h		diff \| blob \| history
src/include/executor/spi.h		diff \| blob \| history
src/include/nodes/execnodes.h		diff \| blob \| history
src/include/utils/tqual.h		diff \| blob \| history

PostgreSQL9.0用の同期レプリケーションパッチ

RSS Atom

About OSDN

Find Software

Develop Software

Help