Generate a WARNING when the column types in a foreign key constraint are
Tom Lane <tgl@sss.pgh.pa.us>
Generate a WARNING when the column types in a foreign key constraint are incompatible enough to prevent indexscanning the referenced table. Also, improve the error message that pops out when we can't implement the FK at all for lack of a usable equality operator. Fabien Coelho, with some review by Tom Lane.
Files
| Path | Change | +/− |
|---|---|---|
| src/backend/commands/tablecmds.c | modified | +72 −22 |
| src/test/regress/expected/alter_table.out | modified | +16 −12 |
| src/test/regress/expected/foreign_key.out | modified | +111 −40 |
| src/test/regress/sql/foreign_key.sql | modified | +72 −2 |