1 Parsed test spec with 2 sessions
3 starting permutation: s1a s1b s1c s1d s2a s2b s2c s2d
5 step s1b: ALTER TABLE a DISABLE TRIGGER t;
6 step s1c: ALTER TABLE a ENABLE TRIGGER t;
9 step s2b: SELECT * FROM a WHERE i = 1 LIMIT 1 FOR UPDATE;
13 step s2c: INSERT INTO a VALUES (0);
14 ERROR: duplicate key value violates unique constraint "a_pkey"
17 starting permutation: s1a s1b s1c s2a s1d s2b s2c s2d
19 step s1b: ALTER TABLE a DISABLE TRIGGER t;
20 step s1c: ALTER TABLE a ENABLE TRIGGER t;
23 step s2b: SELECT * FROM a WHERE i = 1 LIMIT 1 FOR UPDATE;
27 step s2c: INSERT INTO a VALUES (0);
28 ERROR: duplicate key value violates unique constraint "a_pkey"
31 starting permutation: s1a s1b s1c s2a s2b s1d s2c s2d
33 step s1b: ALTER TABLE a DISABLE TRIGGER t;
34 step s1c: ALTER TABLE a ENABLE TRIGGER t;
36 step s2b: SELECT * FROM a WHERE i = 1 LIMIT 1 FOR UPDATE;
41 step s2c: INSERT INTO a VALUES (0);
42 ERROR: duplicate key value violates unique constraint "a_pkey"
45 starting permutation: s1a s1b s1c s2a s2b s2c s1d s2d
47 step s1b: ALTER TABLE a DISABLE TRIGGER t;
48 step s1c: ALTER TABLE a ENABLE TRIGGER t;
50 step s2b: SELECT * FROM a WHERE i = 1 LIMIT 1 FOR UPDATE;
54 step s2c: INSERT INTO a VALUES (0); <waiting ...>
56 step s2c: <... completed>
57 error in steps s1d s2c: ERROR: duplicate key value violates unique constraint "a_pkey"
60 starting permutation: s1a s1b s1c s2a s2b s2c s2d s1d
62 step s1b: ALTER TABLE a DISABLE TRIGGER t;
63 step s1c: ALTER TABLE a ENABLE TRIGGER t;
65 step s2b: SELECT * FROM a WHERE i = 1 LIMIT 1 FOR UPDATE;
69 step s2c: INSERT INTO a VALUES (0); <waiting ...>
70 invalid permutation detected
72 starting permutation: s1a s1b s2a s1c s1d s2b s2c s2d
74 step s1b: ALTER TABLE a DISABLE TRIGGER t;
76 step s1c: ALTER TABLE a ENABLE TRIGGER t;
78 step s2b: SELECT * FROM a WHERE i = 1 LIMIT 1 FOR UPDATE;
82 step s2c: INSERT INTO a VALUES (0);
83 ERROR: duplicate key value violates unique constraint "a_pkey"
86 starting permutation: s1a s1b s2a s1c s2b s1d s2c s2d
88 step s1b: ALTER TABLE a DISABLE TRIGGER t;
90 step s1c: ALTER TABLE a ENABLE TRIGGER t;
91 step s2b: SELECT * FROM a WHERE i = 1 LIMIT 1 FOR UPDATE;
96 step s2c: INSERT INTO a VALUES (0);
97 ERROR: duplicate key value violates unique constraint "a_pkey"
100 starting permutation: s1a s1b s2a s1c s2b s2c s1d s2d
102 step s1b: ALTER TABLE a DISABLE TRIGGER t;
104 step s1c: ALTER TABLE a ENABLE TRIGGER t;
105 step s2b: SELECT * FROM a WHERE i = 1 LIMIT 1 FOR UPDATE;
109 step s2c: INSERT INTO a VALUES (0); <waiting ...>
111 step s2c: <... completed>
112 error in steps s1d s2c: ERROR: duplicate key value violates unique constraint "a_pkey"
115 starting permutation: s1a s1b s2a s1c s2b s2c s2d s1d
117 step s1b: ALTER TABLE a DISABLE TRIGGER t;
119 step s1c: ALTER TABLE a ENABLE TRIGGER t;
120 step s2b: SELECT * FROM a WHERE i = 1 LIMIT 1 FOR UPDATE;
124 step s2c: INSERT INTO a VALUES (0); <waiting ...>
125 invalid permutation detected
127 starting permutation: s1a s1b s2a s2b s1c s1d s2c s2d
129 step s1b: ALTER TABLE a DISABLE TRIGGER t;
131 step s2b: SELECT * FROM a WHERE i = 1 LIMIT 1 FOR UPDATE;
135 step s1c: ALTER TABLE a ENABLE TRIGGER t;
137 step s2c: INSERT INTO a VALUES (0);
138 ERROR: duplicate key value violates unique constraint "a_pkey"
141 starting permutation: s1a s1b s2a s2b s1c s2c s1d s2d
143 step s1b: ALTER TABLE a DISABLE TRIGGER t;
145 step s2b: SELECT * FROM a WHERE i = 1 LIMIT 1 FOR UPDATE;
149 step s1c: ALTER TABLE a ENABLE TRIGGER t;
150 step s2c: INSERT INTO a VALUES (0); <waiting ...>
152 step s2c: <... completed>
153 error in steps s1d s2c: ERROR: duplicate key value violates unique constraint "a_pkey"
156 starting permutation: s1a s1b s2a s2b s1c s2c s2d s1d
158 step s1b: ALTER TABLE a DISABLE TRIGGER t;
160 step s2b: SELECT * FROM a WHERE i = 1 LIMIT 1 FOR UPDATE;
164 step s1c: ALTER TABLE a ENABLE TRIGGER t;
165 step s2c: INSERT INTO a VALUES (0); <waiting ...>
166 invalid permutation detected
168 starting permutation: s1a s1b s2a s2b s2c s1c s1d s2d
170 step s1b: ALTER TABLE a DISABLE TRIGGER t;
172 step s2b: SELECT * FROM a WHERE i = 1 LIMIT 1 FOR UPDATE;
176 step s2c: INSERT INTO a VALUES (0); <waiting ...>
177 step s1c: ALTER TABLE a ENABLE TRIGGER t;
179 step s2c: <... completed>
180 error in steps s1d s2c: ERROR: duplicate key value violates unique constraint "a_pkey"
183 starting permutation: s1a s1b s2a s2b s2c s1c s2d s1d
185 step s1b: ALTER TABLE a DISABLE TRIGGER t;
187 step s2b: SELECT * FROM a WHERE i = 1 LIMIT 1 FOR UPDATE;
191 step s2c: INSERT INTO a VALUES (0); <waiting ...>
192 step s1c: ALTER TABLE a ENABLE TRIGGER t;
193 invalid permutation detected
195 starting permutation: s1a s1b s2a s2b s2c s2d s1c s1d
197 step s1b: ALTER TABLE a DISABLE TRIGGER t;
199 step s2b: SELECT * FROM a WHERE i = 1 LIMIT 1 FOR UPDATE;
203 step s2c: INSERT INTO a VALUES (0); <waiting ...>
204 invalid permutation detected
206 starting permutation: s1a s2a s1b s1c s1d s2b s2c s2d
209 step s1b: ALTER TABLE a DISABLE TRIGGER t;
210 step s1c: ALTER TABLE a ENABLE TRIGGER t;
212 step s2b: SELECT * FROM a WHERE i = 1 LIMIT 1 FOR UPDATE;
216 step s2c: INSERT INTO a VALUES (0);
217 ERROR: duplicate key value violates unique constraint "a_pkey"
220 starting permutation: s1a s2a s1b s1c s2b s1d s2c s2d
223 step s1b: ALTER TABLE a DISABLE TRIGGER t;
224 step s1c: ALTER TABLE a ENABLE TRIGGER t;
225 step s2b: SELECT * FROM a WHERE i = 1 LIMIT 1 FOR UPDATE;
230 step s2c: INSERT INTO a VALUES (0);
231 ERROR: duplicate key value violates unique constraint "a_pkey"
234 starting permutation: s1a s2a s1b s1c s2b s2c s1d s2d
237 step s1b: ALTER TABLE a DISABLE TRIGGER t;
238 step s1c: ALTER TABLE a ENABLE TRIGGER t;
239 step s2b: SELECT * FROM a WHERE i = 1 LIMIT 1 FOR UPDATE;
243 step s2c: INSERT INTO a VALUES (0); <waiting ...>
245 step s2c: <... completed>
246 error in steps s1d s2c: ERROR: duplicate key value violates unique constraint "a_pkey"
249 starting permutation: s1a s2a s1b s1c s2b s2c s2d s1d
252 step s1b: ALTER TABLE a DISABLE TRIGGER t;
253 step s1c: ALTER TABLE a ENABLE TRIGGER t;
254 step s2b: SELECT * FROM a WHERE i = 1 LIMIT 1 FOR UPDATE;
258 step s2c: INSERT INTO a VALUES (0); <waiting ...>
259 invalid permutation detected
261 starting permutation: s1a s2a s1b s2b s1c s1d s2c s2d
264 step s1b: ALTER TABLE a DISABLE TRIGGER t;
265 step s2b: SELECT * FROM a WHERE i = 1 LIMIT 1 FOR UPDATE;
269 step s1c: ALTER TABLE a ENABLE TRIGGER t;
271 step s2c: INSERT INTO a VALUES (0);
272 ERROR: duplicate key value violates unique constraint "a_pkey"
275 starting permutation: s1a s2a s1b s2b s1c s2c s1d s2d
278 step s1b: ALTER TABLE a DISABLE TRIGGER t;
279 step s2b: SELECT * FROM a WHERE i = 1 LIMIT 1 FOR UPDATE;
283 step s1c: ALTER TABLE a ENABLE TRIGGER t;
284 step s2c: INSERT INTO a VALUES (0); <waiting ...>
286 step s2c: <... completed>
287 error in steps s1d s2c: ERROR: duplicate key value violates unique constraint "a_pkey"
290 starting permutation: s1a s2a s1b s2b s1c s2c s2d s1d
293 step s1b: ALTER TABLE a DISABLE TRIGGER t;
294 step s2b: SELECT * FROM a WHERE i = 1 LIMIT 1 FOR UPDATE;
298 step s1c: ALTER TABLE a ENABLE TRIGGER t;
299 step s2c: INSERT INTO a VALUES (0); <waiting ...>
300 invalid permutation detected
302 starting permutation: s1a s2a s1b s2b s2c s1c s1d s2d
305 step s1b: ALTER TABLE a DISABLE TRIGGER t;
306 step s2b: SELECT * FROM a WHERE i = 1 LIMIT 1 FOR UPDATE;
310 step s2c: INSERT INTO a VALUES (0); <waiting ...>
311 step s1c: ALTER TABLE a ENABLE TRIGGER t;
313 step s2c: <... completed>
314 error in steps s1d s2c: ERROR: duplicate key value violates unique constraint "a_pkey"
317 starting permutation: s1a s2a s1b s2b s2c s1c s2d s1d
320 step s1b: ALTER TABLE a DISABLE TRIGGER t;
321 step s2b: SELECT * FROM a WHERE i = 1 LIMIT 1 FOR UPDATE;
325 step s2c: INSERT INTO a VALUES (0); <waiting ...>
326 step s1c: ALTER TABLE a ENABLE TRIGGER t;
327 invalid permutation detected
329 starting permutation: s1a s2a s1b s2b s2c s2d s1c s1d
332 step s1b: ALTER TABLE a DISABLE TRIGGER t;
333 step s2b: SELECT * FROM a WHERE i = 1 LIMIT 1 FOR UPDATE;
337 step s2c: INSERT INTO a VALUES (0); <waiting ...>
338 invalid permutation detected
340 starting permutation: s1a s2a s2b s1b s1c s1d s2c s2d
343 step s2b: SELECT * FROM a WHERE i = 1 LIMIT 1 FOR UPDATE;
347 step s1b: ALTER TABLE a DISABLE TRIGGER t;
348 step s1c: ALTER TABLE a ENABLE TRIGGER t;
350 step s2c: INSERT INTO a VALUES (0);
351 ERROR: duplicate key value violates unique constraint "a_pkey"
354 starting permutation: s1a s2a s2b s1b s1c s2c s1d s2d
357 step s2b: SELECT * FROM a WHERE i = 1 LIMIT 1 FOR UPDATE;
361 step s1b: ALTER TABLE a DISABLE TRIGGER t;
362 step s1c: ALTER TABLE a ENABLE TRIGGER t;
363 step s2c: INSERT INTO a VALUES (0); <waiting ...>
365 step s2c: <... completed>
366 error in steps s1d s2c: ERROR: duplicate key value violates unique constraint "a_pkey"
369 starting permutation: s1a s2a s2b s1b s1c s2c s2d s1d
372 step s2b: SELECT * FROM a WHERE i = 1 LIMIT 1 FOR UPDATE;
376 step s1b: ALTER TABLE a DISABLE TRIGGER t;
377 step s1c: ALTER TABLE a ENABLE TRIGGER t;
378 step s2c: INSERT INTO a VALUES (0); <waiting ...>
379 invalid permutation detected
381 starting permutation: s1a s2a s2b s1b s2c s1c s1d s2d
384 step s2b: SELECT * FROM a WHERE i = 1 LIMIT 1 FOR UPDATE;
388 step s1b: ALTER TABLE a DISABLE TRIGGER t;
389 step s2c: INSERT INTO a VALUES (0); <waiting ...>
390 step s1c: ALTER TABLE a ENABLE TRIGGER t;
392 step s2c: <... completed>
393 error in steps s1d s2c: ERROR: duplicate key value violates unique constraint "a_pkey"
396 starting permutation: s1a s2a s2b s1b s2c s1c s2d s1d
399 step s2b: SELECT * FROM a WHERE i = 1 LIMIT 1 FOR UPDATE;
403 step s1b: ALTER TABLE a DISABLE TRIGGER t;
404 step s2c: INSERT INTO a VALUES (0); <waiting ...>
405 step s1c: ALTER TABLE a ENABLE TRIGGER t;
406 invalid permutation detected
408 starting permutation: s1a s2a s2b s1b s2c s2d s1c s1d
411 step s2b: SELECT * FROM a WHERE i = 1 LIMIT 1 FOR UPDATE;
415 step s1b: ALTER TABLE a DISABLE TRIGGER t;
416 step s2c: INSERT INTO a VALUES (0); <waiting ...>
417 invalid permutation detected
419 starting permutation: s1a s2a s2b s2c s1b s1c s1d s2d
422 step s2b: SELECT * FROM a WHERE i = 1 LIMIT 1 FOR UPDATE;
426 step s2c: INSERT INTO a VALUES (0);
427 ERROR: duplicate key value violates unique constraint "a_pkey"
428 step s1b: ALTER TABLE a DISABLE TRIGGER t;
429 step s1c: ALTER TABLE a ENABLE TRIGGER t;
433 starting permutation: s1a s2a s2b s2c s1b s1c s2d s1d
436 step s2b: SELECT * FROM a WHERE i = 1 LIMIT 1 FOR UPDATE;
440 step s2c: INSERT INTO a VALUES (0);
441 ERROR: duplicate key value violates unique constraint "a_pkey"
442 step s1b: ALTER TABLE a DISABLE TRIGGER t;
443 step s1c: ALTER TABLE a ENABLE TRIGGER t;
447 starting permutation: s1a s2a s2b s2c s1b s2d s1c s1d
450 step s2b: SELECT * FROM a WHERE i = 1 LIMIT 1 FOR UPDATE;
454 step s2c: INSERT INTO a VALUES (0);
455 ERROR: duplicate key value violates unique constraint "a_pkey"
456 step s1b: ALTER TABLE a DISABLE TRIGGER t;
458 step s1c: ALTER TABLE a ENABLE TRIGGER t;
461 starting permutation: s1a s2a s2b s2c s2d s1b s1c s1d
464 step s2b: SELECT * FROM a WHERE i = 1 LIMIT 1 FOR UPDATE;
468 step s2c: INSERT INTO a VALUES (0);
469 ERROR: duplicate key value violates unique constraint "a_pkey"
471 step s1b: ALTER TABLE a DISABLE TRIGGER t;
472 step s1c: ALTER TABLE a ENABLE TRIGGER t;
475 starting permutation: s2a s1a s1b s1c s1d s2b s2c s2d
478 step s1b: ALTER TABLE a DISABLE TRIGGER t;
479 step s1c: ALTER TABLE a ENABLE TRIGGER t;
481 step s2b: SELECT * FROM a WHERE i = 1 LIMIT 1 FOR UPDATE;
485 step s2c: INSERT INTO a VALUES (0);
486 ERROR: duplicate key value violates unique constraint "a_pkey"
489 starting permutation: s2a s1a s1b s1c s2b s1d s2c s2d
492 step s1b: ALTER TABLE a DISABLE TRIGGER t;
493 step s1c: ALTER TABLE a ENABLE TRIGGER t;
494 step s2b: SELECT * FROM a WHERE i = 1 LIMIT 1 FOR UPDATE;
499 step s2c: INSERT INTO a VALUES (0);
500 ERROR: duplicate key value violates unique constraint "a_pkey"
503 starting permutation: s2a s1a s1b s1c s2b s2c s1d s2d
506 step s1b: ALTER TABLE a DISABLE TRIGGER t;
507 step s1c: ALTER TABLE a ENABLE TRIGGER t;
508 step s2b: SELECT * FROM a WHERE i = 1 LIMIT 1 FOR UPDATE;
512 step s2c: INSERT INTO a VALUES (0); <waiting ...>
514 step s2c: <... completed>
515 error in steps s1d s2c: ERROR: duplicate key value violates unique constraint "a_pkey"
518 starting permutation: s2a s1a s1b s1c s2b s2c s2d s1d
521 step s1b: ALTER TABLE a DISABLE TRIGGER t;
522 step s1c: ALTER TABLE a ENABLE TRIGGER t;
523 step s2b: SELECT * FROM a WHERE i = 1 LIMIT 1 FOR UPDATE;
527 step s2c: INSERT INTO a VALUES (0); <waiting ...>
528 invalid permutation detected
530 starting permutation: s2a s1a s1b s2b s1c s1d s2c s2d
533 step s1b: ALTER TABLE a DISABLE TRIGGER t;
534 step s2b: SELECT * FROM a WHERE i = 1 LIMIT 1 FOR UPDATE;
538 step s1c: ALTER TABLE a ENABLE TRIGGER t;
540 step s2c: INSERT INTO a VALUES (0);
541 ERROR: duplicate key value violates unique constraint "a_pkey"
544 starting permutation: s2a s1a s1b s2b s1c s2c s1d s2d
547 step s1b: ALTER TABLE a DISABLE TRIGGER t;
548 step s2b: SELECT * FROM a WHERE i = 1 LIMIT 1 FOR UPDATE;
552 step s1c: ALTER TABLE a ENABLE TRIGGER t;
553 step s2c: INSERT INTO a VALUES (0); <waiting ...>
555 step s2c: <... completed>
556 error in steps s1d s2c: ERROR: duplicate key value violates unique constraint "a_pkey"
559 starting permutation: s2a s1a s1b s2b s1c s2c s2d s1d
562 step s1b: ALTER TABLE a DISABLE TRIGGER t;
563 step s2b: SELECT * FROM a WHERE i = 1 LIMIT 1 FOR UPDATE;
567 step s1c: ALTER TABLE a ENABLE TRIGGER t;
568 step s2c: INSERT INTO a VALUES (0); <waiting ...>
569 invalid permutation detected
571 starting permutation: s2a s1a s1b s2b s2c s1c s1d s2d
574 step s1b: ALTER TABLE a DISABLE TRIGGER t;
575 step s2b: SELECT * FROM a WHERE i = 1 LIMIT 1 FOR UPDATE;
579 step s2c: INSERT INTO a VALUES (0); <waiting ...>
580 step s1c: ALTER TABLE a ENABLE TRIGGER t;
582 step s2c: <... completed>
583 error in steps s1d s2c: ERROR: duplicate key value violates unique constraint "a_pkey"
586 starting permutation: s2a s1a s1b s2b s2c s1c s2d s1d
589 step s1b: ALTER TABLE a DISABLE TRIGGER t;
590 step s2b: SELECT * FROM a WHERE i = 1 LIMIT 1 FOR UPDATE;
594 step s2c: INSERT INTO a VALUES (0); <waiting ...>
595 step s1c: ALTER TABLE a ENABLE TRIGGER t;
596 invalid permutation detected
598 starting permutation: s2a s1a s1b s2b s2c s2d s1c s1d
601 step s1b: ALTER TABLE a DISABLE TRIGGER t;
602 step s2b: SELECT * FROM a WHERE i = 1 LIMIT 1 FOR UPDATE;
606 step s2c: INSERT INTO a VALUES (0); <waiting ...>
607 invalid permutation detected
609 starting permutation: s2a s1a s2b s1b s1c s1d s2c s2d
612 step s2b: SELECT * FROM a WHERE i = 1 LIMIT 1 FOR UPDATE;
616 step s1b: ALTER TABLE a DISABLE TRIGGER t;
617 step s1c: ALTER TABLE a ENABLE TRIGGER t;
619 step s2c: INSERT INTO a VALUES (0);
620 ERROR: duplicate key value violates unique constraint "a_pkey"
623 starting permutation: s2a s1a s2b s1b s1c s2c s1d s2d
626 step s2b: SELECT * FROM a WHERE i = 1 LIMIT 1 FOR UPDATE;
630 step s1b: ALTER TABLE a DISABLE TRIGGER t;
631 step s1c: ALTER TABLE a ENABLE TRIGGER t;
632 step s2c: INSERT INTO a VALUES (0); <waiting ...>
634 step s2c: <... completed>
635 error in steps s1d s2c: ERROR: duplicate key value violates unique constraint "a_pkey"
638 starting permutation: s2a s1a s2b s1b s1c s2c s2d s1d
641 step s2b: SELECT * FROM a WHERE i = 1 LIMIT 1 FOR UPDATE;
645 step s1b: ALTER TABLE a DISABLE TRIGGER t;
646 step s1c: ALTER TABLE a ENABLE TRIGGER t;
647 step s2c: INSERT INTO a VALUES (0); <waiting ...>
648 invalid permutation detected
650 starting permutation: s2a s1a s2b s1b s2c s1c s1d s2d
653 step s2b: SELECT * FROM a WHERE i = 1 LIMIT 1 FOR UPDATE;
657 step s1b: ALTER TABLE a DISABLE TRIGGER t;
658 step s2c: INSERT INTO a VALUES (0); <waiting ...>
659 step s1c: ALTER TABLE a ENABLE TRIGGER t;
661 step s2c: <... completed>
662 error in steps s1d s2c: ERROR: duplicate key value violates unique constraint "a_pkey"
665 starting permutation: s2a s1a s2b s1b s2c s1c s2d s1d
668 step s2b: SELECT * FROM a WHERE i = 1 LIMIT 1 FOR UPDATE;
672 step s1b: ALTER TABLE a DISABLE TRIGGER t;
673 step s2c: INSERT INTO a VALUES (0); <waiting ...>
674 step s1c: ALTER TABLE a ENABLE TRIGGER t;
675 invalid permutation detected
677 starting permutation: s2a s1a s2b s1b s2c s2d s1c s1d
680 step s2b: SELECT * FROM a WHERE i = 1 LIMIT 1 FOR UPDATE;
684 step s1b: ALTER TABLE a DISABLE TRIGGER t;
685 step s2c: INSERT INTO a VALUES (0); <waiting ...>
686 invalid permutation detected
688 starting permutation: s2a s1a s2b s2c s1b s1c s1d s2d
691 step s2b: SELECT * FROM a WHERE i = 1 LIMIT 1 FOR UPDATE;
695 step s2c: INSERT INTO a VALUES (0);
696 ERROR: duplicate key value violates unique constraint "a_pkey"
697 step s1b: ALTER TABLE a DISABLE TRIGGER t;
698 step s1c: ALTER TABLE a ENABLE TRIGGER t;
702 starting permutation: s2a s1a s2b s2c s1b s1c s2d s1d
705 step s2b: SELECT * FROM a WHERE i = 1 LIMIT 1 FOR UPDATE;
709 step s2c: INSERT INTO a VALUES (0);
710 ERROR: duplicate key value violates unique constraint "a_pkey"
711 step s1b: ALTER TABLE a DISABLE TRIGGER t;
712 step s1c: ALTER TABLE a ENABLE TRIGGER t;
716 starting permutation: s2a s1a s2b s2c s1b s2d s1c s1d
719 step s2b: SELECT * FROM a WHERE i = 1 LIMIT 1 FOR UPDATE;
723 step s2c: INSERT INTO a VALUES (0);
724 ERROR: duplicate key value violates unique constraint "a_pkey"
725 step s1b: ALTER TABLE a DISABLE TRIGGER t;
727 step s1c: ALTER TABLE a ENABLE TRIGGER t;
730 starting permutation: s2a s1a s2b s2c s2d s1b s1c s1d
733 step s2b: SELECT * FROM a WHERE i = 1 LIMIT 1 FOR UPDATE;
737 step s2c: INSERT INTO a VALUES (0);
738 ERROR: duplicate key value violates unique constraint "a_pkey"
740 step s1b: ALTER TABLE a DISABLE TRIGGER t;
741 step s1c: ALTER TABLE a ENABLE TRIGGER t;
744 starting permutation: s2a s2b s1a s1b s1c s1d s2c s2d
746 step s2b: SELECT * FROM a WHERE i = 1 LIMIT 1 FOR UPDATE;
751 step s1b: ALTER TABLE a DISABLE TRIGGER t;
752 step s1c: ALTER TABLE a ENABLE TRIGGER t;
754 step s2c: INSERT INTO a VALUES (0);
755 ERROR: duplicate key value violates unique constraint "a_pkey"
758 starting permutation: s2a s2b s1a s1b s1c s2c s1d s2d
760 step s2b: SELECT * FROM a WHERE i = 1 LIMIT 1 FOR UPDATE;
765 step s1b: ALTER TABLE a DISABLE TRIGGER t;
766 step s1c: ALTER TABLE a ENABLE TRIGGER t;
767 step s2c: INSERT INTO a VALUES (0); <waiting ...>
769 step s2c: <... completed>
770 error in steps s1d s2c: ERROR: duplicate key value violates unique constraint "a_pkey"
773 starting permutation: s2a s2b s1a s1b s1c s2c s2d s1d
775 step s2b: SELECT * FROM a WHERE i = 1 LIMIT 1 FOR UPDATE;
780 step s1b: ALTER TABLE a DISABLE TRIGGER t;
781 step s1c: ALTER TABLE a ENABLE TRIGGER t;
782 step s2c: INSERT INTO a VALUES (0); <waiting ...>
783 invalid permutation detected
785 starting permutation: s2a s2b s1a s1b s2c s1c s1d s2d
787 step s2b: SELECT * FROM a WHERE i = 1 LIMIT 1 FOR UPDATE;
792 step s1b: ALTER TABLE a DISABLE TRIGGER t;
793 step s2c: INSERT INTO a VALUES (0); <waiting ...>
794 step s1c: ALTER TABLE a ENABLE TRIGGER t;
796 step s2c: <... completed>
797 error in steps s1d s2c: ERROR: duplicate key value violates unique constraint "a_pkey"
800 starting permutation: s2a s2b s1a s1b s2c s1c s2d s1d
802 step s2b: SELECT * FROM a WHERE i = 1 LIMIT 1 FOR UPDATE;
807 step s1b: ALTER TABLE a DISABLE TRIGGER t;
808 step s2c: INSERT INTO a VALUES (0); <waiting ...>
809 step s1c: ALTER TABLE a ENABLE TRIGGER t;
810 invalid permutation detected
812 starting permutation: s2a s2b s1a s1b s2c s2d s1c s1d
814 step s2b: SELECT * FROM a WHERE i = 1 LIMIT 1 FOR UPDATE;
819 step s1b: ALTER TABLE a DISABLE TRIGGER t;
820 step s2c: INSERT INTO a VALUES (0); <waiting ...>
821 invalid permutation detected
823 starting permutation: s2a s2b s1a s2c s1b s1c s1d s2d
825 step s2b: SELECT * FROM a WHERE i = 1 LIMIT 1 FOR UPDATE;
830 step s2c: INSERT INTO a VALUES (0);
831 ERROR: duplicate key value violates unique constraint "a_pkey"
832 step s1b: ALTER TABLE a DISABLE TRIGGER t;
833 step s1c: ALTER TABLE a ENABLE TRIGGER t;
837 starting permutation: s2a s2b s1a s2c s1b s1c s2d s1d
839 step s2b: SELECT * FROM a WHERE i = 1 LIMIT 1 FOR UPDATE;
844 step s2c: INSERT INTO a VALUES (0);
845 ERROR: duplicate key value violates unique constraint "a_pkey"
846 step s1b: ALTER TABLE a DISABLE TRIGGER t;
847 step s1c: ALTER TABLE a ENABLE TRIGGER t;
851 starting permutation: s2a s2b s1a s2c s1b s2d s1c s1d
853 step s2b: SELECT * FROM a WHERE i = 1 LIMIT 1 FOR UPDATE;
858 step s2c: INSERT INTO a VALUES (0);
859 ERROR: duplicate key value violates unique constraint "a_pkey"
860 step s1b: ALTER TABLE a DISABLE TRIGGER t;
862 step s1c: ALTER TABLE a ENABLE TRIGGER t;
865 starting permutation: s2a s2b s1a s2c s2d s1b s1c s1d
867 step s2b: SELECT * FROM a WHERE i = 1 LIMIT 1 FOR UPDATE;
872 step s2c: INSERT INTO a VALUES (0);
873 ERROR: duplicate key value violates unique constraint "a_pkey"
875 step s1b: ALTER TABLE a DISABLE TRIGGER t;
876 step s1c: ALTER TABLE a ENABLE TRIGGER t;
879 starting permutation: s2a s2b s2c s1a s1b s1c s1d s2d
881 step s2b: SELECT * FROM a WHERE i = 1 LIMIT 1 FOR UPDATE;
885 step s2c: INSERT INTO a VALUES (0);
886 ERROR: duplicate key value violates unique constraint "a_pkey"
888 step s1b: ALTER TABLE a DISABLE TRIGGER t;
889 step s1c: ALTER TABLE a ENABLE TRIGGER t;
893 starting permutation: s2a s2b s2c s1a s1b s1c s2d s1d
895 step s2b: SELECT * FROM a WHERE i = 1 LIMIT 1 FOR UPDATE;
899 step s2c: INSERT INTO a VALUES (0);
900 ERROR: duplicate key value violates unique constraint "a_pkey"
902 step s1b: ALTER TABLE a DISABLE TRIGGER t;
903 step s1c: ALTER TABLE a ENABLE TRIGGER t;
907 starting permutation: s2a s2b s2c s1a s1b s2d s1c s1d
909 step s2b: SELECT * FROM a WHERE i = 1 LIMIT 1 FOR UPDATE;
913 step s2c: INSERT INTO a VALUES (0);
914 ERROR: duplicate key value violates unique constraint "a_pkey"
916 step s1b: ALTER TABLE a DISABLE TRIGGER t;
918 step s1c: ALTER TABLE a ENABLE TRIGGER t;
921 starting permutation: s2a s2b s2c s1a s2d s1b s1c s1d
923 step s2b: SELECT * FROM a WHERE i = 1 LIMIT 1 FOR UPDATE;
927 step s2c: INSERT INTO a VALUES (0);
928 ERROR: duplicate key value violates unique constraint "a_pkey"
931 step s1b: ALTER TABLE a DISABLE TRIGGER t;
932 step s1c: ALTER TABLE a ENABLE TRIGGER t;
935 starting permutation: s2a s2b s2c s2d s1a s1b s1c s1d
937 step s2b: SELECT * FROM a WHERE i = 1 LIMIT 1 FOR UPDATE;
941 step s2c: INSERT INTO a VALUES (0);
942 ERROR: duplicate key value violates unique constraint "a_pkey"
945 step s1b: ALTER TABLE a DISABLE TRIGGER t;
946 step s1c: ALTER TABLE a ENABLE TRIGGER t;