git.postgresql.org Git - users/simon/postgres.git/commit

projects / users / simon / postgres.git / commit

author	Tom Lane <tgl@sss.pgh.pa.us>
	Wed, 29 Jul 2009 20:56:21 +0000 (20:56 +0000)
committer	Tom Lane <tgl@sss.pgh.pa.us>
	Wed, 29 Jul 2009 20:56:21 +0000 (20:56 +0000)
commit	576b0fac11e853810ac12ca47e9aa3a215ff7983
tree	fa653959a972cf8a37990b1c4b8a67d2a5fff381	tree
parent	2ffae8405d8d2578af0625350c46bf4919455452	commit \| diff

Support deferrable uniqueness constraints.

The current implementation fires an AFTER ROW trigger for each tuple that
looks like it might be non-unique according to the index contents at the
time of insertion. This works well as long as there aren't many conflicts,
but won't scale to massive unique-key reassignments. Improving that case
is a TODO item.

Dean Rasheed

51 files changed:

doc/src/sgml/catalogs.sgml		diff \| blob \| blame \| history
doc/src/sgml/indexam.sgml		diff \| blob \| blame \| history
doc/src/sgml/ref/create_table.sgml		diff \| blob \| blame \| history
doc/src/sgml/ref/set_constraints.sgml		diff \| blob \| blame \| history
src/backend/access/gin/gininsert.c		diff \| blob \| blame \| history
src/backend/access/gist/gist.c		diff \| blob \| blame \| history
src/backend/access/hash/hash.c		diff \| blob \| blame \| history
src/backend/access/heap/tuptoaster.c		diff \| blob \| blame \| history
src/backend/access/index/indexam.c		diff \| blob \| blame \| history
src/backend/access/nbtree/nbtinsert.c		diff \| blob \| blame \| history
src/backend/access/nbtree/nbtree.c		diff \| blob \| blame \| history
src/backend/bootstrap/bootparse.y		diff \| blob \| blame \| history
src/backend/catalog/index.c		diff \| blob \| blame \| history
src/backend/catalog/indexing.c		diff \| blob \| blame \| history
src/backend/catalog/sql_features.txt		diff \| blob \| blame \| history
src/backend/catalog/toasting.c		diff \| blob \| blame \| history
src/backend/commands/Makefile		diff \| blob \| blame \| history
src/backend/commands/constraint.c	[new file with mode: 0644]	blob
src/backend/commands/copy.c		diff \| blob \| blame \| history
src/backend/commands/indexcmds.c		diff \| blob \| blame \| history
src/backend/commands/tablecmds.c		diff \| blob \| blame \| history
src/backend/commands/trigger.c		diff \| blob \| blame \| history
src/backend/executor/execMain.c		diff \| blob \| blame \| history
src/backend/executor/execUtils.c		diff \| blob \| blame \| history
src/backend/nodes/copyfuncs.c		diff \| blob \| blame \| history
src/backend/nodes/equalfuncs.c		diff \| blob \| blame \| history
src/backend/nodes/outfuncs.c		diff \| blob \| blame \| history
src/backend/parser/gram.y		diff \| blob \| blame \| history
src/backend/parser/parse_utilcmd.c		diff \| blob \| blame \| history
src/backend/tcop/utility.c		diff \| blob \| blame \| history
src/backend/utils/adt/ruleutils.c		diff \| blob \| blame \| history
src/backend/utils/cache/relcache.c		diff \| blob \| blame \| history
src/bin/pg_dump/pg_dump.c		diff \| blob \| blame \| history
src/bin/pg_dump/pg_dump.h		diff \| blob \| blame \| history
src/bin/psql/describe.c		diff \| blob \| blame \| history
src/include/access/genam.h		diff \| blob \| blame \| history
src/include/access/nbtree.h		diff \| blob \| blame \| history
src/include/catalog/catversion.h		diff \| blob \| blame \| history
src/include/catalog/index.h		diff \| blob \| blame \| history
src/include/catalog/pg_attribute.h		diff \| blob \| blame \| history
src/include/catalog/pg_index.h		diff \| blob \| blame \| history
src/include/catalog/pg_proc.h		diff \| blob \| blame \| history
src/include/commands/defrem.h		diff \| blob \| blame \| history
src/include/commands/trigger.h		diff \| blob \| blame \| history
src/include/executor/executor.h		diff \| blob \| blame \| history
src/include/nodes/parsenodes.h		diff \| blob \| blame \| history
src/include/utils/builtins.h		diff \| blob \| blame \| history
src/test/regress/expected/sanity_check.out		diff \| blob \| blame \| history
src/test/regress/input/constraints.source		diff \| blob \| blame \| history
src/test/regress/output/constraints.source		diff \| blob \| blame \| history
src/test/regress/sql/sanity_check.sql		diff \| blob \| blame \| history

Simon's dev repository

RSS Atom