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.