|
387 | 387 |
|
388 | 388 | 'CREATE SEQUENCE regress_pg_dump_table_col1_seq' => { |
389 | 389 | regexp => qr/^ |
390 | | -\QCREATE SEQUENCE public.regress_pg_dump_table_col1_seq\E |
391 | | -\n\s+\QAS integer\E |
392 | | -\n\s+\QSTART WITH 1\E |
393 | | -\n\s+\QINCREMENT BY 1\E |
394 | | -\n\s+\QNO MINVALUE\E |
395 | | -\n\s+\QNO MAXVALUE\E |
396 | | -\n\s+\QCACHE 1;\E |
397 | | -\n/xm, |
| 390 | +\QCREATE SEQUENCE public.regress_pg_dump_table_col1_seq\E |
| 391 | +\n\s+\QAS integer\E |
| 392 | +\n\s+\QSTART WITH 1\E |
| 393 | +\n\s+\QINCREMENT BY 1\E |
| 394 | +\n\s+\QNO MINVALUE\E |
| 395 | +\n\s+\QNO MAXVALUE\E |
| 396 | +\n\s+\QCACHE 1;\E |
| 397 | +\n/xm, |
398 | 398 | like => { binary_upgrade => 1, }, |
399 | 399 | }, |
400 | 400 |
|
|
412 | 412 |
|
413 | 413 | 'CREATE SEQUENCE regress_pg_dump_seq' => { |
414 | 414 | regexp => qr/^ |
415 | | -\QCREATE SEQUENCE public.regress_pg_dump_seq\E |
416 | | -\n\s+\QSTART WITH 1\E |
417 | | -\n\s+\QINCREMENT BY 1\E |
418 | | -\n\s+\QNO MINVALUE\E |
419 | | -\n\s+\QNO MAXVALUE\E |
420 | | -\n\s+\QCACHE 1;\E |
421 | | -\n/xm, |
| 415 | +\QCREATE SEQUENCE public.regress_pg_dump_seq\E |
| 416 | +\n\s+\QSTART WITH 1\E |
| 417 | +\n\s+\QINCREMENT BY 1\E |
| 418 | +\n\s+\QNO MINVALUE\E |
| 419 | +\n\s+\QNO MAXVALUE\E |
| 420 | +\n\s+\QCACHE 1;\E |
| 421 | +\n/xm, |
422 | 422 | like => { binary_upgrade => 1, }, |
423 | 423 | }, |
424 | 424 |
|
|
642 | 642 |
|
643 | 643 | 'CREATE SEQUENCE regress_pg_dump_schema.test_seq' => { |
644 | 644 | regexp => qr/^ |
645 | | -\QCREATE SEQUENCE regress_pg_dump_schema.test_seq\E |
646 | | -\n\s+\QSTART WITH 1\E |
647 | | -\n\s+\QINCREMENT BY 1\E |
648 | | -\n\s+\QNO MINVALUE\E |
649 | | -\n\s+\QNO MAXVALUE\E |
650 | | -\n\s+\QCACHE 1;\E |
651 | | -\n/xm, |
| 645 | +\QCREATE SEQUENCE regress_pg_dump_schema.test_seq\E |
| 646 | +\n\s+\QSTART WITH 1\E |
| 647 | +\n\s+\QINCREMENT BY 1\E |
| 648 | +\n\s+\QNO MINVALUE\E |
| 649 | +\n\s+\QNO MAXVALUE\E |
| 650 | +\n\s+\QCACHE 1;\E |
| 651 | +\n/xm, |
652 | 652 | like => { binary_upgrade => 1, }, |
653 | 653 | }, |
654 | 654 |
|
|
663 | 663 |
|
664 | 664 | 'CREATE TYPE regress_pg_dump_schema.test_type' => { |
665 | 665 | regexp => qr/^ |
666 | | -\QCREATE TYPE regress_pg_dump_schema.test_type AS (\E |
667 | | -\n\s+\Qcol1 integer\E |
668 | | -\n\);\n/xm, |
| 666 | +\QCREATE TYPE regress_pg_dump_schema.test_type AS (\E |
| 667 | +\n\s+\Qcol1 integer\E |
| 668 | +\n\);\n/xm, |
669 | 669 | like => { binary_upgrade => 1, }, |
670 | 670 | }, |
671 | 671 |
|
|
680 | 680 |
|
681 | 681 | 'CREATE FUNCTION regress_pg_dump_schema.test_func' => { |
682 | 682 | regexp => qr/^ |
683 | | -\QCREATE FUNCTION regress_pg_dump_schema.test_func() RETURNS integer\E |
684 | | -\n\s+\QLANGUAGE sql\E |
685 | | -\n/xm, |
| 683 | +\QCREATE FUNCTION regress_pg_dump_schema.test_func() RETURNS integer\E |
| 684 | +\n\s+\QLANGUAGE sql\E |
| 685 | +\n/xm, |
686 | 686 | like => { binary_upgrade => 1, }, |
687 | 687 | }, |
688 | 688 |
|
|
697 | 697 |
|
698 | 698 | 'CREATE AGGREGATE regress_pg_dump_schema.test_agg' => { |
699 | 699 | regexp => qr/^ |
700 | | -\QCREATE AGGREGATE regress_pg_dump_schema.test_agg(smallint) (\E |
701 | | -\n\s+\QSFUNC = int2_sum,\E |
702 | | -\n\s+\QSTYPE = bigint\E |
703 | | -\n\);\n/xm, |
| 700 | +\QCREATE AGGREGATE regress_pg_dump_schema.test_agg(smallint) (\E |
| 701 | +\n\s+\QSFUNC = int2_sum,\E |
| 702 | +\n\s+\QSTYPE = bigint\E |
| 703 | +\n\);\n/xm, |
704 | 704 | like => { binary_upgrade => 1, }, |
705 | 705 | }, |
706 | 706 |
|
|