git.postgresql.org Git - postgresql.git/commit

git projects / postgresql.git / commit

Fix for possible referential integrity violation when a qualified ON INSERT

author Jan Wieck <JanWieck@Yahoo.com>

2003年10月31日 03:58:21 +0000 (03:58 +0000)

committer Jan Wieck <JanWieck@Yahoo.com>

2003年10月31日 03:58:21 +0000 (03:58 +0000)

commit cc4baf4da380ae010975cc8be4db09e27833da21

tree 1364c5ff179359d5b5505b984d7f9a56170355d4 tree

parent e181001764185e2d6e8a5d755c021e2c63c600dd commit | diff

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

src/backend/utils/adt/ri_triggers.c diff | blob | blame | history

src/test/regress/expected/foreign_key.out diff | blob | blame | history

src/test/regress/sql/foreign_key.sql diff | blob | blame | history

This is the main PostgreSQL git repository.

RSS Atom