git.postgresql.org Git - postgresql.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	25d9bf2e3e66ee2e546c5c523d148ecab6ee1dcc
tree	b0dee0f1d6111fd6658d432ec30e5ddb88adc02f	tree
parent	850490579318ff52097eec92ce535357dd0c7a3a	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

This is the main PostgreSQL git repository.

RSS Atom