]> git.ipfire.org Git - thirdparty/postgresql.git/commit
projects / thirdparty / postgresql.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: e181001) | patch
Fix for possible referential integrity violation when a qualified ON INSERT
authorJan Wieck <JanWieck@Yahoo.com>
Fri, 31 Oct 2003 03:58:21 +0000 (03:58 +0000)
committerJan Wieck <JanWieck@Yahoo.com>
Fri, 31 Oct 2003 03:58:21 +0000 (03:58 +0000)
commitcc4baf4da380ae010975cc8be4db09e27833da21
tree1364c5ff179359d5b5505b984d7f9a56170355d4tree | snapshot
parente181001764185e2d6e8a5d755c021e2c63c600ddcommit | 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
Mirror of https://git.postgresql.org/git/postgresql.git