Обсуждение: pgsql-server/src backend/utils/adt/ri_triggers ...

Поиск
Список
Период
Сортировка

pgsql-server/src backend/utils/adt/ri_triggers ...

От
wieck@svr1.postgresql.org (Jan Wieck)
Дата:
CVSROOT:    /cvsroot
Module name:    pgsql-server
Changes by:    wieck@svr1.postgresql.org    03/10/30 23:58:21

Modified files:
    src/backend/utils/adt: ri_triggers.c
    src/test/regress/expected: foreign_key.out
    src/test/regress/sql: foreign_key.sql

Log message:
    Fix for possible referential integrity violation when a qualified ON INSERT
    rule split the query into one INSERT and one UPDATE where the UPDATE
    then hit's the just created row without modifying the key fields again.
    In this special case, the new key slipped in totally unchecked.

    Jan