Allow specifying column list for foreign key ON DELETE SET src_test_regress_sql_foreign_key.sql don't understand the comment.
git.postgresql.org Git - postgresql.git/commit
<https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=d6f96ed94e73052f99a2e545ed17a8b2fdc1fb8a>
git.postgresql.org Git - postgresql.git/blob -
src/test/regress/expected/foreign_key.out
<https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/test/regress/expected/foreign_key.out;h=4c5274983d48b21ff7d4eaee192672d05f9b7c08;hb=d6f96ed94e73052f99a2e545ed17a8b2fdc1fb8a>
1330
<https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/test/regress/expected/foreign_key.out;h=4c5274983d48b21ff7d4eaee192672d05f9b7c08;hb=d6f96ed94e73052f99a2e545ed17a8b2fdc1fb8a#l1330>
-- could fail with only 2 changes to make, if row was already updated
1331
<https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/test/regress/expected/foreign_key.out;h=4c5274983d48b21ff7d4eaee192672d05f9b7c08;hb=d6f96ed94e73052f99a2e545ed17a8b2fdc1fb8a#l1331>
BEGIN;
1332
<https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/test/regress/expected/foreign_key.out;h=4c5274983d48b21ff7d4eaee192672d05f9b7c08;hb=d6f96ed94e73052f99a2e545ed17a8b2fdc1fb8a#l1332>
UPDATE tasks set id=id WHERE id=2;
1333
<https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/test/regress/expected/foreign_key.out;h=4c5274983d48b21ff7d4eaee192672d05f9b7c08;hb=d6f96ed94e73052f99a2e545ed17a8b2fdc1fb8a#l1333>
SELECT * FROM tasks;
1334
<https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/test/regress/expected/foreign_key.out;h=4c5274983d48b21ff7d4eaee192672d05f9b7c08;hb=d6f96ed94e73052f99a2e545ed17a8b2fdc1fb8a#l1334>
id | owner | worker | checked_by
1335
<https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/test/regress/expected/foreign_key.out;h=4c5274983d48b21ff7d4eaee192672d05f9b7c08;hb=d6f96ed94e73052f99a2e545ed17a8b2fdc1fb8a#l1335>
----+-------+--------+------------
1336
<https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/test/regress/expected/foreign_key.out;h=4c5274983d48b21ff7d4eaee192672d05f9b7c08;hb=d6f96ed94e73052f99a2e545ed17a8b2fdc1fb8a#l1336>
1 | 1 | |
1337
<https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/test/regress/expected/foreign_key.out;h=4c5274983d48b21ff7d4eaee192672d05f9b7c08;hb=d6f96ed94e73052f99a2e545ed17a8b2fdc1fb8a#l1337>
3 | | |
1338
<https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/test/regress/expected/foreign_key.out;h=4c5274983d48b21ff7d4eaee192672d05f9b7c08;hb=d6f96ed94e73052f99a2e545ed17a8b2fdc1fb8a#l1338>
2 | 2 | 2 |
1339
<https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/test/regress/expected/foreign_key.out;h=4c5274983d48b21ff7d4eaee192672d05f9b7c08;hb=d6f96ed94e73052f99a2e545ed17a8b2fdc1fb8a#l1339>
(3 rows)
1340
<https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/test/regress/expected/foreign_key.out;h=4c5274983d48b21ff7d4eaee192672d05f9b7c08;hb=d6f96ed94e73052f99a2e545ed17a8b2fdc1fb8a#l1340>
1341
<https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/test/regress/expected/foreign_key.out;h=4c5274983d48b21ff7d4eaee192672d05f9b7c08;hb=d6f96ed94e73052f99a2e545ed17a8b2fdc1fb8a#l1341>
DELETE FROM users WHERE id = 2;
1342
<https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/test/regress/expected/foreign_key.out;h=4c5274983d48b21ff7d4eaee192672d05f9b7c08;hb=d6f96ed94e73052f99a2e545ed17a8b2fdc1fb8a#l1342>
SELECT * FROM tasks;
1343
<https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/test/regress/expected/foreign_key.out;h=4c5274983d48b21ff7d4eaee192672d05f9b7c08;hb=d6f96ed94e73052f99a2e545ed17a8b2fdc1fb8a#l1343>
id | owner | worker | checked_by
1344
<https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/test/regress/expected/foreign_key.out;h=4c5274983d48b21ff7d4eaee192672d05f9b7c08;hb=d6f96ed94e73052f99a2e545ed17a8b2fdc1fb8a#l1344>
----+-------+--------+------------
1345
<https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/test/regress/expected/foreign_key.out;h=4c5274983d48b21ff7d4eaee192672d05f9b7c08;hb=d6f96ed94e73052f99a2e545ed17a8b2fdc1fb8a#l1345>
1 | 1 | |
1346
<https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/test/regress/expected/foreign_key.out;h=4c5274983d48b21ff7d4eaee192672d05f9b7c08;hb=d6f96ed94e73052f99a2e545ed17a8b2fdc1fb8a#l1346>
3 | | |
1347
<https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/test/regress/expected/foreign_key.out;h=4c5274983d48b21ff7d4eaee192672d05f9b7c08;hb=d6f96ed94e73052f99a2e545ed17a8b2fdc1fb8a#l1347>
2 | | |
1348
<https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/test/regress/expected/foreign_key.out;h=4c5274983d48b21ff7d4eaee192672d05f9b7c08;hb=d6f96ed94e73052f99a2e545ed17a8b2fdc1fb8a#l1348>
(3 rows)
1349
<https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/test/regress/expected/foreign_key.out;h=4c5274983d48b21ff7d4eaee192672d05f9b7c08;hb=d6f96ed94e73052f99a2e545ed17a8b2fdc1fb8a#l1349>
1350
<https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/test/regress/expected/foreign_key.out;h=4c5274983d48b21ff7d4eaee192672d05f9b7c08;hb=d6f96ed94e73052f99a2e545ed17a8b2fdc1fb8a#l1350>
COMMIT;
I don't understand the comment *-- could fail with only 2 changes to
make, if row was already updated
*mean.
Since now the code block didn't yield any error.