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

projects / users / andresfreund / postgres.git / commit

author	Alvaro Herrera <alvherre@alvh.no-ip.org>
	Mon, 5 Dec 2011 18:10:18 +0000 (15:10 -0300)
committer	Alvaro Herrera <alvherre@alvh.no-ip.org>
	Mon, 19 Dec 2011 20:30:23 +0000 (17:30 -0300)
commit	61d81bd28dbec65a6b144e0cd3d0bfe25913c3ac
tree	bc99d53c06bed6dcc146f7eb97babba998eb5e1d	tree
parent	92203624934095163f8b57b5b3d7bbd2645da2c8	commit \| diff

Allow CHECK constraints to be declared ONLY

This makes them enforceable only on the parent table, not on children
tables. This is useful in various situations, per discussion involving
people bitten by the restrictive behavior introduced in 8.4.

Message-Id:
8762mp93iw.fsf@comcast.net
CAFaPBrSMMpubkGf4zcRL_YL-AERUbYF_-ZNNYfb3CVwwEqc9TQ@mail.gmail.com

Authors: Nikhil Sontakke, Alex Hunsaker
Reviewed by Robert Haas and myself

19 files changed:

doc/src/sgml/catalogs.sgml		diff \| blob \| blame \| history
doc/src/sgml/ref/alter_table.sgml		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/pg_constraint.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/commands/typecmds.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/tupdesc.h		diff \| blob \| blame \| history
src/include/catalog/heap.h		diff \| blob \| blame \| history
src/include/catalog/pg_constraint.h		diff \| blob \| blame \| history
src/test/regress/expected/alter_table.out		diff \| blob \| blame \| history
src/test/regress/expected/inherit.out		diff \| blob \| blame \| history
src/test/regress/sql/alter_table.sql		diff \| blob \| blame \| history
src/test/regress/sql/inherit.sql		diff \| blob \| blame \| history

Andres' PG stuff

RSS Atom