Allow CHECK constraints to be declared ONLY
Alvaro Herrera <alvherre@alvh.no-ip.org>
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
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/catalogs.sgml | modified | +10 −0 |
| doc/src/sgml/ref/alter_table.sgml | modified | +8 −0 |
| src/backend/catalog/heap.c | modified | +19 −9 |
| src/backend/catalog/index.c | modified | +2 −1 |
| src/backend/catalog/pg_constraint.c | modified | +3 −1 |
| src/backend/commands/tablecmds.c | modified | +35 −15 |
| src/backend/commands/trigger.c | modified | +2 −1 |
| src/backend/commands/typecmds.c | modified | +2 −1 |
| src/backend/utils/cache/relcache.c | modified | +1 −0 |
| src/bin/pg_dump/pg_dump.c | modified | +29 −15 |
| src/bin/pg_dump/pg_dump.h | modified | +1 −0 |
| src/bin/psql/describe.c | modified | +14 −5 |
| src/include/access/tupdesc.h | modified | +1 −0 |
| src/include/catalog/heap.h | modified | +3 −1 |
| src/include/catalog/pg_constraint.h | modified | +15 −10 |
| src/test/regress/expected/alter_table.out | modified | +10 −11 |
| src/test/regress/expected/inherit.out | modified | +35 −0 |
| src/test/regress/sql/alter_table.sql | modified | +7 −8 |
| src/test/regress/sql/inherit.sql | modified | +14 −0 |