/
githubmirror
/
postgres
Обзор
Документация
Войти
/
githubmirror
/
postgres
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
src/test/isolation/expected/fk-partitioned-1.out
133 строки
5 KB
Tom Lane
Change the names generated for child foreign key constraints.
23 апр 2025, 19:03
23 апр 2025, 19:03
3db61db
Код
Авторство
О чём код?
Parsed test spec with 2 sessions starting permutation: s1b s1d s1c s2b s2a s2c step s1b: begin; step s1d: delete from ppk1 where a = 1; step s1c: commit; step s2b: begin; step s2a: alter table pfk attach partition pfk1 for values in (1); ERROR: insert or update on table "pfk1" violates foreign key constraint "pfk_a_fkey" step s2c: commit; starting permutation: s1b s1d s2b s1c s2a s2c step s1b: begin; step s1d: delete from ppk1 where a = 1; step s2b: begin; step s1c: commit; step s2a: alter table pfk attach partition pfk1 for values in (1); ERROR: insert or update on table "pfk1" violates foreign key constraint "pfk_a_fkey" step s2c: commit; starting permutation: s1b s1d s2b s2a s1c s2c step s1b: begin; step s1d: delete from ppk1 where a = 1; step s2b: begin; step s2a: alter table pfk attach partition pfk1 for values in (1); <waiting ...> step s1c: commit; step s2a: <... completed> ERROR: insert or update on table "pfk1" violates foreign key constraint "pfk_a_fkey" step s2c: commit; starting permutation: s1b s2b s1d s1c s2a s2c step s1b: begin; step s2b: begin; step s1d: delete from ppk1 where a = 1; step s1c: commit; step s2a: alter table pfk attach partition pfk1 for values in (1); ERROR: insert or update on table "pfk1" violates foreign key constraint "pfk_a_fkey" step s2c: commit; starting permutation: s1b s2b s1d s2a s1c s2c step s1b: begin; step s2b: begin; step s1d: delete from ppk1 where a = 1; step s2a: alter table pfk attach partition pfk1 for values in (1); <waiting ...> step s1c: commit; step s2a: <... completed> ERROR: insert or update on table "pfk1" violates foreign key constraint "pfk_a_fkey" step s2c: commit; starting permutation: s1b s2b s2a s1d s2c s1c step s1b: begin; step s2b: begin; step s2a: alter table pfk attach partition pfk1 for values in (1); step s1d: delete from ppk1 where a = 1; <waiting ...> step s2c: commit; step s1d: <... completed> ERROR: update or delete on table "ppk1" violates foreign key constraint "pfk_a_fkey_1" on table "pfk" step s1c: commit; starting permutation: s1b s2b s2a s2c s1d s1c step s1b: begin; step s2b: begin; step s2a: alter table pfk attach partition pfk1 for values in (1); step s2c: commit; step s1d: delete from ppk1 where a = 1; ERROR: update or delete on table "ppk1" violates foreign key constraint "pfk_a_fkey_1" on table "pfk" step s1c: commit; starting permutation: s2b s1b s1d s1c s2a s2c step s2b: begin; step s1b: begin; step s1d: delete from ppk1 where a = 1; step s1c: commit; step s2a: alter table pfk attach partition pfk1 for values in (1); ERROR: insert or update on table "pfk1" violates foreign key constraint "pfk_a_fkey" step s2c: commit; starting permutation: s2b s1b s1d s2a s1c s2c step s2b: begin; step s1b: begin; step s1d: delete from ppk1 where a = 1; step s2a: alter table pfk attach partition pfk1 for values in (1); <waiting ...> step s1c: commit; step s2a: <... completed> ERROR: insert or update on table "pfk1" violates foreign key constraint "pfk_a_fkey" step s2c: commit; starting permutation: s2b s1b s2a s1d s2c s1c step s2b: begin; step s1b: begin; step s2a: alter table pfk attach partition pfk1 for values in (1); step s1d: delete from ppk1 where a = 1; <waiting ...> step s2c: commit; step s1d: <... completed> ERROR: update or delete on table "ppk1" violates foreign key constraint "pfk_a_fkey_1" on table "pfk" step s1c: commit; starting permutation: s2b s1b s2a s2c s1d s1c step s2b: begin; step s1b: begin; step s2a: alter table pfk attach partition pfk1 for values in (1); step s2c: commit; step s1d: delete from ppk1 where a = 1; ERROR: update or delete on table "ppk1" violates foreign key constraint "pfk_a_fkey_1" on table "pfk" step s1c: commit; starting permutation: s2b s2a s1b s1d s2c s1c step s2b: begin; step s2a: alter table pfk attach partition pfk1 for values in (1); step s1b: begin; step s1d: delete from ppk1 where a = 1; <waiting ...> step s2c: commit; step s1d: <... completed> ERROR: update or delete on table "ppk1" violates foreign key constraint "pfk_a_fkey_1" on table "pfk" step s1c: commit; starting permutation: s2b s2a s1b s2c s1d s1c step s2b: begin; step s2a: alter table pfk attach partition pfk1 for values in (1); step s1b: begin; step s2c: commit; step s1d: delete from ppk1 where a = 1; ERROR: update or delete on table "ppk1" violates foreign key constraint "pfk_a_fkey_1" on table "pfk" step s1c: commit; starting permutation: s2b s2a s2c s1b s1d s1c step s2b: begin; step s2a: alter table pfk attach partition pfk1 for values in (1); step s2c: commit; step s1b: begin; step s1d: delete from ppk1 where a = 1; ERROR: update or delete on table "ppk1" violates foreign key constraint "pfk_a_fkey_1" on table "pfk" step s1c: commit;