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.
