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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема pgsql: Remove incomplete/incorrect support for zero-column foreign keys
Дата
Msg-id E1ShV3u-00077B-JH@gemulon.postgresql.org
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: pgsql: Increase MAX_SYSCACHE_CALLBACKS from 20 to 32.
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: pgsql: Add a small cache of locks owned by a resource owner in Resource