From Stephan Szabo:
Tom Lane <tgl@sss.pgh.pa.us>
From Stephan Szabo: I believe this should fix the issue that Philip Warner noticed about the check for unique constraints meeting the referenced keys of a foreign key constraint allowing the specification of a subset of a foreign key instead of rejecting it. I also added tests for a base case of this to the foreign key and alter table tests and patches for expected output.
Files
| Path | Change | +/− |
|---|---|---|
| src/backend/commands/command.c | modified | +22 −15 |
| src/backend/parser/analyze.c | modified | +37 −24 |
| src/test/regress/expected/alter_table.out | modified | +10 −0 |
| src/test/regress/expected/foreign_key.out | modified | +9 −0 |
| src/test/regress/sql/alter_table.sql | modified | +13 −0 |
| src/test/regress/sql/foreign_key.sql | modified | +7 −0 |