diff options
| author | Tom Lane | 2003-05-21 18:14:46 +0000 |
|---|---|---|
| committer | Tom Lane | 2003-05-21 18:14:46 +0000 |
| commit | 3284e342a27f699f3908204f6c76492faeabd525 (patch) | |
| tree | afc8fe2d98acb636f79befb9383a1ed5c6fe6ed2 /src/test | |
| parent | af1850fc1a052e9c3613eff091349b9af244c3f7 (diff) | |
Back-patch Jan's fix to avoid primary key lookup (and lock) if foreign key
does not change on UPDATE.
Diffstat (limited to 'src/test')
| -rw-r--r-- | src/test/regress/expected/foreign_key.out | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/src/test/regress/expected/foreign_key.out b/src/test/regress/expected/foreign_key.out index a68a406fdac..3c2ede0aaa3 100644 --- a/src/test/regress/expected/foreign_key.out +++ b/src/test/regress/expected/foreign_key.out @@ -882,7 +882,7 @@ delete from pktable where base1=2; ERROR: $1 referential integrity violation - key in pktable still referenced from pktable -- fails (1,1) is being referenced (twice) update pktable set base1=3 where base1=1; -ERROR: $1 referential integrity violation - key referenced from pktable not found in pktable +ERROR: $1 referential integrity violation - key in pktable still referenced from pktable -- this sequence of two deletes will work, since after the first there will be no (2,*) references delete from pktable where base2=2; delete from pktable where base1=2; |