|
591 | 591 | section_post_data => 1,
|
592 | 592 | },
|
593 | 593 | },
|
594 |
| - 'BLOB load (contents are of test_table)' => { |
595 |
| - create_order => 14, |
596 |
| - create_sql => |
597 |
| - "\\o '$tempdir/large_object_test.sql'\n" |
598 |
| - . "table dump_test.test_table;\n" |
599 |
| - . "\\o\n" |
600 |
| - . "\\lo_import '$tempdir/large_object_test.sql'\n", |
601 |
| - regexp => qr/^ |
602 |
| - \QSELECT pg_catalog.lo_open\E \('\d+',\ \d+\);\n |
603 |
| - \QSELECT pg_catalog.lowrite(0, \E |
604 |
| - \Q'\x310a320a330a340a350a360a370a380a390a');\E\n |
605 |
| - \QSELECT pg_catalog.lo_close(0);\E |
606 |
| - $/xm, |
607 |
| - like => { |
608 |
| - clean => 1, |
609 |
| - clean_if_exists => 1, |
610 |
| - createdb => 1, |
611 |
| - defaults => 1, |
612 |
| - exclude_dump_test_schema => 1, |
613 |
| - exclude_test_table => 1, |
614 |
| - exclude_test_table_data => 1, |
615 |
| - no_privs => 1, |
616 |
| - section_data => 1, |
617 |
| - test_schema_plus_blobs => 1, |
618 |
| - }, |
619 |
| - unlike => { |
620 |
| - binary_upgrade => 1, |
621 |
| - only_dump_test_schema => 1, |
622 |
| - only_dump_test_table => 1, |
623 |
| - pg_dumpall_globals => 1, |
624 |
| - schema_only => 1, |
625 |
| - section_post_data => 1, |
626 |
| - }, |
627 |
| - }, |
| 594 | +# 'BLOB load (contents are of test_table)' => { |
| 595 | +# create_order => 14, |
| 596 | +# create_sql => |
| 597 | +# "\\o '$tempdir/large_object_test.sql'\n" |
| 598 | +# . "table dump_test.test_table;\n" |
| 599 | +# . "\\o\n" |
| 600 | +# . "\\lo_import '$tempdir/large_object_test.sql'\n", |
| 601 | +# regexp => qr/^ |
| 602 | +# \QSELECT pg_catalog.lo_open\E \('\d+',\ \d+\);\n |
| 603 | +# \QSELECT pg_catalog.lowrite(0, \E |
| 604 | +# \Q'\x310a320a330a340a350a360a370a380a390a');\E\n |
| 605 | +# \QSELECT pg_catalog.lo_close(0);\E |
| 606 | +# $/xm, |
| 607 | +# like => { |
| 608 | +# clean => 1, |
| 609 | +# clean_if_exists => 1, |
| 610 | +# createdb => 1, |
| 611 | +# defaults => 1, |
| 612 | +# exclude_dump_test_schema => 1, |
| 613 | +# exclude_test_table => 1, |
| 614 | +# exclude_test_table_data => 1, |
| 615 | +# no_privs => 1, |
| 616 | +# section_data => 1, |
| 617 | +# test_schema_plus_blobs => 1, |
| 618 | +# }, |
| 619 | +# unlike => { |
| 620 | +# binary_upgrade => 1, |
| 621 | +# only_dump_test_schema => 1, |
| 622 | +# only_dump_test_table => 1, |
| 623 | +# pg_dumpall_globals => 1, |
| 624 | +# schema_only => 1, |
| 625 | +# section_post_data => 1, |
| 626 | +# }, |
| 627 | +# }, |
628 | 628 | 'COMMENT ON DATABASE postgres' => {
|
629 | 629 | regexp => qr/^COMMENT ON DATABASE postgres IS .*;$/m,
|
630 | 630 | like => {
|
|
0 commit comments