git.postgresql.org Git - postgresql.git/commit

author	Tom Lane <tgl@sss.pgh.pa.us>
	Mon, 7 Dec 2009 05:22:23 +0000 (05:22 +0000)
committer	Tom Lane <tgl@sss.pgh.pa.us>
	Mon, 7 Dec 2009 05:22:23 +0000 (05:22 +0000)
commit	0cb65564e5f855b1e9aa145fd645352130f74646
tree	badcc3ee73a16d472f9e637246589d6b803e620f	tree
parent	8de7472b45859108761223fb19b396efaa8f0a4d	commit \| diff

Add exclusion constraints, which generalize the concept of uniqueness to
support any indexable commutative operator, not just equality. Two rows
violate the exclusion constraint if "row1.col OP row2.col" is TRUE for
each of the columns in the constraint.

Jeff Davis, reviewed by Robert Haas

43 files changed:

doc/src/sgml/catalogs.sgml		diff \| blob \| blame \| history
doc/src/sgml/errcodes.sgml		diff \| blob \| blame \| history
doc/src/sgml/ref/create_table.sgml		diff \| blob \| blame \| history
src/backend/access/index/genam.c		diff \| blob \| blame \| history
src/backend/bootstrap/bootparse.y		diff \| blob \| blame \| history
src/backend/bootstrap/bootstrap.c		diff \| blob \| blame \| history
src/backend/catalog/heap.c		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/information_schema.sql		diff \| blob \| blame \| history
src/backend/catalog/pg_constraint.c		diff \| blob \| blame \| history
src/backend/catalog/toasting.c		diff \| blob \| blame \| history
src/backend/commands/constraint.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/typecmds.c		diff \| blob \| blame \| history
src/backend/commands/vacuum.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/psql/describe.c		diff \| blob \| blame \| history
src/include/catalog/catversion.h		diff \| blob \| blame \| history
src/include/catalog/pg_attribute.h		diff \| blob \| blame \| history
src/include/catalog/pg_class.h		diff \| blob \| blame \| history
src/include/catalog/pg_constraint.h		diff \| blob \| blame \| history
src/include/commands/defrem.h		diff \| blob \| blame \| history
src/include/executor/executor.h		diff \| blob \| blame \| history
src/include/nodes/execnodes.h		diff \| blob \| blame \| history
src/include/nodes/parsenodes.h		diff \| blob \| blame \| history
src/include/parser/kwlist.h		diff \| blob \| blame \| history
src/include/utils/errcodes.h		diff \| blob \| blame \| history
src/include/utils/rel.h		diff \| blob \| blame \| history
src/include/utils/relcache.h		diff \| blob \| blame \| history
src/pl/plpgsql/src/plerrcodes.h		diff \| blob \| blame \| history
src/test/regress/input/constraints.source		diff \| blob \| blame \| history
src/test/regress/output/constraints.source		diff \| blob \| blame \| history

This is the main PostgreSQL git repository.

RSS Atom