pgsql: Remove incomplete/incorrect support for zero-column foreign keys - Mailing list pgsql-committers

From Tom Lane
Subject pgsql: Remove incomplete/incorrect support for zero-column foreign keys
Date
Msg-id E1ShV3u-00077B-JH@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Remove incomplete/incorrect support for zero-column foreign keys.

The original coding in ri_triggers.c had partial support for the concept of
zero-column foreign key constraints.  But this is not defined in the SQL
standard, nor was it ever allowed by any other part of Postgres, nor was it
very fully implemented even here (eg there was no support for preventing
PK-table deletions that would violate the constraint).  Doesn't seem very
useful to carry 100-plus lines of code for a corner case that no one is
interested in making work.  Instead, just add a check that the column list
read from pg_constraint is non-empty.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/dfd9c116cc3ebaf42f895b9b16a9ff69bb21664b

Modified Files
--------------
src/backend/utils/adt/ri_triggers.c |  154 ++---------------------------------
1 files changed, 7 insertions(+), 147 deletions(-)


pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: pgsql: Increase MAX_SYSCACHE_CALLBACKS from 20 to 32.
Next
From: Heikki Linnakangas
Date:
Subject: pgsql: Add a small cache of locks owned by a resource owner in Resource