# Checking port 24136
# Found port 24136
Name: main
Version: 19devel
Data directory: C:\cirrus\build/testrun/pg_dump/002_pg_dump\data/t_002_pg_dump_main_data/pgdata
Backup directory: C:\cirrus\build/testrun/pg_dump/002_pg_dump\data/t_002_pg_dump_main_data/backup
Archive directory: C:\cirrus\build/testrun/pg_dump/002_pg_dump\data/t_002_pg_dump_main_data/archives
Connection string: port=24136 host=C:/Windows/TEMP/N_25rGKpCC
Log file: C:\cirrus\build/testrun/pg_dump/002_pg_dump\log/002_pg_dump_main.log
[14:06:41.814](0.178s) # initializing database system by copying initdb template
# Running: robocopy /E /NJS /NJH /NFL /NDL /NP C:/cirrus/build/tmp_install/initdb-template C:\cirrus\build/testrun/pg_dump/002_pg_dump\data/t_002_pg_dump_main_data/pgdata

# Running: C:\cirrus\build\src/test\regress\pg_regress.exe --config-auth C:\cirrus\build/testrun/pg_dump/002_pg_dump\data/t_002_pg_dump_main_data/pgdata
### Starting node "main"
# Running: pg_ctl --wait --pgdata C:\cirrus\build/testrun/pg_dump/002_pg_dump\data/t_002_pg_dump_main_data/pgdata --log C:\cirrus\build/testrun/pg_dump/002_pg_dump\log/002_pg_dump_main.log --options --cluster-name=main start
waiting for server to start.... done
server started
# Postmaster PID for node "main" is 6732
#### Begin standard error
psql:<stdin>:42: NOTICE:  merging column "col1" with inherited definition
psql:<stdin>:42: NOTICE:  merging column "col2" with inherited definition
psql:<stdin>:252: NOTICE:  return type dump_test.int42 is only a shell
psql:<stdin>:256: NOTICE:  argument type dump_test.int42 is only a shell
LINE 1: CREATE FUNCTION dump_test.int42_out(dump_test.int42)
                                            ^
psql:<stdin>:333: WARNING:  logical decoding must be enabled to publish logical changes
HINT:  Before creating subscriptions, ensure that "wal_level" is set to "replica" or higher.
psql:<stdin>:335: WARNING:  logical decoding must be enabled to publish logical changes
HINT:  Before creating subscriptions, ensure that "wal_level" is set to "replica" or higher.
psql:<stdin>:339: WARNING:  logical decoding must be enabled to publish logical changes
HINT:  Before creating subscriptions, ensure that "wal_level" is set to "replica" or higher.
psql:<stdin>:343: WARNING:  subscription was created, but is not connected
HINT:  To initiate replication, you must manually create the replication slot, enable the subscription, and alter the subscription to refresh publications.
psql:<stdin>:347: WARNING:  logical decoding must be enabled to publish logical changes
HINT:  Before creating subscriptions, ensure that "wal_level" is set to "replica" or higher.
psql:<stdin>:349: WARNING:  logical decoding must be enabled to publish logical changes
HINT:  Before creating subscriptions, ensure that "wal_level" is set to "replica" or higher.
psql:<stdin>:353: WARNING:  subscription was created, but is not connected
HINT:  To initiate replication, you must manually create the replication slot, enable the subscription, and alter the subscription to refresh publications.
psql:<stdin>:356: WARNING:  logical decoding must be enabled to publish logical changes
HINT:  Before creating subscriptions, ensure that "wal_level" is set to "replica" or higher.
psql:<stdin>:358: WARNING:  logical decoding must be enabled to publish logical changes
HINT:  Before creating subscriptions, ensure that "wal_level" is set to "replica" or higher.
psql:<stdin>:362: WARNING:  subscription was created, but is not connected
HINT:  To initiate replication, you must manually create the replication slot, enable the subscription, and alter the subscription to refresh publications.
psql:<stdin>:364: WARNING:  logical decoding must be enabled to publish logical changes
HINT:  Before creating subscriptions, ensure that "wal_level" is set to "replica" or higher.
psql:<stdin>:368: NOTICE:  publication parameters are not applicable to sequence synchronization and will be ignored for sequences
psql:<stdin>:368: WARNING:  logical decoding must be enabled to publish logical changes
HINT:  Before creating subscriptions, ensure that "wal_level" is set to "replica" or higher.
psql:<stdin>:584: NOTICE:  merging column "col1" with inherited definition
psql:<stdin>:586: WARNING:  logical decoding must be enabled to publish logical changes
HINT:  Before creating subscriptions, ensure that "wal_level" is set to "replica" or higher.
psql:<stdin>:680: NOTICE:  merging column "col1" with inherited definition
psql:<stdin>:682: NOTICE:  merging multiple inherited definitions of column "col1"
#### End standard error
# Running: pg_dump --port 24136 qqq
[14:06:48.443](6.629s) ok 1 - connecting to a non-existent database: exit code not 0
[14:06:48.443](0.000s) ok 2 - connecting to a non-existent database: matches
# Running: pg_dump --dbname regression_invalid
[14:06:48.559](0.115s) ok 3 - connecting to an invalid database: exit code not 0
[14:06:48.559](0.000s) ok 4 - connecting to an invalid database: matches
# Running: pg_dump --port 24136 --role regress_dump_test_role
[14:06:48.736](0.177s) ok 5 - connecting with an unprivileged user: exit code not 0
[14:06:48.737](0.001s) ok 6 - connecting with an unprivileged user: matches
# Running: pg_dump --port 24136 --schema nonexistent
[14:06:48.900](0.163s) ok 7 - dumping a non-existent schema: exit code not 0
[14:06:48.900](0.000s) ok 8 - dumping a non-existent schema: matches
# Running: pg_dump --port 24136 --table nonexistent
[14:06:49.023](0.123s) ok 9 - dumping a non-existent table: exit code not 0
[14:06:49.023](0.000s) ok 10 - dumping a non-existent table: matches
# Running: pg_dump --port 24136 --strict-names --schema nonexistent*
[14:06:49.139](0.116s) ok 11 - no matching schemas: exit code not 0
[14:06:49.140](0.000s) ok 12 - no matching schemas: matches
# Running: pg_dump --port 24136 --strict-names --schema-only --statistics
[14:06:49.196](0.057s) ok 13 - cannot use --statistics and --schema-only together: exit code not 0
[14:06:49.197](0.001s) ok 14 - cannot use --statistics and --schema-only together: matches
# Running: pg_dump --port 24136 --strict-names --table nonexistent*
[14:06:49.326](0.128s) ok 15 - no matching tables: exit code not 0
[14:06:49.326](0.001s) ok 16 - no matching tables: matches
# Running: pg_dumpall --exclude-database .
[14:06:49.569](0.243s) ok 17 - pg_dumpall: option --exclude-database rejects multipart pattern ".": exit code not 0
[14:06:49.570](0.001s) ok 18 - pg_dumpall: option --exclude-database rejects multipart pattern ".": matches
# Running: pg_dumpall --exclude-database myhost.mydb
[14:06:49.775](0.205s) ok 19 - pg_dumpall: option --exclude-database rejects multipart database names: exit code not 0
[14:06:49.776](0.000s) ok 20 - pg_dumpall: option --exclude-database rejects multipart database names: matches
# Running: pg_dump --port 24136 --schema pg_catalog --file C:\cirrus\build\testrun\pg_dump\002_pg_dump\data\tmp_test_9UIx/pgdump_pgcatalog.dmp
[14:06:53.397](3.621s) ok 21 - pg_dump: option -n pg_catalog
# Running: pg_dumpall --port 24136 --exclude-database "myhost.mydb" --file C:\cirrus\build\testrun\pg_dump\002_pg_dump\data\tmp_test_9UIx/pgdumpall.dmp
[14:06:55.679](2.282s) ok 22 - pg_dumpall: option --exclude-database handles database names with embedded dots
# Running: pg_dump --schema myhost.mydb.myschema
[14:06:55.799](0.119s) ok 23 - pg_dump: option --schema rejects three-part schema names: exit code not 0
[14:06:55.799](0.000s) ok 24 - pg_dump: option --schema rejects three-part schema names: matches
# Running: pg_dump --schema otherdb.myschema
[14:06:55.958](0.159s) ok 25 - pg_dump: option --schema rejects cross-database multipart schema names: exit code not 0
[14:06:55.958](0.000s) ok 26 - pg_dump: option --schema rejects cross-database multipart schema names: matches
# Running: pg_dump --schema .
[14:06:56.096](0.137s) ok 27 - pg_dump: option --schema rejects degenerate two-part schema name: ".": exit code not 0
[14:06:56.096](0.000s) ok 28 - pg_dump: option --schema rejects degenerate two-part schema name: ".": matches
# Running: pg_dump --schema "some.other.db".myschema
[14:06:56.226](0.130s) ok 29 - pg_dump: option --schema rejects cross-database multipart schema names with embedded dots: exit code not 0
[14:06:56.227](0.001s) ok 30 - pg_dump: option --schema rejects cross-database multipart schema names with embedded dots: matches
# Running: pg_dump --schema ..
[14:06:56.433](0.206s) ok 31 - pg_dump: option --schema rejects degenerate three-part schema name: "..": exit code not 0
[14:06:56.434](0.000s) ok 32 - pg_dump: option --schema rejects degenerate three-part schema name: "..": matches
# Running: pg_dump --table myhost.mydb.myschema.mytable
[14:06:56.577](0.143s) ok 33 - pg_dump: option --table rejects four-part table names: exit code not 0
[14:06:56.577](0.000s) ok 34 - pg_dump: option --table rejects four-part table names: matches
# Running: pg_dump --table otherdb.pg_catalog.pg_class
[14:06:56.703](0.126s) ok 35 - pg_dump: option --table rejects cross-database three part table names: exit code not 0
[14:06:56.703](0.000s) ok 36 - pg_dump: option --table rejects cross-database three part table names: matches
# Running: pg_dump --port 24136 --table "some.other.db".pg_catalog.pg_class
[14:06:56.836](0.133s) ok 37 - pg_dump: option --table rejects cross-database three part table names with embedded dots: exit code not 0
[14:06:56.837](0.002s) ok 38 - pg_dump: option --table rejects cross-database three part table names with embedded dots: matches
# Running: pg_dump --no-sync --format custom --file C:\cirrus\build\testrun\pg_dump\002_pg_dump\data\tmp_test_9UIx/binary_upgrade.dump --no-password --no-data --sequence-data --binary-upgrade --statistics --dbname postgres
[14:06:57.666](0.828s) ok 39 - binary_upgrade: pg_dump runs
# Running: pg_restore --format custom --verbose --file C:\cirrus\build\testrun\pg_dump\002_pg_dump\data\tmp_test_9UIx/binary_upgrade.sql --statistics C:\cirrus\build\testrun\pg_dump\002_pg_dump\data\tmp_test_9UIx/binary_upgrade.dump
[14:06:59.482](1.816s) ok 40 - binary_upgrade: pg_restore runs
[14:06:59.522](0.040s) ok 41 - binary_upgrade: should dump ALTER COLLATION test0 OWNER TO
[14:06:59.522](0.000s) ok 42 - binary_upgrade: should dump ALTER DEFAULT PRIVILEGES FOR ROLE regress_dump_test_role GRANT
[14:06:59.523](0.000s) ok 43 - binary_upgrade: should dump ALTER DEFAULT PRIVILEGES FOR ROLE regress_dump_test_role GRANT EXECUTE ON FUNCTIONS
[14:06:59.523](0.000s) ok 44 - binary_upgrade: should dump ALTER DEFAULT PRIVILEGES FOR ROLE regress_dump_test_role REVOKE
[14:06:59.523](0.000s) ok 45 - binary_upgrade: should dump ALTER DEFAULT PRIVILEGES FOR ROLE regress_dump_test_role REVOKE SELECT
[14:06:59.524](0.000s) ok 46 - binary_upgrade: should dump ALTER FOREIGN DATA WRAPPER dummy OWNER TO
[14:06:59.524](0.001s) ok 47 - binary_upgrade: should dump ALTER FOREIGN TABLE foreign_table ALTER COLUMN c1 OPTIONS
[14:06:59.525](0.000s) ok 48 - binary_upgrade: should dump ALTER FOREIGN TABLE foreign_table OWNER TO
[14:06:59.525](0.000s) ok 49 - binary_upgrade: should dump ALTER FUNCTION dump_test.pltestlang_call_handler() OWNER TO
[14:06:59.526](0.000s) ok 50 - binary_upgrade: should dump ALTER INDEX ... ATTACH PARTITION
[14:06:59.526](0.000s) ok 51 - binary_upgrade: should dump ALTER INDEX ... ATTACH PARTITION (primary key)
[14:06:59.526](0.000s) ok 52 - binary_upgrade: should not dump ALTER LARGE OBJECT ... OWNER TO
[14:06:59.527](0.001s) ok 53 - binary_upgrade: should dump ALTER OPERATOR CLASS dump_test.op_class OWNER TO
[14:06:59.528](0.000s) ok 54 - binary_upgrade: should dump ALTER OPERATOR FAMILY dump_test.op_family OWNER TO
[14:06:59.528](0.000s) ok 55 - binary_upgrade: should dump ALTER OPERATOR FAMILY dump_test.op_family USING btree
[14:06:59.528](0.000s) ok 56 - binary_upgrade: should dump ALTER PROCEDURAL LANGUAGE pltestlang OWNER TO
[14:06:59.531](0.003s) ok 57 - binary_upgrade: should dump ALTER PUBLICATION pub1 ADD TABLE test_second_table
[14:06:59.531](0.000s) ok 58 - binary_upgrade: should dump ALTER PUBLICATION pub1 ADD TABLE test_seventh_table (col3, col2) WHERE (col1 = 1)
[14:06:59.532](0.000s) ok 59 - binary_upgrade: should dump ALTER PUBLICATION pub1 ADD TABLE test_sixth_table (col3, col2)
[14:06:59.534](0.002s) ok 60 - binary_upgrade: should dump ALTER PUBLICATION pub1 ADD TABLE test_table
[14:06:59.535](0.001s) ok 61 - binary_upgrade: should dump ALTER PUBLICATION pub1 OWNER TO
[14:06:59.535](0.000s) ok 62 - binary_upgrade: should dump ALTER PUBLICATION pub3 ADD TABLE test_table
[14:06:59.536](0.001s) ok 63 - binary_upgrade: should dump ALTER PUBLICATION pub3 ADD TABLES IN SCHEMA dump_test
[14:06:59.542](0.006s) ok 64 - binary_upgrade: should dump ALTER PUBLICATION pub3 ADD TABLES IN SCHEMA public
[14:06:59.543](0.001s) ok 65 - binary_upgrade: should dump ALTER PUBLICATION pub4 ADD TABLE test_second_table WHERE (col2 = 'test');
[14:06:59.544](0.001s) ok 66 - binary_upgrade: should dump ALTER PUBLICATION pub4 ADD TABLE test_table WHERE (col1 > 0);
[14:06:59.545](0.001s) ok 67 - binary_upgrade: should not dump ALTER ROLE regress_dump_test_role
[14:06:59.546](0.000s) ok 68 - binary_upgrade: should dump ALTER SCHEMA dump_test OWNER TO
[14:06:59.546](0.000s) ok 69 - binary_upgrade: should dump ALTER SCHEMA dump_test_second_schema OWNER TO
[14:06:59.546](0.000s) ok 70 - binary_upgrade: should dump ALTER SCHEMA public OWNER TO
[14:06:59.547](0.001s) ok 71 - binary_upgrade: should dump ALTER SEQUENCE test_table_col1_seq
[14:06:59.549](0.002s) ok 72 - binary_upgrade: should dump ALTER SERVER s1 OWNER TO
[14:06:59.549](0.000s) ok 73 - binary_upgrade: should dump ALTER STATISTICS extended_stats_options
[14:06:59.550](0.000s) ok 74 - binary_upgrade: should dump ALTER TABLE (partitioned) ADD CONSTRAINT ... FOREIGN KEY
[14:06:59.550](0.000s) ok 75 - binary_upgrade: should dump ALTER TABLE ONLY dump_test.measurement ATTACH PARTITION measurement_y2006m2
[14:06:59.550](0.000s) ok 76 - binary_upgrade: should dump ALTER TABLE ONLY test_table ADD CONSTRAINT ... PRIMARY KEY
[14:06:59.551](0.000s) ok 77 - binary_upgrade: should dump ALTER TABLE ONLY test_table ALTER COLUMN col1 SET STATISTICS 90
[14:06:59.551](0.000s) ok 78 - binary_upgrade: should dump ALTER TABLE ONLY test_table ALTER COLUMN col2 SET STORAGE
[14:06:59.551](0.000s) ok 79 - binary_upgrade: should dump ALTER TABLE ONLY test_table ALTER COLUMN col3 SET STORAGE
[14:06:59.552](0.000s) ok 80 - binary_upgrade: should dump ALTER TABLE ONLY test_table ALTER COLUMN col4 SET n_distinct
[14:06:59.552](0.000s) ok 81 - binary_upgrade: should dump ALTER TABLE measurement OWNER TO
[14:06:59.552](0.000s) ok 82 - binary_upgrade: should dump ALTER TABLE measurement PRIMARY KEY
[14:06:59.557](0.004s) ok 83 - binary_upgrade: should dump ALTER TABLE measurement_y2006m2 OWNER TO
[14:06:59.557](0.001s) ok 84 - binary_upgrade: should dump ALTER TABLE test_second_table OWNER TO
[14:06:59.578](0.021s) ok 85 - binary_upgrade: should dump ALTER TABLE test_table CLUSTER ON test_table_pkey
[14:06:59.580](0.001s) ok 86 - binary_upgrade: should not dump ALTER TABLE test_table DISABLE TRIGGER ALL
[14:06:59.582](0.002s) ok 87 - binary_upgrade: should dump ALTER TABLE test_table ENABLE ROW LEVEL SECURITY
[14:06:59.582](0.000s) ok 88 - binary_upgrade: should dump ALTER TABLE test_table OWNER TO
[14:06:59.586](0.004s) ok 89 - binary_upgrade: should not dump ALTER TABLE test_table_generated_child1
[14:06:59.591](0.005s) ok 90 - binary_upgrade: should dump ALTER TEXT SEARCH CONFIGURATION alt_ts_conf1 OWNER TO
[14:06:59.597](0.007s) ok 91 - binary_upgrade: should dump ALTER TEXT SEARCH CONFIGURATION dump_test.alt_ts_conf1 ...
[14:06:59.598](0.001s) ok 92 - binary_upgrade: should dump ALTER TEXT SEARCH DICTIONARY alt_ts_dict1 OWNER TO
[14:06:59.599](0.000s) ok 93 - binary_upgrade: should dump ALTER VIEW test_view SET DEFAULT
[14:06:59.599](0.000s) ok 94 - binary_upgrade: should dump Always trigger on partition is altered
[14:06:59.600](0.001s) ok 95 - binary_upgrade: should dump COMMENT ON COLLATION test0
[14:06:59.604](0.005s) ok 96 - binary_upgrade: should dump COMMENT ON COLUMN dump_test.composite.f1
[14:06:59.604](0.000s) ok 97 - binary_upgrade: should dump COMMENT ON COLUMN dump_test.test_second_table.col1
[14:06:59.605](0.001s) ok 98 - binary_upgrade: should dump COMMENT ON COLUMN dump_test.test_second_table.col2
[14:06:59.605](0.000s) ok 99 - binary_upgrade: should dump COMMENT ON COLUMN dump_test.test_table.col1
[14:06:59.606](0.000s) ok 100 - binary_upgrade: should dump COMMENT ON CONSTRAINT ON DOMAIN (1)
[14:06:59.606](0.000s) ok 101 - binary_upgrade: should dump COMMENT ON CONSTRAINT ON DOMAIN (2)
[14:06:59.606](0.000s) ok 102 - binary_upgrade: should dump COMMENT ON CONSTRAINT ON test_table_chld2
[14:06:59.606](0.000s) ok 103 - binary_upgrade: should dump COMMENT ON CONSTRAINT ON test_table_nn
[14:06:59.607](0.000s) ok 104 - binary_upgrade: should dump COMMENT ON CONVERSION dump_test.test_conversion
[14:06:59.607](0.000s) ok 105 - binary_upgrade: should not dump COMMENT ON DATABASE postgres
[14:06:59.607](0.000s) ok 106 - binary_upgrade: should not dump COMMENT ON EXTENSION plpgsql
[14:06:59.608](0.000s) ok 107 - binary_upgrade: should dump COMMENT ON LARGE OBJECT ...
[14:06:59.608](0.000s) ok 108 - binary_upgrade: should dump COMMENT ON POLICY p1
[14:06:59.608](0.000s) ok 109 - binary_upgrade: should dump COMMENT ON PUBLICATION pub1
[14:06:59.609](0.000s) ok 110 - binary_upgrade: should not dump COMMENT ON SCHEMA public
[14:06:59.609](0.000s) ok 111 - binary_upgrade: should dump COMMENT ON SUBSCRIPTION sub1
[14:06:59.609](0.000s) ok 112 - binary_upgrade: should dump COMMENT ON TABLE dump_test.test_table
[14:06:59.609](0.000s) ok 113 - binary_upgrade: should dump COMMENT ON TEXT SEARCH CONFIGURATION dump_test.alt_ts_conf1
[14:06:59.610](0.000s) ok 114 - binary_upgrade: should dump COMMENT ON TEXT SEARCH DICTIONARY dump_test.alt_ts_dict1
[14:06:59.610](0.000s) ok 115 - binary_upgrade: should dump COMMENT ON TEXT SEARCH PARSER dump_test.alt_ts_prs1
[14:06:59.610](0.000s) ok 116 - binary_upgrade: should dump COMMENT ON TEXT SEARCH TEMPLATE dump_test.alt_ts_temp1
[14:06:59.610](0.000s) ok 117 - binary_upgrade: should dump COMMENT ON TYPE dump_test.int42 - Regular
[14:06:59.610](0.000s) ok 118 - binary_upgrade: should dump COMMENT ON TYPE dump_test.planets - ENUM
[14:06:59.611](0.000s) ok 119 - binary_upgrade: should dump COMMENT ON TYPE dump_test.textrange - RANGE
[14:06:59.611](0.000s) ok 120 - binary_upgrade: should dump COMMENT ON TYPE dump_test.undefined - Undefined
[14:06:59.611](0.000s) ok 121 - binary_upgrade: should dump CONSTRAINT NOT NULL / NO INHERIT
[14:06:59.612](0.000s) ok 122 - binary_upgrade: should not dump CONSTRAINT NOT NULL / NO INHERIT (child1)
[14:06:59.612](0.001s) ok 123 - binary_upgrade: should dump CONSTRAINT NOT NULL / NOT VALID
[14:06:59.612](0.000s) ok 124 - binary_upgrade: should not dump CONSTRAINT NOT NULL / NOT VALID (child1)
[14:06:59.613](0.000s) ok 125 - binary_upgrade: should dump CONSTRAINT NOT NULL / NOT VALID (child2)
[14:06:59.613](0.000s) ok 126 - binary_upgrade: should not dump CONSTRAINT NOT NULL / NOT VALID (child3)
[14:06:59.613](0.000s) ok 127 - binary_upgrade: should dump CONSTRAINT PRIMARY KEY / WITHOUT OVERLAPS
[14:06:59.614](0.000s) ok 128 - binary_upgrade: should dump CONSTRAINT UNIQUE / WITHOUT OVERLAPS
[14:06:59.614](0.000s) ok 129 - binary_upgrade: should not dump COPY fk_reference_test_table
[14:06:59.615](0.000s) ok 130 - binary_upgrade: should not dump COPY fk_reference_test_table second
[14:06:59.615](0.000s) ok 131 - binary_upgrade: should not dump COPY measurement
[14:06:59.615](0.000s) ok 132 - binary_upgrade: should not dump COPY test_fifth_table
[14:06:59.616](0.000s) ok 133 - binary_upgrade: should not dump COPY test_fourth_table
[14:06:59.616](0.000s) ok 134 - binary_upgrade: should not dump COPY test_second_table
[14:06:59.617](0.000s) ok 135 - binary_upgrade: should not dump COPY test_table
[14:06:59.617](0.000s) ok 136 - binary_upgrade: should not dump COPY test_table_identity
[14:06:59.617](0.000s) ok 137 - binary_upgrade: should not dump COPY test_third_table
[14:06:59.617](0.000s) ok 138 - binary_upgrade: should dump CREATE ACCESS METHOD gist2
[14:06:59.618](0.000s) ok 139 - binary_upgrade: should dump CREATE ACCESS METHOD regress_test_table_am
[14:06:59.618](0.000s) ok 140 - binary_upgrade: should dump CREATE AGGREGATE dump_test.newavg
[14:06:59.618](0.000s) ok 141 - binary_upgrade: should dump CREATE CAST FOR timestamptz
[14:06:59.618](0.000s) ok 142 - binary_upgrade: should dump CREATE COLLATION test0 FROM "C"
[14:06:59.618](0.000s) ok 143 - binary_upgrade: should dump CREATE CONVERSION dump_test.test_conversion
[14:06:59.619](0.000s) ok 144 - binary_upgrade: should not dump CREATE DATABASE dump_test
[14:06:59.619](0.000s) ok 145 - binary_upgrade: should not dump CREATE DATABASE dump_test2 LOCALE = 'C'
[14:06:59.620](0.000s) ok 146 - binary_upgrade: should not dump CREATE DATABASE postgres
[14:06:59.620](0.000s) ok 147 - binary_upgrade: should not dump CREATE DATABASE regression_invalid...
[14:06:59.624](0.004s) ok 148 - binary_upgrade: should dump CREATE DOMAIN dump_test.us_postal_code
[14:06:59.624](0.001s) ok 149 - binary_upgrade: should dump CREATE EVENT TRIGGER test_event_trigger
[14:06:59.625](0.000s) ok 150 - binary_upgrade: should not dump CREATE EXTENSION ... plpgsql
[14:06:59.626](0.001s) ok 151 - binary_upgrade: should dump CREATE FOREIGN DATA WRAPPER dummy
[14:06:59.626](0.000s) ok 152 - binary_upgrade: should dump CREATE FOREIGN TABLE dump_test.foreign_table SERVER s1
[14:06:59.627](0.000s) ok 153 - binary_upgrade: should dump CREATE FUNCTION ... SUPPORT
[14:06:59.627](0.000s) ok 154 - binary_upgrade: should dump CREATE FUNCTION dump_test.event_trigger_func
[14:06:59.627](0.000s) ok 155 - binary_upgrade: should dump CREATE FUNCTION dump_test.int42_in
[14:06:59.627](0.000s) ok 156 - binary_upgrade: should dump CREATE FUNCTION dump_test.int42_out
[14:06:59.628](0.000s) ok 157 - binary_upgrade: should dump CREATE FUNCTION dump_test.pltestlang_call_handler
[14:06:59.628](0.000s) ok 158 - binary_upgrade: should dump CREATE FUNCTION dump_test.trigger_func
[14:06:59.628](0.000s) ok 159 - binary_upgrade: should dump CREATE INDEX ... ON measurement_y2006_m2
[14:06:59.628](0.000s) ok 160 - binary_upgrade: should dump CREATE INDEX ON ONLY measurement
[14:06:59.628](0.000s) ok 161 - binary_upgrade: should dump CREATE LANGUAGE pltestlang
[14:06:59.629](0.000s) ok 162 - binary_upgrade: should dump CREATE MATERIALIZED VIEW matview
[14:06:59.629](0.000s) ok 163 - binary_upgrade: should dump CREATE MATERIALIZED VIEW matview_fourth
[14:06:59.629](0.000s) ok 164 - binary_upgrade: should dump CREATE MATERIALIZED VIEW matview_second
[14:06:59.630](0.000s) ok 165 - binary_upgrade: should dump CREATE MATERIALIZED VIEW matview_third
[14:06:59.630](0.000s) ok 166 - binary_upgrade: should dump CREATE MATERIALIZED VIEW regress_pg_dump_matview_am
[14:06:59.630](0.000s) ok 167 - binary_upgrade: should dump CREATE OPERATOR CLASS dump_test.op_class
[14:06:59.633](0.003s) ok 168 - binary_upgrade: should dump CREATE OPERATOR CLASS dump_test.op_class_custom
[14:06:59.634](0.000s) ok 169 - binary_upgrade: should dump CREATE OPERATOR CLASS dump_test.op_class_empty
[14:06:59.634](0.000s) ok 170 - binary_upgrade: should dump CREATE OPERATOR FAMILY dump_test.op_family
[14:06:59.634](0.000s) ok 171 - binary_upgrade: should dump CREATE POLICY p1 ON test_table
[14:06:59.634](0.000s) ok 172 - binary_upgrade: should dump CREATE POLICY p2 ON test_table FOR SELECT
[14:06:59.635](0.000s) ok 173 - binary_upgrade: should dump CREATE POLICY p3 ON test_table FOR INSERT
[14:06:59.635](0.000s) ok 174 - binary_upgrade: should dump CREATE POLICY p4 ON test_table FOR UPDATE
[14:06:59.636](0.000s) ok 175 - binary_upgrade: should dump CREATE POLICY p5 ON test_table FOR DELETE
[14:06:59.636](0.000s) ok 176 - binary_upgrade: should dump CREATE POLICY p6 ON test_table AS RESTRICTIVE
[14:06:59.636](0.000s) ok 177 - binary_upgrade: should dump CREATE PROCEDURE dump_test.ptest1
[14:06:59.637](0.000s) ok 178 - binary_upgrade: should dump CREATE PROPERTY GRAPH propgraph
[14:06:59.637](0.000s) ok 179 - binary_upgrade: should dump CREATE PUBLICATION pub1
[14:06:59.637](0.000s) ok 180 - binary_upgrade: should dump CREATE PUBLICATION pub10
[14:06:59.638](0.000s) ok 181 - binary_upgrade: should dump CREATE PUBLICATION pub2
[14:06:59.638](0.000s) ok 182 - binary_upgrade: should dump CREATE PUBLICATION pub3
[14:06:59.639](0.000s) ok 183 - binary_upgrade: should dump CREATE PUBLICATION pub4
[14:06:59.639](0.000s) ok 184 - binary_upgrade: should dump CREATE PUBLICATION pub5
[14:06:59.639](0.000s) ok 185 - binary_upgrade: should dump CREATE PUBLICATION pub6
[14:06:59.640](0.000s) ok 186 - binary_upgrade: should dump CREATE PUBLICATION pub7
[14:06:59.640](0.000s) ok 187 - binary_upgrade: should dump CREATE PUBLICATION pub8
[14:06:59.640](0.000s) ok 188 - binary_upgrade: should dump CREATE PUBLICATION pub9
[14:06:59.641](0.000s) ok 189 - binary_upgrade: should not dump CREATE ROLE regress_dump_test_role
[14:06:59.641](0.001s) ok 190 - binary_upgrade: should not dump CREATE ROLE regress_quoted...
[14:06:59.642](0.000s) ok 191 - binary_upgrade: should dump CREATE SCHEMA dump_test
[14:06:59.642](0.000s) ok 192 - binary_upgrade: should dump CREATE SCHEMA dump_test_second_schema
[14:06:59.642](0.000s) ok 193 - binary_upgrade: should not dump CREATE SCHEMA public
[14:06:59.643](0.000s) ok 194 - binary_upgrade: should dump CREATE SEQUENCE test_table_col1_seq
[14:06:59.643](0.000s) ok 195 - binary_upgrade: should dump CREATE SERVER s1 FOREIGN DATA WRAPPER dummy
[14:06:59.644](0.000s) ok 196 - binary_upgrade: should dump CREATE STATISTICS extended_stats_expression
[14:06:59.644](0.000s) ok 197 - binary_upgrade: should dump CREATE STATISTICS extended_stats_no_options
[14:06:59.644](0.000s) ok 198 - binary_upgrade: should dump CREATE STATISTICS extended_stats_options
[14:06:59.645](0.000s) ok 199 - binary_upgrade: should dump CREATE SUBSCRIPTION sub1
[14:06:59.645](0.000s) ok 200 - binary_upgrade: should dump CREATE SUBSCRIPTION sub2
[14:06:59.645](0.000s) ok 201 - binary_upgrade: should dump CREATE SUBSCRIPTION sub3
[14:06:59.646](0.000s) ok 202 - binary_upgrade: should dump CREATE TABLE fk_reference_test_table
[14:06:59.646](0.000s) ok 203 - binary_upgrade: should not dump CREATE TABLE measurement PARTITIONED BY
[14:06:59.646](0.000s) ok 204 - binary_upgrade: should dump CREATE TABLE regress_pg_dump_table_am
[14:06:59.650](0.004s) ok 205 - binary_upgrade: should dump CREATE TABLE regress_pg_dump_table_part
[14:06:59.650](0.000s) ok 206 - binary_upgrade: should dump CREATE TABLE table_with_stats
[14:06:59.651](0.000s) ok 207 - binary_upgrade: should dump CREATE TABLE test_fifth_table
[14:06:59.651](0.000s) ok 208 - binary_upgrade: should dump CREATE TABLE test_fourth_table_zero_col
[14:06:59.651](0.000s) ok 209 - binary_upgrade: should not dump CREATE TABLE test_inheritance_child
[14:06:59.651](0.000s) ok 210 - binary_upgrade: should dump CREATE TABLE test_inheritance_parent
[14:06:59.652](0.000s) ok 211 - binary_upgrade: should dump CREATE TABLE test_second_table
[14:06:59.652](0.000s) ok 212 - binary_upgrade: should dump CREATE TABLE test_seventh_table
[14:06:59.652](0.000s) ok 213 - binary_upgrade: should dump CREATE TABLE test_sixth_table
[14:06:59.657](0.005s) ok 214 - binary_upgrade: should dump CREATE TABLE test_table
[14:06:59.657](0.000s) ok 215 - binary_upgrade: should dump CREATE TABLE test_table_generated
[14:06:59.657](0.000s) ok 216 - binary_upgrade: should not dump CREATE TABLE test_table_generated_child1 (without local columns)
[14:06:59.658](0.000s) ok 217 - binary_upgrade: should not dump CREATE TABLE test_table_generated_child2 (with local columns)
[14:06:59.658](0.001s) ok 218 - binary_upgrade: should dump CREATE TABLE test_table_identity
[14:06:59.659](0.000s) ok 219 - binary_upgrade: should not dump CREATE TABLE test_third_table_generated_cols
[14:06:59.659](0.000s) ok 220 - binary_upgrade: should not dump CREATE TABLESPACE regress_dump_tablespace
[14:06:59.659](0.000s) ok 221 - binary_upgrade: should dump CREATE TEXT SEARCH CONFIGURATION dump_test.alt_ts_conf1
[14:06:59.659](0.000s) ok 222 - binary_upgrade: should dump CREATE TEXT SEARCH DICTIONARY dump_test.alt_ts_dict1
[14:06:59.660](0.000s) ok 223 - binary_upgrade: should dump CREATE TEXT SEARCH PARSER dump_test.alt_ts_prs1
[14:06:59.660](0.000s) ok 224 - binary_upgrade: should dump CREATE TEXT SEARCH TEMPLATE dump_test.alt_ts_temp1
[14:06:59.660](0.000s) ok 225 - binary_upgrade: should dump CREATE TRANSFORM FOR int
[14:06:59.660](0.000s) ok 226 - binary_upgrade: should dump CREATE TRIGGER test_trigger
[14:06:59.660](0.000s) ok 227 - binary_upgrade: should dump CREATE TYPE dump_test.composite
[14:06:59.661](0.000s) ok 228 - binary_upgrade: should dump CREATE TYPE dump_test.int42
[14:06:59.661](0.000s) ok 229 - binary_upgrade: should dump CREATE TYPE dump_test.int42 populated
[14:06:59.661](0.000s) ok 230 - binary_upgrade: should not dump CREATE TYPE dump_test.planets AS ENUM
[14:06:59.668](0.007s) ok 231 - binary_upgrade: should dump CREATE TYPE dump_test.planets AS ENUM pg_upgrade
[14:06:59.669](0.000s) ok 232 - binary_upgrade: should dump CREATE TYPE dump_test.textrange AS RANGE
[14:06:59.669](0.000s) ok 233 - binary_upgrade: should dump CREATE TYPE dump_test.undefined
[14:06:59.669](0.000s) ok 234 - binary_upgrade: should dump CREATE USER MAPPING FOR regress_dump_test_role SERVER s1
[14:06:59.670](0.000s) ok 235 - binary_upgrade: should dump CREATE VIEW test_view
[14:06:59.671](0.001s) ok 236 - binary_upgrade: should dump Check ordering of a function that depends on a primary key
[14:06:59.672](0.001s) ok 237 - binary_upgrade: should dump Check ordering of a matview that depends on a primary key
[14:06:59.673](0.000s) ok 238 - binary_upgrade: should dump Creation of row-level trigger in partitioned table
[14:06:59.673](0.000s) ok 239 - binary_upgrade: should not dump DROP EXTENSION IF EXISTS plpgsql
[14:06:59.673](0.000s) ok 240 - binary_upgrade: should not dump DROP EXTENSION plpgsql
[14:06:59.674](0.000s) ok 241 - binary_upgrade: should not dump DROP FUNCTION IF EXISTS dump_test.pltestlang_call_handler()
[14:06:59.674](0.000s) ok 242 - binary_upgrade: should not dump DROP FUNCTION dump_test.pltestlang_call_handler()
[14:06:59.674](0.000s) ok 243 - binary_upgrade: should not dump DROP LANGUAGE IF EXISTS pltestlang
[14:06:59.674](0.000s) ok 244 - binary_upgrade: should not dump DROP LANGUAGE pltestlang
[14:06:59.675](0.000s) ok 245 - binary_upgrade: should not dump DROP ROLE pg_
[14:06:59.675](0.000s) ok 246 - binary_upgrade: should not dump DROP ROLE regress_dump_test_role
[14:06:59.676](0.000s) ok 247 - binary_upgrade: should not dump DROP SCHEMA IF EXISTS dump_test
[14:06:59.676](0.000s) ok 248 - binary_upgrade: should not dump DROP SCHEMA IF EXISTS dump_test_second_schema
[14:06:59.676](0.000s) ok 249 - binary_upgrade: should not dump DROP SCHEMA IF EXISTS public
[14:06:59.677](0.000s) ok 250 - binary_upgrade: should not dump DROP SCHEMA dump_test
[14:06:59.677](0.000s) ok 251 - binary_upgrade: should not dump DROP SCHEMA dump_test_second_schema
[14:06:59.677](0.000s) ok 252 - binary_upgrade: should not dump DROP SCHEMA public
[14:06:59.678](0.000s) ok 253 - binary_upgrade: should not dump DROP TABLE IF EXISTS test_second_table
[14:06:59.678](0.000s) ok 254 - binary_upgrade: should not dump DROP TABLE IF EXISTS test_table
[14:06:59.678](0.000s) ok 255 - binary_upgrade: should not dump DROP TABLE fk_reference_test_table
[14:06:59.678](0.000s) ok 256 - binary_upgrade: should not dump DROP TABLE test_second_table
[14:06:59.679](0.000s) ok 257 - binary_upgrade: should not dump DROP TABLE test_table
[14:06:59.679](0.000s) ok 258 - binary_upgrade: should dump Disabled trigger on partition is altered
[14:06:59.679](0.000s) ok 259 - binary_upgrade: should not dump Disabled trigger on partition is not created
[14:06:59.680](0.000s) ok 260 - binary_upgrade: should not dump GRANT ALL ON LARGE OBJECT ...
[14:06:59.680](0.000s) ok 261 - binary_upgrade: should not dump GRANT CREATE ON DATABASE dump_test
[14:06:59.680](0.000s) ok 262 - binary_upgrade: should dump GRANT EXECUTE ON FUNCTION pg_sleep() TO regress_dump_test_role
[14:06:59.680](0.000s) ok 263 - binary_upgrade: should dump GRANT INSERT(col1) ON TABLE test_second_table
[14:06:59.683](0.003s) ok 264 - binary_upgrade: should dump GRANT SELECT (proname ...) ON TABLE pg_proc TO public
[14:06:59.684](0.000s) ok 265 - binary_upgrade: should dump GRANT SELECT ON PROPERTY GRAPH propgraph
[14:06:59.684](0.001s) ok 266 - binary_upgrade: should dump GRANT SELECT ON TABLE measurement
[14:06:59.685](0.000s) ok 267 - binary_upgrade: should dump GRANT SELECT ON TABLE measurement_y2006m2
[14:06:59.685](0.000s) ok 268 - binary_upgrade: should dump GRANT SELECT ON TABLE test_table
[14:06:59.685](0.000s) ok 269 - binary_upgrade: should dump GRANT USAGE ON DOMAIN dump_test.us_postal_code
[14:06:59.685](0.000s) ok 270 - binary_upgrade: should dump GRANT USAGE ON FOREIGN DATA WRAPPER dummy
[14:06:59.686](0.000s) ok 271 - binary_upgrade: should dump GRANT USAGE ON FOREIGN SERVER s1
[14:06:59.686](0.000s) ok 272 - binary_upgrade: should dump GRANT USAGE ON SCHEMA dump_test_second_schema
[14:06:59.686](0.000s) ok 273 - binary_upgrade: should not dump GRANT USAGE ON SCHEMA public TO public
[14:06:59.686](0.000s) ok 274 - binary_upgrade: should dump GRANT USAGE ON TYPE dump_test.int42
[14:06:59.687](0.000s) ok 275 - binary_upgrade: should dump GRANT USAGE ON TYPE dump_test.planets - ENUM
[14:06:59.687](0.000s) ok 276 - binary_upgrade: should dump GRANT USAGE ON TYPE dump_test.textrange - RANGE
[14:06:59.687](0.000s) ok 277 - binary_upgrade: should not dump INSERT INTO test_fifth_table
[14:06:59.687](0.000s) ok 278 - binary_upgrade: should not dump INSERT INTO test_fourth_table
[14:06:59.688](0.000s) ok 279 - binary_upgrade: should not dump INSERT INTO test_second_table
[14:06:59.688](0.000s) ok 280 - binary_upgrade: should not dump INSERT INTO test_table
[14:06:59.688](0.000s) ok 281 - binary_upgrade: should not dump INSERT INTO test_table_identity
[14:06:59.688](0.000s) ok 282 - binary_upgrade: should not dump INSERT INTO test_third_table
[14:06:59.689](0.000s) ok 283 - binary_upgrade: should not dump INSERT INTO test_third_table (colnames)
[14:06:59.689](0.000s) ok 284 - binary_upgrade: should not dump LO create (using lo_from_bytea)
[14:06:59.689](0.000s) ok 285 - binary_upgrade: should not dump LO create (with no data)
[14:06:59.690](0.000s) ok 286 - binary_upgrade: should not dump LO load (using lo_from_bytea)
[14:06:59.690](0.000s) ok 287 - binary_upgrade: should dump Partition measurement_y2006m2 creation
[14:06:59.690](0.000s) ok 288 - binary_upgrade: should not dump REFRESH MATERIALIZED VIEW matview
[14:06:59.690](0.000s) ok 289 - binary_upgrade: should not dump REFRESH MATERIALIZED VIEW matview_fourth
[14:06:59.691](0.000s) ok 290 - binary_upgrade: should not dump REFRESH MATERIALIZED VIEW matview_second
[14:06:59.691](0.000s) ok 291 - binary_upgrade: should not dump REFRESH MATERIALIZED VIEW matview_third
[14:06:59.691](0.000s) ok 292 - binary_upgrade: should dump REVOKE ALL ON SCHEMA public
[14:06:59.691](0.000s) ok 293 - binary_upgrade: should not dump REVOKE CONNECT ON DATABASE dump_test FROM public
[14:06:59.692](0.000s) ok 294 - binary_upgrade: should dump REVOKE EXECUTE ON FUNCTION pg_sleep() FROM public
[14:06:59.784](0.093s) ok 295 - binary_upgrade: should not dump REVOKE EXECUTE ON FUNCTION pg_stat_reset FROM regress_dump_test_role
[14:06:59.785](0.000s) ok 296 - binary_upgrade: should dump REVOKE SELECT ON TABLE pg_proc FROM public
[14:06:59.785](0.000s) ok 297 - binary_upgrade: should dump REVOKE USAGE ON LANGUAGE plpgsql FROM public
[14:06:59.785](0.000s) ok 298 - binary_upgrade: should dump Replica trigger on partition is altered
[14:06:59.786](0.000s) ok 299 - binary_upgrade: should not dump Triggers on partitions are not dropped
[14:06:59.786](0.000s) ok 300 - binary_upgrade: should dump extended_statistics_import
[14:06:59.787](0.001s) ok 301 - binary_upgrade: should not dump newline of table name in comment
[14:06:59.787](0.000s) ok 302 - binary_upgrade: should dump relstats_on_unanalyzed_tables
[14:06:59.787](0.000s) ok 303 - binary_upgrade: should dump restrict
[14:06:59.789](0.002s) ok 304 - binary_upgrade: should dump statistics_import
[14:06:59.789](0.000s) ok 305 - binary_upgrade: should not dump test_table with 4-row INSERTs
[14:06:59.790](0.000s) ok 306 - binary_upgrade: should dump unrestrict
# Running: pg_dump --no-sync --file C:\cirrus\build\testrun\pg_dump\002_pg_dump\data\tmp_test_9UIx/clean.sql --clean --statistics --dbname postgres
[14:07:00.531](0.742s) ok 307 - clean: pg_dump runs
[14:07:00.534](0.003s) ok 308 - clean: should dump ALTER COLLATION test0 OWNER TO
[14:07:00.535](0.000s) ok 309 - clean: should dump ALTER DEFAULT PRIVILEGES FOR ROLE regress_dump_test_role GRANT
[14:07:00.535](0.000s) ok 310 - clean: should dump ALTER DEFAULT PRIVILEGES FOR ROLE regress_dump_test_role GRANT EXECUTE ON FUNCTIONS
[14:07:00.535](0.000s) ok 311 - clean: should dump ALTER DEFAULT PRIVILEGES FOR ROLE regress_dump_test_role REVOKE
[14:07:00.535](0.000s) ok 312 - clean: should dump ALTER DEFAULT PRIVILEGES FOR ROLE regress_dump_test_role REVOKE SELECT
[14:07:00.536](0.000s) ok 313 - clean: should dump ALTER FOREIGN DATA WRAPPER dummy OWNER TO
[14:07:00.536](0.000s) ok 314 - clean: should dump ALTER FOREIGN TABLE foreign_table ALTER COLUMN c1 OPTIONS
[14:07:00.536](0.000s) ok 315 - clean: should dump ALTER FOREIGN TABLE foreign_table OWNER TO
[14:07:00.536](0.000s) ok 316 - clean: should dump ALTER FUNCTION dump_test.pltestlang_call_handler() OWNER TO
[14:07:00.536](0.000s) ok 317 - clean: should dump ALTER INDEX ... ATTACH PARTITION
[14:07:00.537](0.000s) ok 318 - clean: should dump ALTER INDEX ... ATTACH PARTITION (primary key)
[14:07:00.537](0.000s) ok 319 - clean: should dump ALTER LARGE OBJECT ... OWNER TO
[14:07:00.537](0.000s) ok 320 - clean: should dump ALTER OPERATOR CLASS dump_test.op_class OWNER TO
[14:07:00.537](0.000s) ok 321 - clean: should dump ALTER OPERATOR FAMILY dump_test.op_family OWNER TO
[14:07:00.537](0.000s) ok 322 - clean: should dump ALTER OPERATOR FAMILY dump_test.op_family USING btree
[14:07:00.538](0.000s) ok 323 - clean: should dump ALTER PROCEDURAL LANGUAGE pltestlang OWNER TO
[14:07:00.538](0.000s) ok 324 - clean: should dump ALTER PUBLICATION pub1 ADD TABLE test_second_table
[14:07:00.538](0.000s) ok 325 - clean: should dump ALTER PUBLICATION pub1 ADD TABLE test_seventh_table (col3, col2) WHERE (col1 = 1)
[14:07:00.538](0.000s) ok 326 - clean: should dump ALTER PUBLICATION pub1 ADD TABLE test_sixth_table (col3, col2)
[14:07:00.539](0.000s) ok 327 - clean: should dump ALTER PUBLICATION pub1 ADD TABLE test_table
[14:07:00.539](0.000s) ok 328 - clean: should dump ALTER PUBLICATION pub1 OWNER TO
[14:07:00.539](0.000s) ok 329 - clean: should dump ALTER PUBLICATION pub3 ADD TABLE test_table
[14:07:00.539](0.000s) ok 330 - clean: should dump ALTER PUBLICATION pub3 ADD TABLES IN SCHEMA dump_test
[14:07:00.540](0.000s) ok 331 - clean: should dump ALTER PUBLICATION pub3 ADD TABLES IN SCHEMA public
[14:07:00.540](0.000s) ok 332 - clean: should dump ALTER PUBLICATION pub4 ADD TABLE test_second_table WHERE (col2 = 'test');
[14:07:00.540](0.000s) ok 333 - clean: should dump ALTER PUBLICATION pub4 ADD TABLE test_table WHERE (col1 > 0);
[14:07:00.540](0.000s) ok 334 - clean: should not dump ALTER ROLE regress_dump_test_role
[14:07:00.540](0.000s) ok 335 - clean: should dump ALTER SCHEMA dump_test OWNER TO
[14:07:00.541](0.000s) ok 336 - clean: should dump ALTER SCHEMA dump_test_second_schema OWNER TO
[14:07:00.541](0.000s) ok 337 - clean: should dump ALTER SCHEMA public OWNER TO
[14:07:00.541](0.000s) ok 338 - clean: should dump ALTER SEQUENCE test_table_col1_seq
[14:07:00.541](0.000s) ok 339 - clean: should dump ALTER SERVER s1 OWNER TO
[14:07:00.541](0.000s) ok 340 - clean: should dump ALTER STATISTICS extended_stats_options
[14:07:00.542](0.000s) ok 341 - clean: should dump ALTER TABLE (partitioned) ADD CONSTRAINT ... FOREIGN KEY
[14:07:00.542](0.000s) ok 342 - clean: should dump ALTER TABLE ONLY dump_test.measurement ATTACH PARTITION measurement_y2006m2
[14:07:00.542](0.000s) ok 343 - clean: should dump ALTER TABLE ONLY test_table ADD CONSTRAINT ... PRIMARY KEY
[14:07:00.542](0.000s) ok 344 - clean: should dump ALTER TABLE ONLY test_table ALTER COLUMN col1 SET STATISTICS 90
[14:07:00.542](0.000s) ok 345 - clean: should dump ALTER TABLE ONLY test_table ALTER COLUMN col2 SET STORAGE
[14:07:00.543](0.000s) ok 346 - clean: should dump ALTER TABLE ONLY test_table ALTER COLUMN col3 SET STORAGE
[14:07:00.543](0.000s) ok 347 - clean: should dump ALTER TABLE ONLY test_table ALTER COLUMN col4 SET n_distinct
[14:07:00.543](0.000s) ok 348 - clean: should dump ALTER TABLE measurement OWNER TO
[14:07:00.543](0.000s) ok 349 - clean: should dump ALTER TABLE measurement PRIMARY KEY
[14:07:00.544](0.000s) ok 350 - clean: should dump ALTER TABLE measurement_y2006m2 OWNER TO
[14:07:00.544](0.000s) ok 351 - clean: should dump ALTER TABLE test_second_table OWNER TO
[14:07:00.544](0.000s) ok 352 - clean: should dump ALTER TABLE test_table CLUSTER ON test_table_pkey
[14:07:00.544](0.000s) ok 353 - clean: should not dump ALTER TABLE test_table DISABLE TRIGGER ALL
[14:07:00.544](0.000s) ok 354 - clean: should dump ALTER TABLE test_table ENABLE ROW LEVEL SECURITY
[14:07:00.545](0.000s) ok 355 - clean: should dump ALTER TABLE test_table OWNER TO
[14:07:00.545](0.000s) ok 356 - clean: should not dump ALTER TABLE test_table_generated_child1
[14:07:00.545](0.000s) ok 357 - clean: should dump ALTER TEXT SEARCH CONFIGURATION alt_ts_conf1 OWNER TO
[14:07:00.545](0.000s) ok 358 - clean: should dump ALTER TEXT SEARCH CONFIGURATION dump_test.alt_ts_conf1 ...
[14:07:00.545](0.000s) ok 359 - clean: should dump ALTER TEXT SEARCH DICTIONARY alt_ts_dict1 OWNER TO
[14:07:00.546](0.000s) ok 360 - clean: should dump ALTER VIEW test_view SET DEFAULT
[14:07:00.546](0.000s) ok 361 - clean: should dump Always trigger on partition is altered
[14:07:00.546](0.000s) ok 362 - clean: should dump COMMENT ON COLLATION test0
[14:07:00.546](0.000s) ok 363 - clean: should dump COMMENT ON COLUMN dump_test.composite.f1
[14:07:00.546](0.000s) ok 364 - clean: should dump COMMENT ON COLUMN dump_test.test_second_table.col1
[14:07:00.547](0.000s) ok 365 - clean: should dump COMMENT ON COLUMN dump_test.test_second_table.col2
[14:07:00.547](0.000s) ok 366 - clean: should dump COMMENT ON COLUMN dump_test.test_table.col1
[14:07:00.547](0.000s) ok 367 - clean: should dump COMMENT ON CONSTRAINT ON DOMAIN (1)
[14:07:00.547](0.000s) ok 368 - clean: should dump COMMENT ON CONSTRAINT ON DOMAIN (2)
[14:07:00.547](0.000s) ok 369 - clean: should dump COMMENT ON CONSTRAINT ON test_table_chld2
[14:07:00.548](0.000s) ok 370 - clean: should dump COMMENT ON CONSTRAINT ON test_table_nn
[14:07:00.548](0.000s) ok 371 - clean: should dump COMMENT ON CONVERSION dump_test.test_conversion
[14:07:00.548](0.000s) ok 372 - clean: should not dump COMMENT ON DATABASE postgres
[14:07:00.548](0.000s) ok 373 - clean: should not dump COMMENT ON EXTENSION plpgsql
[14:07:00.549](0.000s) ok 374 - clean: should dump COMMENT ON LARGE OBJECT ...
[14:07:00.549](0.000s) ok 375 - clean: should dump COMMENT ON POLICY p1
[14:07:00.549](0.000s) ok 376 - clean: should dump COMMENT ON PUBLICATION pub1
[14:07:00.549](0.000s) ok 377 - clean: should not dump COMMENT ON SCHEMA public
[14:07:00.549](0.000s) ok 378 - clean: should dump COMMENT ON SUBSCRIPTION sub1
[14:07:00.550](0.000s) ok 379 - clean: should dump COMMENT ON TABLE dump_test.test_table
[14:07:00.550](0.000s) ok 380 - clean: should dump COMMENT ON TEXT SEARCH CONFIGURATION dump_test.alt_ts_conf1
[14:07:00.550](0.000s) ok 381 - clean: should dump COMMENT ON TEXT SEARCH DICTIONARY dump_test.alt_ts_dict1
[14:07:00.550](0.000s) ok 382 - clean: should dump COMMENT ON TEXT SEARCH PARSER dump_test.alt_ts_prs1
[14:07:00.550](0.000s) ok 383 - clean: should dump COMMENT ON TEXT SEARCH TEMPLATE dump_test.alt_ts_temp1
[14:07:00.551](0.000s) ok 384 - clean: should dump COMMENT ON TYPE dump_test.int42 - Regular
[14:07:00.551](0.000s) ok 385 - clean: should dump COMMENT ON TYPE dump_test.planets - ENUM
[14:07:00.551](0.000s) ok 386 - clean: should dump COMMENT ON TYPE dump_test.textrange - RANGE
[14:07:00.551](0.000s) ok 387 - clean: should dump COMMENT ON TYPE dump_test.undefined - Undefined
[14:07:00.551](0.000s) ok 388 - clean: should dump CONSTRAINT NOT NULL / NO INHERIT
[14:07:00.552](0.000s) ok 389 - clean: should dump CONSTRAINT NOT NULL / NO INHERIT (child1)
[14:07:00.552](0.000s) ok 390 - clean: should dump CONSTRAINT NOT NULL / NOT VALID
[14:07:00.552](0.000s) ok 391 - clean: should dump CONSTRAINT NOT NULL / NOT VALID (child1)
[14:07:00.552](0.000s) ok 392 - clean: should dump CONSTRAINT NOT NULL / NOT VALID (child2)
[14:07:00.552](0.000s) ok 393 - clean: should dump CONSTRAINT NOT NULL / NOT VALID (child3)
[14:07:00.553](0.000s) ok 394 - clean: should dump CONSTRAINT PRIMARY KEY / WITHOUT OVERLAPS
[14:07:00.553](0.000s) ok 395 - clean: should dump CONSTRAINT UNIQUE / WITHOUT OVERLAPS
[14:07:00.553](0.000s) ok 396 - clean: should dump COPY fk_reference_test_table
[14:07:00.553](0.000s) ok 397 - clean: should not dump COPY fk_reference_test_table second
[14:07:00.554](0.000s) ok 398 - clean: should dump COPY measurement
[14:07:00.554](0.000s) ok 399 - clean: should dump COPY test_fifth_table
[14:07:00.554](0.000s) ok 400 - clean: should dump COPY test_fourth_table
[14:07:00.554](0.000s) ok 401 - clean: should dump COPY test_second_table
[14:07:00.554](0.000s) ok 402 - clean: should dump COPY test_table
[14:07:00.555](0.000s) ok 403 - clean: should dump COPY test_table_identity
[14:07:00.555](0.000s) ok 404 - clean: should dump COPY test_third_table
[14:07:00.555](0.000s) ok 405 - clean: should dump CREATE ACCESS METHOD gist2
[14:07:00.555](0.000s) ok 406 - clean: should dump CREATE ACCESS METHOD regress_test_table_am
[14:07:00.555](0.000s) ok 407 - clean: should dump CREATE AGGREGATE dump_test.newavg
[14:07:00.555](0.000s) ok 408 - clean: should dump CREATE CAST FOR timestamptz
[14:07:00.556](0.000s) ok 409 - clean: should dump CREATE COLLATION test0 FROM "C"
[14:07:00.556](0.000s) ok 410 - clean: should dump CREATE CONVERSION dump_test.test_conversion
[14:07:00.556](0.000s) ok 411 - clean: should not dump CREATE DATABASE dump_test
[14:07:00.556](0.000s) ok 412 - clean: should not dump CREATE DATABASE dump_test2 LOCALE = 'C'
[14:07:00.557](0.000s) ok 413 - clean: should not dump CREATE DATABASE postgres
[14:07:00.557](0.000s) ok 414 - clean: should not dump CREATE DATABASE regression_invalid...
[14:07:00.559](0.002s) ok 415 - clean: should dump CREATE DOMAIN dump_test.us_postal_code
[14:07:00.559](0.000s) ok 416 - clean: should dump CREATE EVENT TRIGGER test_event_trigger
[14:07:00.560](0.000s) ok 417 - clean: should not dump CREATE EXTENSION ... plpgsql
[14:07:00.560](0.000s) ok 418 - clean: should dump CREATE FOREIGN DATA WRAPPER dummy
[14:07:00.560](0.000s) ok 419 - clean: should dump CREATE FOREIGN TABLE dump_test.foreign_table SERVER s1
[14:07:00.560](0.000s) ok 420 - clean: should dump CREATE FUNCTION ... SUPPORT
[14:07:00.560](0.000s) ok 421 - clean: should dump CREATE FUNCTION dump_test.event_trigger_func
[14:07:00.561](0.000s) ok 422 - clean: should dump CREATE FUNCTION dump_test.int42_in
[14:07:00.561](0.000s) ok 423 - clean: should dump CREATE FUNCTION dump_test.int42_out
[14:07:00.561](0.000s) ok 424 - clean: should dump CREATE FUNCTION dump_test.pltestlang_call_handler
[14:07:00.561](0.000s) ok 425 - clean: should dump CREATE FUNCTION dump_test.trigger_func
[14:07:00.561](0.000s) ok 426 - clean: should dump CREATE INDEX ... ON measurement_y2006_m2
[14:07:00.561](0.000s) ok 427 - clean: should dump CREATE INDEX ON ONLY measurement
[14:07:00.562](0.000s) ok 428 - clean: should dump CREATE LANGUAGE pltestlang
[14:07:00.562](0.000s) ok 429 - clean: should dump CREATE MATERIALIZED VIEW matview
[14:07:00.562](0.000s) ok 430 - clean: should dump CREATE MATERIALIZED VIEW matview_fourth
[14:07:00.562](0.000s) ok 431 - clean: should dump CREATE MATERIALIZED VIEW matview_second
[14:07:00.562](0.000s) ok 432 - clean: should dump CREATE MATERIALIZED VIEW matview_third
[14:07:00.563](0.000s) ok 433 - clean: should dump CREATE MATERIALIZED VIEW regress_pg_dump_matview_am
[14:07:00.563](0.000s) ok 434 - clean: should dump CREATE OPERATOR CLASS dump_test.op_class
[14:07:00.565](0.002s) ok 435 - clean: should dump CREATE OPERATOR CLASS dump_test.op_class_custom
[14:07:00.565](0.000s) ok 436 - clean: should dump CREATE OPERATOR CLASS dump_test.op_class_empty
[14:07:00.565](0.000s) ok 437 - clean: should dump CREATE OPERATOR FAMILY dump_test.op_family
[14:07:00.565](0.000s) ok 438 - clean: should dump CREATE POLICY p1 ON test_table
[14:07:00.566](0.000s) ok 439 - clean: should dump CREATE POLICY p2 ON test_table FOR SELECT
[14:07:00.566](0.000s) ok 440 - clean: should dump CREATE POLICY p3 ON test_table FOR INSERT
[14:07:00.566](0.000s) ok 441 - clean: should dump CREATE POLICY p4 ON test_table FOR UPDATE
[14:07:00.566](0.000s) ok 442 - clean: should dump CREATE POLICY p5 ON test_table FOR DELETE
[14:07:00.567](0.000s) ok 443 - clean: should dump CREATE POLICY p6 ON test_table AS RESTRICTIVE
[14:07:00.567](0.000s) ok 444 - clean: should dump CREATE PROCEDURE dump_test.ptest1
[14:07:00.567](0.000s) ok 445 - clean: should dump CREATE PROPERTY GRAPH propgraph
[14:07:00.567](0.000s) ok 446 - clean: should dump CREATE PUBLICATION pub1
[14:07:00.567](0.000s) ok 447 - clean: should dump CREATE PUBLICATION pub10
[14:07:00.568](0.000s) ok 448 - clean: should dump CREATE PUBLICATION pub2
[14:07:00.568](0.000s) ok 449 - clean: should dump CREATE PUBLICATION pub3
[14:07:00.568](0.000s) ok 450 - clean: should dump CREATE PUBLICATION pub4
[14:07:00.568](0.000s) ok 451 - clean: should dump CREATE PUBLICATION pub5
[14:07:00.568](0.000s) ok 452 - clean: should dump CREATE PUBLICATION pub6
[14:07:00.569](0.000s) ok 453 - clean: should dump CREATE PUBLICATION pub7
[14:07:00.569](0.000s) ok 454 - clean: should dump CREATE PUBLICATION pub8
[14:07:00.569](0.000s) ok 455 - clean: should dump CREATE PUBLICATION pub9
[14:07:00.569](0.000s) ok 456 - clean: should not dump CREATE ROLE regress_dump_test_role
[14:07:00.570](0.000s) ok 457 - clean: should not dump CREATE ROLE regress_quoted...
[14:07:00.570](0.000s) ok 458 - clean: should dump CREATE SCHEMA dump_test
[14:07:00.570](0.000s) ok 459 - clean: should dump CREATE SCHEMA dump_test_second_schema
[14:07:00.570](0.000s) ok 460 - clean: should not dump CREATE SCHEMA public
[14:07:00.570](0.000s) ok 461 - clean: should dump CREATE SEQUENCE test_table_col1_seq
[14:07:00.571](0.000s) ok 462 - clean: should dump CREATE SERVER s1 FOREIGN DATA WRAPPER dummy
[14:07:00.571](0.000s) ok 463 - clean: should dump CREATE STATISTICS extended_stats_expression
[14:07:00.571](0.000s) ok 464 - clean: should dump CREATE STATISTICS extended_stats_no_options
[14:07:00.571](0.000s) ok 465 - clean: should dump CREATE STATISTICS extended_stats_options
[14:07:00.572](0.000s) ok 466 - clean: should dump CREATE SUBSCRIPTION sub1
[14:07:00.572](0.000s) ok 467 - clean: should dump CREATE SUBSCRIPTION sub2
[14:07:00.572](0.000s) ok 468 - clean: should dump CREATE SUBSCRIPTION sub3
[14:07:00.572](0.000s) ok 469 - clean: should dump CREATE TABLE fk_reference_test_table
[14:07:00.572](0.000s) ok 470 - clean: should dump CREATE TABLE measurement PARTITIONED BY
[14:07:00.573](0.000s) ok 471 - clean: should dump CREATE TABLE regress_pg_dump_table_am
[14:07:00.581](0.009s) ok 472 - clean: should dump CREATE TABLE regress_pg_dump_table_part
[14:07:00.582](0.000s) ok 473 - clean: should dump CREATE TABLE table_with_stats
[14:07:00.582](0.000s) ok 474 - clean: should dump CREATE TABLE test_fifth_table
[14:07:00.582](0.000s) ok 475 - clean: should dump CREATE TABLE test_fourth_table_zero_col
[14:07:00.582](0.000s) ok 476 - clean: should dump CREATE TABLE test_inheritance_child
[14:07:00.583](0.000s) ok 477 - clean: should dump CREATE TABLE test_inheritance_parent
[14:07:00.583](0.000s) ok 478 - clean: should dump CREATE TABLE test_second_table
[14:07:00.583](0.000s) ok 479 - clean: should dump CREATE TABLE test_seventh_table
[14:07:00.583](0.000s) ok 480 - clean: should dump CREATE TABLE test_sixth_table
[14:07:00.586](0.003s) ok 481 - clean: should dump CREATE TABLE test_table
[14:07:00.586](0.000s) ok 482 - clean: should dump CREATE TABLE test_table_generated
[14:07:00.587](0.000s) ok 483 - clean: should dump CREATE TABLE test_table_generated_child1 (without local columns)
[14:07:00.587](0.000s) ok 484 - clean: should dump CREATE TABLE test_table_generated_child2 (with local columns)
[14:07:00.587](0.001s) ok 485 - clean: should dump CREATE TABLE test_table_identity
[14:07:00.588](0.000s) ok 486 - clean: should dump CREATE TABLE test_third_table_generated_cols
[14:07:00.588](0.000s) ok 487 - clean: should not dump CREATE TABLESPACE regress_dump_tablespace
[14:07:00.588](0.000s) ok 488 - clean: should dump CREATE TEXT SEARCH CONFIGURATION dump_test.alt_ts_conf1
[14:07:00.588](0.000s) ok 489 - clean: should dump CREATE TEXT SEARCH DICTIONARY dump_test.alt_ts_dict1
[14:07:00.589](0.000s) ok 490 - clean: should dump CREATE TEXT SEARCH PARSER dump_test.alt_ts_prs1
[14:07:00.589](0.000s) ok 491 - clean: should dump CREATE TEXT SEARCH TEMPLATE dump_test.alt_ts_temp1
[14:07:00.589](0.000s) ok 492 - clean: should dump CREATE TRANSFORM FOR int
[14:07:00.589](0.000s) ok 493 - clean: should dump CREATE TRIGGER test_trigger
[14:07:00.589](0.000s) ok 494 - clean: should dump CREATE TYPE dump_test.composite
[14:07:00.590](0.000s) ok 495 - clean: should dump CREATE TYPE dump_test.int42
[14:07:00.590](0.000s) ok 496 - clean: should dump CREATE TYPE dump_test.int42 populated
[14:07:00.590](0.000s) ok 497 - clean: should dump CREATE TYPE dump_test.planets AS ENUM
[14:07:00.590](0.000s) ok 498 - clean: should not dump CREATE TYPE dump_test.planets AS ENUM pg_upgrade
[14:07:00.590](0.000s) ok 499 - clean: should dump CREATE TYPE dump_test.textrange AS RANGE
[14:07:00.591](0.000s) ok 500 - clean: should dump CREATE TYPE dump_test.undefined
[14:07:00.591](0.000s) ok 501 - clean: should dump CREATE USER MAPPING FOR regress_dump_test_role SERVER s1
[14:07:00.591](0.000s) ok 502 - clean: should dump CREATE VIEW test_view
[14:07:00.592](0.001s) ok 503 - clean: should dump Check ordering of a function that depends on a primary key
[14:07:00.593](0.001s) ok 504 - clean: should dump Check ordering of a matview that depends on a primary key
[14:07:00.593](0.000s) ok 505 - clean: should dump Creation of row-level trigger in partitioned table
[14:07:00.593](0.000s) ok 506 - clean: should not dump DROP EXTENSION IF EXISTS plpgsql
[14:07:00.593](0.000s) ok 507 - clean: should not dump DROP EXTENSION plpgsql
[14:07:00.593](0.000s) ok 508 - clean: should not dump DROP FUNCTION IF EXISTS dump_test.pltestlang_call_handler()
[14:07:00.594](0.000s) ok 509 - clean: should dump DROP FUNCTION dump_test.pltestlang_call_handler()
[14:07:00.594](0.000s) ok 510 - clean: should not dump DROP LANGUAGE IF EXISTS pltestlang
[14:07:00.594](0.000s) ok 511 - clean: should dump DROP LANGUAGE pltestlang
[14:07:00.594](0.000s) ok 512 - clean: should not dump DROP ROLE pg_
[14:07:00.595](0.000s) ok 513 - clean: should not dump DROP ROLE regress_dump_test_role
[14:07:00.595](0.000s) ok 514 - clean: should not dump DROP SCHEMA IF EXISTS dump_test
[14:07:00.595](0.000s) ok 515 - clean: should not dump DROP SCHEMA IF EXISTS dump_test_second_schema
[14:07:00.595](0.000s) ok 516 - clean: should not dump DROP SCHEMA IF EXISTS public
[14:07:00.595](0.000s) ok 517 - clean: should dump DROP SCHEMA dump_test
[14:07:00.596](0.000s) ok 518 - clean: should dump DROP SCHEMA dump_test_second_schema
[14:07:00.596](0.000s) ok 519 - clean: should not dump DROP SCHEMA public
[14:07:00.596](0.000s) ok 520 - clean: should not dump DROP TABLE IF EXISTS test_second_table
[14:07:00.596](0.000s) ok 521 - clean: should not dump DROP TABLE IF EXISTS test_table
[14:07:00.597](0.000s) ok 522 - clean: should dump DROP TABLE fk_reference_test_table
[14:07:00.597](0.000s) ok 523 - clean: should dump DROP TABLE test_second_table
[14:07:00.597](0.000s) ok 524 - clean: should dump DROP TABLE test_table
[14:07:00.597](0.000s) ok 525 - clean: should dump Disabled trigger on partition is altered
[14:07:00.597](0.000s) ok 526 - clean: should not dump Disabled trigger on partition is not created
[14:07:00.598](0.000s) ok 527 - clean: should dump GRANT ALL ON LARGE OBJECT ...
[14:07:00.598](0.000s) ok 528 - clean: should not dump GRANT CREATE ON DATABASE dump_test
[14:07:00.598](0.000s) ok 529 - clean: should dump GRANT EXECUTE ON FUNCTION pg_sleep() TO regress_dump_test_role
[14:07:00.598](0.000s) ok 530 - clean: should dump GRANT INSERT(col1) ON TABLE test_second_table
[14:07:00.601](0.003s) ok 531 - clean: should dump GRANT SELECT (proname ...) ON TABLE pg_proc TO public
[14:07:00.602](0.000s) ok 532 - clean: should dump GRANT SELECT ON PROPERTY GRAPH propgraph
[14:07:00.602](0.001s) ok 533 - clean: should dump GRANT SELECT ON TABLE measurement
[14:07:00.602](0.000s) ok 534 - clean: should dump GRANT SELECT ON TABLE measurement_y2006m2
[14:07:00.603](0.000s) ok 535 - clean: should dump GRANT SELECT ON TABLE test_table
[14:07:00.603](0.000s) ok 536 - clean: should dump GRANT USAGE ON DOMAIN dump_test.us_postal_code
[14:07:00.603](0.000s) ok 537 - clean: should dump GRANT USAGE ON FOREIGN DATA WRAPPER dummy
[14:07:00.603](0.000s) ok 538 - clean: should dump GRANT USAGE ON FOREIGN SERVER s1
[14:07:00.604](0.000s) ok 539 - clean: should dump GRANT USAGE ON SCHEMA dump_test_second_schema
[14:07:00.604](0.000s) ok 540 - clean: should not dump GRANT USAGE ON SCHEMA public TO public
[14:07:00.604](0.000s) ok 541 - clean: should dump GRANT USAGE ON TYPE dump_test.int42
[14:07:00.604](0.000s) ok 542 - clean: should dump GRANT USAGE ON TYPE dump_test.planets - ENUM
[14:07:00.604](0.000s) ok 543 - clean: should dump GRANT USAGE ON TYPE dump_test.textrange - RANGE
[14:07:00.605](0.000s) ok 544 - clean: should not dump INSERT INTO test_fifth_table
[14:07:00.605](0.000s) ok 545 - clean: should not dump INSERT INTO test_fourth_table
[14:07:00.605](0.000s) ok 546 - clean: should not dump INSERT INTO test_second_table
[14:07:00.605](0.000s) ok 547 - clean: should not dump INSERT INTO test_table
[14:07:00.606](0.000s) ok 548 - clean: should not dump INSERT INTO test_table_identity
[14:07:00.606](0.000s) ok 549 - clean: should not dump INSERT INTO test_third_table
[14:07:00.606](0.000s) ok 550 - clean: should not dump INSERT INTO test_third_table (colnames)
[14:07:00.606](0.000s) ok 551 - clean: should dump LO create (using lo_from_bytea)
[14:07:00.607](0.000s) ok 552 - clean: should dump LO create (with no data)
[14:07:00.607](0.000s) ok 553 - clean: should dump LO load (using lo_from_bytea)
[14:07:00.607](0.000s) ok 554 - clean: should dump Partition measurement_y2006m2 creation
[14:07:00.607](0.000s) ok 555 - clean: should dump REFRESH MATERIALIZED VIEW matview
[14:07:00.608](0.000s) ok 556 - clean: should not dump REFRESH MATERIALIZED VIEW matview_fourth
[14:07:00.608](0.000s) ok 557 - clean: should dump REFRESH MATERIALIZED VIEW matview_second
[14:07:00.608](0.000s) ok 558 - clean: should not dump REFRESH MATERIALIZED VIEW matview_third
[14:07:00.608](0.000s) ok 559 - clean: should dump REVOKE ALL ON SCHEMA public
[14:07:00.609](0.000s) ok 560 - clean: should not dump REVOKE CONNECT ON DATABASE dump_test FROM public
[14:07:00.609](0.000s) ok 561 - clean: should dump REVOKE EXECUTE ON FUNCTION pg_sleep() FROM public
[14:07:00.646](0.037s) ok 562 - clean: should not dump REVOKE EXECUTE ON FUNCTION pg_stat_reset FROM regress_dump_test_role
[14:07:00.646](0.000s) ok 563 - clean: should dump REVOKE SELECT ON TABLE pg_proc FROM public
[14:07:00.646](0.000s) ok 564 - clean: should dump REVOKE USAGE ON LANGUAGE plpgsql FROM public
[14:07:00.646](0.000s) ok 565 - clean: should dump Replica trigger on partition is altered
[14:07:00.647](0.000s) ok 566 - clean: should not dump Triggers on partitions are not dropped
[14:07:00.647](0.000s) ok 567 - clean: should dump extended_statistics_import
[14:07:00.648](0.001s) ok 568 - clean: should not dump newline of table name in comment
[14:07:00.648](0.000s) ok 569 - clean: should dump relstats_on_unanalyzed_tables
[14:07:00.648](0.000s) ok 570 - clean: should dump restrict
[14:07:00.649](0.001s) ok 571 - clean: should dump statistics_import
[14:07:00.649](0.000s) ok 572 - clean: should not dump test_table with 4-row INSERTs
[14:07:00.650](0.000s) ok 573 - clean: should dump unrestrict
# Running: pg_dump --no-sync --file C:\cirrus\build\testrun\pg_dump\002_pg_dump\data\tmp_test_9UIx/clean_if_exists.sql --clean --if-exists --encoding UTF8 --statistics postgres
[14:07:01.628](0.978s) ok 574 - clean_if_exists: pg_dump runs
[14:07:01.631](0.003s) ok 575 - clean_if_exists: should dump ALTER COLLATION test0 OWNER TO
[14:07:01.631](0.000s) ok 576 - clean_if_exists: should dump ALTER DEFAULT PRIVILEGES FOR ROLE regress_dump_test_role GRANT
[14:07:01.632](0.000s) ok 577 - clean_if_exists: should dump ALTER DEFAULT PRIVILEGES FOR ROLE regress_dump_test_role GRANT EXECUTE ON FUNCTIONS
[14:07:01.632](0.000s) ok 578 - clean_if_exists: should dump ALTER DEFAULT PRIVILEGES FOR ROLE regress_dump_test_role REVOKE
[14:07:01.632](0.000s) ok 579 - clean_if_exists: should dump ALTER DEFAULT PRIVILEGES FOR ROLE regress_dump_test_role REVOKE SELECT
[14:07:01.632](0.000s) ok 580 - clean_if_exists: should dump ALTER FOREIGN DATA WRAPPER dummy OWNER TO
[14:07:01.633](0.000s) ok 581 - clean_if_exists: should dump ALTER FOREIGN TABLE foreign_table ALTER COLUMN c1 OPTIONS
[14:07:01.633](0.000s) ok 582 - clean_if_exists: should dump ALTER FOREIGN TABLE foreign_table OWNER TO
[14:07:01.633](0.000s) ok 583 - clean_if_exists: should dump ALTER FUNCTION dump_test.pltestlang_call_handler() OWNER TO
[14:07:01.633](0.000s) ok 584 - clean_if_exists: should dump ALTER INDEX ... ATTACH PARTITION
[14:07:01.634](0.000s) ok 585 - clean_if_exists: should dump ALTER INDEX ... ATTACH PARTITION (primary key)
[14:07:01.634](0.000s) ok 586 - clean_if_exists: should dump ALTER LARGE OBJECT ... OWNER TO
[14:07:01.634](0.000s) ok 587 - clean_if_exists: should dump ALTER OPERATOR CLASS dump_test.op_class OWNER TO
[14:07:01.634](0.000s) ok 588 - clean_if_exists: should dump ALTER OPERATOR FAMILY dump_test.op_family OWNER TO
[14:07:01.635](0.000s) ok 589 - clean_if_exists: should dump ALTER OPERATOR FAMILY dump_test.op_family USING btree
[14:07:01.635](0.000s) ok 590 - clean_if_exists: should dump ALTER PROCEDURAL LANGUAGE pltestlang OWNER TO
[14:07:01.635](0.000s) ok 591 - clean_if_exists: should dump ALTER PUBLICATION pub1 ADD TABLE test_second_table
[14:07:01.635](0.000s) ok 592 - clean_if_exists: should dump ALTER PUBLICATION pub1 ADD TABLE test_seventh_table (col3, col2) WHERE (col1 = 1)
[14:07:01.635](0.000s) ok 593 - clean_if_exists: should dump ALTER PUBLICATION pub1 ADD TABLE test_sixth_table (col3, col2)
[14:07:01.636](0.000s) ok 594 - clean_if_exists: should dump ALTER PUBLICATION pub1 ADD TABLE test_table
[14:07:01.636](0.000s) ok 595 - clean_if_exists: should dump ALTER PUBLICATION pub1 OWNER TO
[14:07:01.636](0.000s) ok 596 - clean_if_exists: should dump ALTER PUBLICATION pub3 ADD TABLE test_table
[14:07:01.636](0.000s) ok 597 - clean_if_exists: should dump ALTER PUBLICATION pub3 ADD TABLES IN SCHEMA dump_test
[14:07:01.637](0.000s) ok 598 - clean_if_exists: should dump ALTER PUBLICATION pub3 ADD TABLES IN SCHEMA public
[14:07:01.637](0.000s) ok 599 - clean_if_exists: should dump ALTER PUBLICATION pub4 ADD TABLE test_second_table WHERE (col2 = 'test');
[14:07:01.637](0.000s) ok 600 - clean_if_exists: should dump ALTER PUBLICATION pub4 ADD TABLE test_table WHERE (col1 > 0);
[14:07:01.637](0.000s) ok 601 - clean_if_exists: should not dump ALTER ROLE regress_dump_test_role
[14:07:01.638](0.000s) ok 602 - clean_if_exists: should dump ALTER SCHEMA dump_test OWNER TO
[14:07:01.638](0.000s) ok 603 - clean_if_exists: should dump ALTER SCHEMA dump_test_second_schema OWNER TO
[14:07:01.638](0.000s) ok 604 - clean_if_exists: should dump ALTER SCHEMA public OWNER TO
[14:07:01.638](0.000s) ok 605 - clean_if_exists: should dump ALTER SEQUENCE test_table_col1_seq
[14:07:01.638](0.000s) ok 606 - clean_if_exists: should dump ALTER SERVER s1 OWNER TO
[14:07:01.639](0.000s) ok 607 - clean_if_exists: should dump ALTER STATISTICS extended_stats_options
[14:07:01.639](0.000s) ok 608 - clean_if_exists: should dump ALTER TABLE (partitioned) ADD CONSTRAINT ... FOREIGN KEY
[14:07:01.639](0.000s) ok 609 - clean_if_exists: should dump ALTER TABLE ONLY dump_test.measurement ATTACH PARTITION measurement_y2006m2
[14:07:01.639](0.000s) ok 610 - clean_if_exists: should dump ALTER TABLE ONLY test_table ADD CONSTRAINT ... PRIMARY KEY
[14:07:01.640](0.000s) ok 611 - clean_if_exists: should dump ALTER TABLE ONLY test_table ALTER COLUMN col1 SET STATISTICS 90
[14:07:01.640](0.000s) ok 612 - clean_if_exists: should dump ALTER TABLE ONLY test_table ALTER COLUMN col2 SET STORAGE
[14:07:01.640](0.000s) ok 613 - clean_if_exists: should dump ALTER TABLE ONLY test_table ALTER COLUMN col3 SET STORAGE
[14:07:01.640](0.000s) ok 614 - clean_if_exists: should dump ALTER TABLE ONLY test_table ALTER COLUMN col4 SET n_distinct
[14:07:01.641](0.000s) ok 615 - clean_if_exists: should dump ALTER TABLE measurement OWNER TO
[14:07:01.641](0.000s) ok 616 - clean_if_exists: should dump ALTER TABLE measurement PRIMARY KEY
[14:07:01.641](0.000s) ok 617 - clean_if_exists: should dump ALTER TABLE measurement_y2006m2 OWNER TO
[14:07:01.641](0.000s) ok 618 - clean_if_exists: should dump ALTER TABLE test_second_table OWNER TO
[14:07:01.641](0.000s) ok 619 - clean_if_exists: should dump ALTER TABLE test_table CLUSTER ON test_table_pkey
[14:07:01.642](0.000s) ok 620 - clean_if_exists: should not dump ALTER TABLE test_table DISABLE TRIGGER ALL
[14:07:01.642](0.000s) ok 621 - clean_if_exists: should dump ALTER TABLE test_table ENABLE ROW LEVEL SECURITY
[14:07:01.642](0.000s) ok 622 - clean_if_exists: should dump ALTER TABLE test_table OWNER TO
[14:07:01.642](0.000s) ok 623 - clean_if_exists: should not dump ALTER TABLE test_table_generated_child1
[14:07:01.643](0.000s) ok 624 - clean_if_exists: should dump ALTER TEXT SEARCH CONFIGURATION alt_ts_conf1 OWNER TO
[14:07:01.643](0.000s) ok 625 - clean_if_exists: should dump ALTER TEXT SEARCH CONFIGURATION dump_test.alt_ts_conf1 ...
[14:07:01.643](0.000s) ok 626 - clean_if_exists: should dump ALTER TEXT SEARCH DICTIONARY alt_ts_dict1 OWNER TO
[14:07:01.643](0.000s) ok 627 - clean_if_exists: should dump ALTER VIEW test_view SET DEFAULT
[14:07:01.643](0.000s) ok 628 - clean_if_exists: should dump Always trigger on partition is altered
[14:07:01.644](0.000s) ok 629 - clean_if_exists: should dump COMMENT ON COLLATION test0
[14:07:01.644](0.000s) ok 630 - clean_if_exists: should dump COMMENT ON COLUMN dump_test.composite.f1
[14:07:01.644](0.000s) ok 631 - clean_if_exists: should dump COMMENT ON COLUMN dump_test.test_second_table.col1
[14:07:01.644](0.000s) ok 632 - clean_if_exists: should dump COMMENT ON COLUMN dump_test.test_second_table.col2
[14:07:01.644](0.000s) ok 633 - clean_if_exists: should dump COMMENT ON COLUMN dump_test.test_table.col1
[14:07:01.645](0.000s) ok 634 - clean_if_exists: should dump COMMENT ON CONSTRAINT ON DOMAIN (1)
[14:07:01.645](0.000s) ok 635 - clean_if_exists: should dump COMMENT ON CONSTRAINT ON DOMAIN (2)
[14:07:01.645](0.000s) ok 636 - clean_if_exists: should dump COMMENT ON CONSTRAINT ON test_table_chld2
[14:07:01.645](0.000s) ok 637 - clean_if_exists: should dump COMMENT ON CONSTRAINT ON test_table_nn
[14:07:01.645](0.000s) ok 638 - clean_if_exists: should dump COMMENT ON CONVERSION dump_test.test_conversion
[14:07:01.646](0.000s) ok 639 - clean_if_exists: should not dump COMMENT ON DATABASE postgres
[14:07:01.646](0.000s) ok 640 - clean_if_exists: should not dump COMMENT ON EXTENSION plpgsql
[14:07:01.646](0.000s) ok 641 - clean_if_exists: should dump COMMENT ON LARGE OBJECT ...
[14:07:01.647](0.000s) ok 642 - clean_if_exists: should dump COMMENT ON POLICY p1
[14:07:01.647](0.000s) ok 643 - clean_if_exists: should dump COMMENT ON PUBLICATION pub1
[14:07:01.647](0.000s) ok 644 - clean_if_exists: should not dump COMMENT ON SCHEMA public
[14:07:01.647](0.000s) ok 645 - clean_if_exists: should dump COMMENT ON SUBSCRIPTION sub1
[14:07:01.648](0.000s) ok 646 - clean_if_exists: should dump COMMENT ON TABLE dump_test.test_table
[14:07:01.648](0.000s) ok 647 - clean_if_exists: should dump COMMENT ON TEXT SEARCH CONFIGURATION dump_test.alt_ts_conf1
[14:07:01.648](0.000s) ok 648 - clean_if_exists: should dump COMMENT ON TEXT SEARCH DICTIONARY dump_test.alt_ts_dict1
[14:07:01.648](0.000s) ok 649 - clean_if_exists: should dump COMMENT ON TEXT SEARCH PARSER dump_test.alt_ts_prs1
[14:07:01.648](0.000s) ok 650 - clean_if_exists: should dump COMMENT ON TEXT SEARCH TEMPLATE dump_test.alt_ts_temp1
[14:07:01.649](0.000s) ok 651 - clean_if_exists: should dump COMMENT ON TYPE dump_test.int42 - Regular
[14:07:01.649](0.000s) ok 652 - clean_if_exists: should dump COMMENT ON TYPE dump_test.planets - ENUM
[14:07:01.649](0.000s) ok 653 - clean_if_exists: should dump COMMENT ON TYPE dump_test.textrange - RANGE
[14:07:01.649](0.000s) ok 654 - clean_if_exists: should dump COMMENT ON TYPE dump_test.undefined - Undefined
[14:07:01.649](0.000s) ok 655 - clean_if_exists: should dump CONSTRAINT NOT NULL / NO INHERIT
[14:07:01.650](0.000s) ok 656 - clean_if_exists: should dump CONSTRAINT NOT NULL / NO INHERIT (child1)
[14:07:01.650](0.000s) ok 657 - clean_if_exists: should dump CONSTRAINT NOT NULL / NOT VALID
[14:07:01.650](0.000s) ok 658 - clean_if_exists: should dump CONSTRAINT NOT NULL / NOT VALID (child1)
[14:07:01.650](0.000s) ok 659 - clean_if_exists: should dump CONSTRAINT NOT NULL / NOT VALID (child2)
[14:07:01.650](0.000s) ok 660 - clean_if_exists: should dump CONSTRAINT NOT NULL / NOT VALID (child3)
[14:07:01.651](0.000s) ok 661 - clean_if_exists: should dump CONSTRAINT PRIMARY KEY / WITHOUT OVERLAPS
[14:07:01.651](0.000s) ok 662 - clean_if_exists: should dump CONSTRAINT UNIQUE / WITHOUT OVERLAPS
[14:07:01.651](0.000s) ok 663 - clean_if_exists: should dump COPY fk_reference_test_table
[14:07:01.651](0.000s) ok 664 - clean_if_exists: should not dump COPY fk_reference_test_table second
[14:07:01.652](0.000s) ok 665 - clean_if_exists: should dump COPY measurement
[14:07:01.652](0.000s) ok 666 - clean_if_exists: should dump COPY test_fifth_table
[14:07:01.652](0.000s) ok 667 - clean_if_exists: should dump COPY test_fourth_table
[14:07:01.652](0.000s) ok 668 - clean_if_exists: should dump COPY test_second_table
[14:07:01.653](0.000s) ok 669 - clean_if_exists: should dump COPY test_table
[14:07:01.653](0.000s) ok 670 - clean_if_exists: should dump COPY test_table_identity
[14:07:01.653](0.000s) ok 671 - clean_if_exists: should dump COPY test_third_table
[14:07:01.653](0.000s) ok 672 - clean_if_exists: should dump CREATE ACCESS METHOD gist2
[14:07:01.653](0.000s) ok 673 - clean_if_exists: should dump CREATE ACCESS METHOD regress_test_table_am
[14:07:01.654](0.000s) ok 674 - clean_if_exists: should dump CREATE AGGREGATE dump_test.newavg
[14:07:01.654](0.000s) ok 675 - clean_if_exists: should dump CREATE CAST FOR timestamptz
[14:07:01.654](0.000s) ok 676 - clean_if_exists: should dump CREATE COLLATION test0 FROM "C"
[14:07:01.654](0.000s) ok 677 - clean_if_exists: should dump CREATE CONVERSION dump_test.test_conversion
[14:07:01.654](0.000s) ok 678 - clean_if_exists: should not dump CREATE DATABASE dump_test
[14:07:01.655](0.000s) ok 679 - clean_if_exists: should not dump CREATE DATABASE dump_test2 LOCALE = 'C'
[14:07:01.655](0.000s) ok 680 - clean_if_exists: should not dump CREATE DATABASE postgres
[14:07:01.655](0.000s) ok 681 - clean_if_exists: should not dump CREATE DATABASE regression_invalid...
[14:07:01.658](0.002s) ok 682 - clean_if_exists: should dump CREATE DOMAIN dump_test.us_postal_code
[14:07:01.658](0.000s) ok 683 - clean_if_exists: should dump CREATE EVENT TRIGGER test_event_trigger
[14:07:01.658](0.000s) ok 684 - clean_if_exists: should not dump CREATE EXTENSION ... plpgsql
[14:07:01.658](0.000s) ok 685 - clean_if_exists: should dump CREATE FOREIGN DATA WRAPPER dummy
[14:07:01.659](0.000s) ok 686 - clean_if_exists: should dump CREATE FOREIGN TABLE dump_test.foreign_table SERVER s1
[14:07:01.659](0.000s) ok 687 - clean_if_exists: should dump CREATE FUNCTION ... SUPPORT
[14:07:01.659](0.000s) ok 688 - clean_if_exists: should dump CREATE FUNCTION dump_test.event_trigger_func
[14:07:01.659](0.000s) ok 689 - clean_if_exists: should dump CREATE FUNCTION dump_test.int42_in
[14:07:01.659](0.000s) ok 690 - clean_if_exists: should dump CREATE FUNCTION dump_test.int42_out
[14:07:01.660](0.000s) ok 691 - clean_if_exists: should dump CREATE FUNCTION dump_test.pltestlang_call_handler
[14:07:01.660](0.000s) ok 692 - clean_if_exists: should dump CREATE FUNCTION dump_test.trigger_func
[14:07:01.660](0.000s) ok 693 - clean_if_exists: should dump CREATE INDEX ... ON measurement_y2006_m2
[14:07:01.660](0.000s) ok 694 - clean_if_exists: should dump CREATE INDEX ON ONLY measurement
[14:07:01.660](0.000s) ok 695 - clean_if_exists: should dump CREATE LANGUAGE pltestlang
[14:07:01.661](0.000s) ok 696 - clean_if_exists: should dump CREATE MATERIALIZED VIEW matview
[14:07:01.661](0.000s) ok 697 - clean_if_exists: should dump CREATE MATERIALIZED VIEW matview_fourth
[14:07:01.661](0.000s) ok 698 - clean_if_exists: should dump CREATE MATERIALIZED VIEW matview_second
[14:07:01.661](0.000s) ok 699 - clean_if_exists: should dump CREATE MATERIALIZED VIEW matview_third
[14:07:01.662](0.000s) ok 700 - clean_if_exists: should dump CREATE MATERIALIZED VIEW regress_pg_dump_matview_am
[14:07:01.662](0.000s) ok 701 - clean_if_exists: should dump CREATE OPERATOR CLASS dump_test.op_class
[14:07:01.664](0.002s) ok 702 - clean_if_exists: should dump CREATE OPERATOR CLASS dump_test.op_class_custom
[14:07:01.664](0.000s) ok 703 - clean_if_exists: should dump CREATE OPERATOR CLASS dump_test.op_class_empty
[14:07:01.664](0.000s) ok 704 - clean_if_exists: should dump CREATE OPERATOR FAMILY dump_test.op_family
[14:07:01.664](0.000s) ok 705 - clean_if_exists: should dump CREATE POLICY p1 ON test_table
[14:07:01.665](0.000s) ok 706 - clean_if_exists: should dump CREATE POLICY p2 ON test_table FOR SELECT
[14:07:01.665](0.000s) ok 707 - clean_if_exists: should dump CREATE POLICY p3 ON test_table FOR INSERT
[14:07:01.665](0.000s) ok 708 - clean_if_exists: should dump CREATE POLICY p4 ON test_table FOR UPDATE
[14:07:01.665](0.000s) ok 709 - clean_if_exists: should dump CREATE POLICY p5 ON test_table FOR DELETE
[14:07:01.666](0.000s) ok 710 - clean_if_exists: should dump CREATE POLICY p6 ON test_table AS RESTRICTIVE
[14:07:01.666](0.000s) ok 711 - clean_if_exists: should dump CREATE PROCEDURE dump_test.ptest1
[14:07:01.666](0.000s) ok 712 - clean_if_exists: should dump CREATE PROPERTY GRAPH propgraph
[14:07:01.666](0.000s) ok 713 - clean_if_exists: should dump CREATE PUBLICATION pub1
[14:07:01.667](0.000s) ok 714 - clean_if_exists: should dump CREATE PUBLICATION pub10
[14:07:01.667](0.000s) ok 715 - clean_if_exists: should dump CREATE PUBLICATION pub2
[14:07:01.667](0.000s) ok 716 - clean_if_exists: should dump CREATE PUBLICATION pub3
[14:07:01.667](0.000s) ok 717 - clean_if_exists: should dump CREATE PUBLICATION pub4
[14:07:01.668](0.000s) ok 718 - clean_if_exists: should dump CREATE PUBLICATION pub5
[14:07:01.668](0.000s) ok 719 - clean_if_exists: should dump CREATE PUBLICATION pub6
[14:07:01.668](0.000s) ok 720 - clean_if_exists: should dump CREATE PUBLICATION pub7
[14:07:01.668](0.000s) ok 721 - clean_if_exists: should dump CREATE PUBLICATION pub8
[14:07:01.668](0.000s) ok 722 - clean_if_exists: should dump CREATE PUBLICATION pub9
[14:07:01.669](0.000s) ok 723 - clean_if_exists: should not dump CREATE ROLE regress_dump_test_role
[14:07:01.669](0.000s) ok 724 - clean_if_exists: should not dump CREATE ROLE regress_quoted...
[14:07:01.669](0.000s) ok 725 - clean_if_exists: should dump CREATE SCHEMA dump_test
[14:07:01.669](0.000s) ok 726 - clean_if_exists: should dump CREATE SCHEMA dump_test_second_schema
[14:07:01.670](0.000s) ok 727 - clean_if_exists: should not dump CREATE SCHEMA public
[14:07:01.670](0.000s) ok 728 - clean_if_exists: should dump CREATE SEQUENCE test_table_col1_seq
[14:07:01.670](0.000s) ok 729 - clean_if_exists: should dump CREATE SERVER s1 FOREIGN DATA WRAPPER dummy
[14:07:01.670](0.000s) ok 730 - clean_if_exists: should dump CREATE STATISTICS extended_stats_expression
[14:07:01.671](0.000s) ok 731 - clean_if_exists: should dump CREATE STATISTICS extended_stats_no_options
[14:07:01.671](0.000s) ok 732 - clean_if_exists: should dump CREATE STATISTICS extended_stats_options
[14:07:01.671](0.000s) ok 733 - clean_if_exists: should dump CREATE SUBSCRIPTION sub1
[14:07:01.671](0.000s) ok 734 - clean_if_exists: should dump CREATE SUBSCRIPTION sub2
[14:07:01.672](0.000s) ok 735 - clean_if_exists: should dump CREATE SUBSCRIPTION sub3
[14:07:01.672](0.000s) ok 736 - clean_if_exists: should dump CREATE TABLE fk_reference_test_table
[14:07:01.672](0.000s) ok 737 - clean_if_exists: should dump CREATE TABLE measurement PARTITIONED BY
[14:07:01.672](0.000s) ok 738 - clean_if_exists: should dump CREATE TABLE regress_pg_dump_table_am
[14:07:01.681](0.009s) ok 739 - clean_if_exists: should dump CREATE TABLE regress_pg_dump_table_part
[14:07:01.682](0.000s) ok 740 - clean_if_exists: should dump CREATE TABLE table_with_stats
[14:07:01.682](0.000s) ok 741 - clean_if_exists: should dump CREATE TABLE test_fifth_table
[14:07:01.682](0.000s) ok 742 - clean_if_exists: should dump CREATE TABLE test_fourth_table_zero_col
[14:07:01.682](0.000s) ok 743 - clean_if_exists: should dump CREATE TABLE test_inheritance_child
[14:07:01.683](0.000s) ok 744 - clean_if_exists: should dump CREATE TABLE test_inheritance_parent
[14:07:01.683](0.000s) ok 745 - clean_if_exists: should dump CREATE TABLE test_second_table
[14:07:01.683](0.000s) ok 746 - clean_if_exists: should dump CREATE TABLE test_seventh_table
[14:07:01.683](0.000s) ok 747 - clean_if_exists: should dump CREATE TABLE test_sixth_table
[14:07:01.686](0.003s) ok 748 - clean_if_exists: should dump CREATE TABLE test_table
[14:07:01.687](0.000s) ok 749 - clean_if_exists: should dump CREATE TABLE test_table_generated
[14:07:01.687](0.000s) ok 750 - clean_if_exists: should dump CREATE TABLE test_table_generated_child1 (without local columns)
[14:07:01.687](0.000s) ok 751 - clean_if_exists: should dump CREATE TABLE test_table_generated_child2 (with local columns)
[14:07:01.688](0.001s) ok 752 - clean_if_exists: should dump CREATE TABLE test_table_identity
[14:07:01.688](0.000s) ok 753 - clean_if_exists: should dump CREATE TABLE test_third_table_generated_cols
[14:07:01.688](0.000s) ok 754 - clean_if_exists: should not dump CREATE TABLESPACE regress_dump_tablespace
[14:07:01.689](0.000s) ok 755 - clean_if_exists: should dump CREATE TEXT SEARCH CONFIGURATION dump_test.alt_ts_conf1
[14:07:01.689](0.000s) ok 756 - clean_if_exists: should dump CREATE TEXT SEARCH DICTIONARY dump_test.alt_ts_dict1
[14:07:01.689](0.000s) ok 757 - clean_if_exists: should dump CREATE TEXT SEARCH PARSER dump_test.alt_ts_prs1
[14:07:01.689](0.000s) ok 758 - clean_if_exists: should dump CREATE TEXT SEARCH TEMPLATE dump_test.alt_ts_temp1
[14:07:01.689](0.000s) ok 759 - clean_if_exists: should dump CREATE TRANSFORM FOR int
[14:07:01.690](0.000s) ok 760 - clean_if_exists: should dump CREATE TRIGGER test_trigger
[14:07:01.690](0.000s) ok 761 - clean_if_exists: should dump CREATE TYPE dump_test.composite
[14:07:01.690](0.000s) ok 762 - clean_if_exists: should dump CREATE TYPE dump_test.int42
[14:07:01.690](0.000s) ok 763 - clean_if_exists: should dump CREATE TYPE dump_test.int42 populated
[14:07:01.690](0.000s) ok 764 - clean_if_exists: should dump CREATE TYPE dump_test.planets AS ENUM
[14:07:01.691](0.000s) ok 765 - clean_if_exists: should not dump CREATE TYPE dump_test.planets AS ENUM pg_upgrade
[14:07:01.691](0.000s) ok 766 - clean_if_exists: should dump CREATE TYPE dump_test.textrange AS RANGE
[14:07:01.691](0.000s) ok 767 - clean_if_exists: should dump CREATE TYPE dump_test.undefined
[14:07:01.691](0.000s) ok 768 - clean_if_exists: should dump CREATE USER MAPPING FOR regress_dump_test_role SERVER s1
[14:07:01.692](0.000s) ok 769 - clean_if_exists: should dump CREATE VIEW test_view
[14:07:01.692](0.001s) ok 770 - clean_if_exists: should dump Check ordering of a function that depends on a primary key
[14:07:01.693](0.001s) ok 771 - clean_if_exists: should dump Check ordering of a matview that depends on a primary key
[14:07:01.693](0.000s) ok 772 - clean_if_exists: should dump Creation of row-level trigger in partitioned table
[14:07:01.694](0.000s) ok 773 - clean_if_exists: should not dump DROP EXTENSION IF EXISTS plpgsql
[14:07:01.694](0.000s) ok 774 - clean_if_exists: should not dump DROP EXTENSION plpgsql
[14:07:01.694](0.000s) ok 775 - clean_if_exists: should dump DROP FUNCTION IF EXISTS dump_test.pltestlang_call_handler()
[14:07:01.694](0.000s) ok 776 - clean_if_exists: should not dump DROP FUNCTION dump_test.pltestlang_call_handler()
[14:07:01.695](0.000s) ok 777 - clean_if_exists: should dump DROP LANGUAGE IF EXISTS pltestlang
[14:07:01.695](0.000s) ok 778 - clean_if_exists: should not dump DROP LANGUAGE pltestlang
[14:07:01.695](0.000s) ok 779 - clean_if_exists: should not dump DROP ROLE pg_
[14:07:01.695](0.000s) ok 780 - clean_if_exists: should not dump DROP ROLE regress_dump_test_role
[14:07:01.696](0.000s) ok 781 - clean_if_exists: should dump DROP SCHEMA IF EXISTS dump_test
[14:07:01.696](0.000s) ok 782 - clean_if_exists: should dump DROP SCHEMA IF EXISTS dump_test_second_schema
[14:07:01.696](0.000s) ok 783 - clean_if_exists: should not dump DROP SCHEMA IF EXISTS public
[14:07:01.696](0.000s) ok 784 - clean_if_exists: should not dump DROP SCHEMA dump_test
[14:07:01.697](0.000s) ok 785 - clean_if_exists: should not dump DROP SCHEMA dump_test_second_schema
[14:07:01.697](0.000s) ok 786 - clean_if_exists: should not dump DROP SCHEMA public
[14:07:01.697](0.000s) ok 787 - clean_if_exists: should dump DROP TABLE IF EXISTS test_second_table
[14:07:01.697](0.000s) ok 788 - clean_if_exists: should dump DROP TABLE IF EXISTS test_table
[14:07:01.698](0.000s) ok 789 - clean_if_exists: should not dump DROP TABLE fk_reference_test_table
[14:07:01.698](0.000s) ok 790 - clean_if_exists: should not dump DROP TABLE test_second_table
[14:07:01.698](0.000s) ok 791 - clean_if_exists: should not dump DROP TABLE test_table
[14:07:01.698](0.000s) ok 792 - clean_if_exists: should dump Disabled trigger on partition is altered
[14:07:01.699](0.000s) ok 793 - clean_if_exists: should not dump Disabled trigger on partition is not created
[14:07:01.699](0.000s) ok 794 - clean_if_exists: should dump GRANT ALL ON LARGE OBJECT ...
[14:07:01.699](0.000s) ok 795 - clean_if_exists: should not dump GRANT CREATE ON DATABASE dump_test
[14:07:01.699](0.000s) ok 796 - clean_if_exists: should dump GRANT EXECUTE ON FUNCTION pg_sleep() TO regress_dump_test_role
[14:07:01.700](0.000s) ok 797 - clean_if_exists: should dump GRANT INSERT(col1) ON TABLE test_second_table
[14:07:01.703](0.003s) ok 798 - clean_if_exists: should dump GRANT SELECT (proname ...) ON TABLE pg_proc TO public
[14:07:01.703](0.000s) ok 799 - clean_if_exists: should dump GRANT SELECT ON PROPERTY GRAPH propgraph
[14:07:01.704](0.001s) ok 800 - clean_if_exists: should dump GRANT SELECT ON TABLE measurement
[14:07:01.704](0.000s) ok 801 - clean_if_exists: should dump GRANT SELECT ON TABLE measurement_y2006m2
[14:07:01.704](0.000s) ok 802 - clean_if_exists: should dump GRANT SELECT ON TABLE test_table
[14:07:01.704](0.000s) ok 803 - clean_if_exists: should dump GRANT USAGE ON DOMAIN dump_test.us_postal_code
[14:07:01.705](0.000s) ok 804 - clean_if_exists: should dump GRANT USAGE ON FOREIGN DATA WRAPPER dummy
[14:07:01.705](0.000s) ok 805 - clean_if_exists: should dump GRANT USAGE ON FOREIGN SERVER s1
[14:07:01.705](0.000s) ok 806 - clean_if_exists: should dump GRANT USAGE ON SCHEMA dump_test_second_schema
[14:07:01.705](0.000s) ok 807 - clean_if_exists: should not dump GRANT USAGE ON SCHEMA public TO public
[14:07:01.706](0.000s) ok 808 - clean_if_exists: should dump GRANT USAGE ON TYPE dump_test.int42
[14:07:01.706](0.000s) ok 809 - clean_if_exists: should dump GRANT USAGE ON TYPE dump_test.planets - ENUM
[14:07:01.706](0.000s) ok 810 - clean_if_exists: should dump GRANT USAGE ON TYPE dump_test.textrange - RANGE
[14:07:01.706](0.000s) ok 811 - clean_if_exists: should not dump INSERT INTO test_fifth_table
[14:07:01.707](0.000s) ok 812 - clean_if_exists: should not dump INSERT INTO test_fourth_table
[14:07:01.707](0.000s) ok 813 - clean_if_exists: should not dump INSERT INTO test_second_table
[14:07:01.707](0.000s) ok 814 - clean_if_exists: should not dump INSERT INTO test_table
[14:07:01.707](0.000s) ok 815 - clean_if_exists: should not dump INSERT INTO test_table_identity
[14:07:01.708](0.000s) ok 816 - clean_if_exists: should not dump INSERT INTO test_third_table
[14:07:01.708](0.000s) ok 817 - clean_if_exists: should not dump INSERT INTO test_third_table (colnames)
[14:07:01.708](0.000s) ok 818 - clean_if_exists: should dump LO create (using lo_from_bytea)
[14:07:01.708](0.000s) ok 819 - clean_if_exists: should dump LO create (with no data)
[14:07:01.709](0.000s) ok 820 - clean_if_exists: should dump LO load (using lo_from_bytea)
[14:07:01.709](0.000s) ok 821 - clean_if_exists: should dump Partition measurement_y2006m2 creation
[14:07:01.709](0.000s) ok 822 - clean_if_exists: should dump REFRESH MATERIALIZED VIEW matview
[14:07:01.710](0.000s) ok 823 - clean_if_exists: should not dump REFRESH MATERIALIZED VIEW matview_fourth
[14:07:01.710](0.000s) ok 824 - clean_if_exists: should dump REFRESH MATERIALIZED VIEW matview_second
[14:07:01.710](0.000s) ok 825 - clean_if_exists: should not dump REFRESH MATERIALIZED VIEW matview_third
[14:07:01.710](0.000s) ok 826 - clean_if_exists: should dump REVOKE ALL ON SCHEMA public
[14:07:01.711](0.000s) ok 827 - clean_if_exists: should not dump REVOKE CONNECT ON DATABASE dump_test FROM public
[14:07:01.711](0.000s) ok 828 - clean_if_exists: should dump REVOKE EXECUTE ON FUNCTION pg_sleep() FROM public
[14:07:01.754](0.043s) ok 829 - clean_if_exists: should not dump REVOKE EXECUTE ON FUNCTION pg_stat_reset FROM regress_dump_test_role
[14:07:01.754](0.000s) ok 830 - clean_if_exists: should dump REVOKE SELECT ON TABLE pg_proc FROM public
[14:07:01.755](0.000s) ok 831 - clean_if_exists: should dump REVOKE USAGE ON LANGUAGE plpgsql FROM public
[14:07:01.755](0.000s) ok 832 - clean_if_exists: should dump Replica trigger on partition is altered
[14:07:01.755](0.000s) ok 833 - clean_if_exists: should not dump Triggers on partitions are not dropped
[14:07:01.756](0.000s) ok 834 - clean_if_exists: should dump extended_statistics_import
[14:07:01.756](0.001s) ok 835 - clean_if_exists: should not dump newline of table name in comment
[14:07:01.757](0.000s) ok 836 - clean_if_exists: should dump relstats_on_unanalyzed_tables
[14:07:01.757](0.000s) ok 837 - clean_if_exists: should dump restrict
[14:07:01.758](0.001s) ok 838 - clean_if_exists: should dump statistics_import
[14:07:01.759](0.000s) ok 839 - clean_if_exists: should not dump test_table with 4-row INSERTs
[14:07:01.759](0.000s) ok 840 - clean_if_exists: should dump unrestrict
# Running: pg_dump --no-sync --file C:\cirrus\build\testrun\pg_dump\002_pg_dump\data\tmp_test_9UIx/column_inserts.sql --data-only --column-inserts postgres
[14:07:02.175](0.416s) ok 841 - column_inserts: pg_dump runs
[14:07:02.178](0.003s) ok 842 - column_inserts: should not dump ALTER COLLATION test0 OWNER TO
[14:07:02.178](0.000s) ok 843 - column_inserts: should not dump ALTER DEFAULT PRIVILEGES FOR ROLE regress_dump_test_role GRANT
[14:07:02.179](0.000s) ok 844 - column_inserts: should not dump ALTER DEFAULT PRIVILEGES FOR ROLE regress_dump_test_role GRANT EXECUTE ON FUNCTIONS
[14:07:02.179](0.000s) ok 845 - column_inserts: should not dump ALTER DEFAULT PRIVILEGES FOR ROLE regress_dump_test_role REVOKE
[14:07:02.179](0.000s) ok 846 - column_inserts: should not dump ALTER DEFAULT PRIVILEGES FOR ROLE regress_dump_test_role REVOKE SELECT
[14:07:02.179](0.000s) ok 847 - column_inserts: should not dump ALTER FOREIGN DATA WRAPPER dummy OWNER TO
[14:07:02.180](0.000s) ok 848 - column_inserts: should not dump ALTER FOREIGN TABLE foreign_table ALTER COLUMN c1 OPTIONS
[14:07:02.180](0.000s) ok 849 - column_inserts: should not dump ALTER FOREIGN TABLE foreign_table OWNER TO
[14:07:02.180](0.000s) ok 850 - column_inserts: should not dump ALTER FUNCTION dump_test.pltestlang_call_handler() OWNER TO
[14:07:02.180](0.000s) ok 851 - column_inserts: should not dump ALTER INDEX ... ATTACH PARTITION
[14:07:02.180](0.000s) ok 852 - column_inserts: should not dump ALTER INDEX ... ATTACH PARTITION (primary key)
[14:07:02.181](0.000s) ok 853 - column_inserts: should dump ALTER LARGE OBJECT ... OWNER TO
[14:07:02.181](0.000s) ok 854 - column_inserts: should not dump ALTER OPERATOR CLASS dump_test.op_class OWNER TO
[14:07:02.181](0.000s) ok 855 - column_inserts: should not dump ALTER OPERATOR FAMILY dump_test.op_family OWNER TO
[14:07:02.182](0.000s) ok 856 - column_inserts: should not dump ALTER OPERATOR FAMILY dump_test.op_family USING btree
[14:07:02.182](0.000s) ok 857 - column_inserts: should not dump ALTER PROCEDURAL LANGUAGE pltestlang OWNER TO
[14:07:02.182](0.000s) ok 858 - column_inserts: should not dump ALTER PUBLICATION pub1 ADD TABLE test_second_table
[14:07:02.182](0.000s) ok 859 - column_inserts: should not dump ALTER PUBLICATION pub1 ADD TABLE test_seventh_table (col3, col2) WHERE (col1 = 1)
[14:07:02.182](0.000s) ok 860 - column_inserts: should not dump ALTER PUBLICATION pub1 ADD TABLE test_sixth_table (col3, col2)
[14:07:02.183](0.000s) ok 861 - column_inserts: should not dump ALTER PUBLICATION pub1 ADD TABLE test_table
[14:07:02.183](0.000s) ok 862 - column_inserts: should not dump ALTER PUBLICATION pub1 OWNER TO
[14:07:02.183](0.000s) ok 863 - column_inserts: should not dump ALTER PUBLICATION pub3 ADD TABLE test_table
[14:07:02.183](0.000s) ok 864 - column_inserts: should not dump ALTER PUBLICATION pub3 ADD TABLES IN SCHEMA dump_test
[14:07:02.183](0.000s) ok 865 - column_inserts: should not dump ALTER PUBLICATION pub3 ADD TABLES IN SCHEMA public
[14:07:02.184](0.000s) ok 866 - column_inserts: should not dump ALTER PUBLICATION pub4 ADD TABLE test_second_table WHERE (col2 = 'test');
[14:07:02.184](0.000s) ok 867 - column_inserts: should not dump ALTER PUBLICATION pub4 ADD TABLE test_table WHERE (col1 > 0);
[14:07:02.184](0.000s) ok 868 - column_inserts: should not dump ALTER ROLE regress_dump_test_role
[14:07:02.184](0.000s) ok 869 - column_inserts: should not dump ALTER SCHEMA dump_test OWNER TO
[14:07:02.184](0.000s) ok 870 - column_inserts: should not dump ALTER SCHEMA dump_test_second_schema OWNER TO
[14:07:02.185](0.000s) ok 871 - column_inserts: should not dump ALTER SCHEMA public OWNER TO
[14:07:02.185](0.000s) ok 872 - column_inserts: should not dump ALTER SEQUENCE test_table_col1_seq
[14:07:02.185](0.000s) ok 873 - column_inserts: should not dump ALTER SERVER s1 OWNER TO
[14:07:02.185](0.000s) ok 874 - column_inserts: should not dump ALTER STATISTICS extended_stats_options
[14:07:02.185](0.000s) ok 875 - column_inserts: should not dump ALTER TABLE (partitioned) ADD CONSTRAINT ... FOREIGN KEY
[14:07:02.186](0.000s) ok 876 - column_inserts: should not dump ALTER TABLE ONLY dump_test.measurement ATTACH PARTITION measurement_y2006m2
[14:07:02.186](0.000s) ok 877 - column_inserts: should not dump ALTER TABLE ONLY test_table ADD CONSTRAINT ... PRIMARY KEY
[14:07:02.186](0.000s) ok 878 - column_inserts: should not dump ALTER TABLE ONLY test_table ALTER COLUMN col1 SET STATISTICS 90
[14:07:02.186](0.000s) ok 879 - column_inserts: should not dump ALTER TABLE ONLY test_table ALTER COLUMN col2 SET STORAGE
[14:07:02.187](0.000s) ok 880 - column_inserts: should not dump ALTER TABLE ONLY test_table ALTER COLUMN col3 SET STORAGE
[14:07:02.187](0.000s) ok 881 - column_inserts: should not dump ALTER TABLE ONLY test_table ALTER COLUMN col4 SET n_distinct
[14:07:02.187](0.000s) ok 882 - column_inserts: should not dump ALTER TABLE measurement OWNER TO
[14:07:02.187](0.000s) ok 883 - column_inserts: should not dump ALTER TABLE measurement PRIMARY KEY
[14:07:02.187](0.000s) ok 884 - column_inserts: should not dump ALTER TABLE measurement_y2006m2 OWNER TO
[14:07:02.188](0.000s) ok 885 - column_inserts: should not dump ALTER TABLE test_second_table OWNER TO
[14:07:02.188](0.000s) ok 886 - column_inserts: should not dump ALTER TABLE test_table CLUSTER ON test_table_pkey
[14:07:02.188](0.000s) ok 887 - column_inserts: should not dump ALTER TABLE test_table DISABLE TRIGGER ALL
[14:07:02.188](0.000s) ok 888 - column_inserts: should not dump ALTER TABLE test_table ENABLE ROW LEVEL SECURITY
[14:07:02.188](0.000s) ok 889 - column_inserts: should not dump ALTER TABLE test_table OWNER TO
[14:07:02.189](0.000s) ok 890 - column_inserts: should not dump ALTER TABLE test_table_generated_child1
[14:07:02.189](0.000s) ok 891 - column_inserts: should not dump ALTER TEXT SEARCH CONFIGURATION alt_ts_conf1 OWNER TO
[14:07:02.189](0.000s) ok 892 - column_inserts: should not dump ALTER TEXT SEARCH CONFIGURATION dump_test.alt_ts_conf1 ...
[14:07:02.189](0.000s) ok 893 - column_inserts: should not dump ALTER TEXT SEARCH DICTIONARY alt_ts_dict1 OWNER TO
[14:07:02.189](0.000s) ok 894 - column_inserts: should not dump ALTER VIEW test_view SET DEFAULT
[14:07:02.190](0.000s) ok 895 - column_inserts: should not dump Always trigger on partition is altered
[14:07:02.190](0.000s) ok 896 - column_inserts: should not dump COMMENT ON COLLATION test0
[14:07:02.190](0.000s) ok 897 - column_inserts: should not dump COMMENT ON COLUMN dump_test.composite.f1
[14:07:02.190](0.000s) ok 898 - column_inserts: should not dump COMMENT ON COLUMN dump_test.test_second_table.col1
[14:07:02.190](0.000s) ok 899 - column_inserts: should not dump COMMENT ON COLUMN dump_test.test_second_table.col2
[14:07:02.191](0.000s) ok 900 - column_inserts: should not dump COMMENT ON COLUMN dump_test.test_table.col1
[14:07:02.191](0.000s) ok 901 - column_inserts: should not dump COMMENT ON CONSTRAINT ON DOMAIN (1)
[14:07:02.191](0.000s) ok 902 - column_inserts: should not dump COMMENT ON CONSTRAINT ON DOMAIN (2)
[14:07:02.191](0.000s) ok 903 - column_inserts: should not dump COMMENT ON CONSTRAINT ON test_table_chld2
[14:07:02.191](0.000s) ok 904 - column_inserts: should not dump COMMENT ON CONSTRAINT ON test_table_nn
[14:07:02.192](0.000s) ok 905 - column_inserts: should not dump COMMENT ON CONVERSION dump_test.test_conversion
[14:07:02.192](0.000s) ok 906 - column_inserts: should not dump COMMENT ON DATABASE postgres
[14:07:02.192](0.000s) ok 907 - column_inserts: should not dump COMMENT ON EXTENSION plpgsql
[14:07:02.192](0.000s) ok 908 - column_inserts: should dump COMMENT ON LARGE OBJECT ...
[14:07:02.192](0.000s) ok 909 - column_inserts: should not dump COMMENT ON POLICY p1
[14:07:02.193](0.000s) ok 910 - column_inserts: should not dump COMMENT ON PUBLICATION pub1
[14:07:02.193](0.000s) ok 911 - column_inserts: should not dump COMMENT ON SCHEMA public
[14:07:02.193](0.000s) ok 912 - column_inserts: should not dump COMMENT ON SUBSCRIPTION sub1
[14:07:02.193](0.000s) ok 913 - column_inserts: should not dump COMMENT ON TABLE dump_test.test_table
[14:07:02.193](0.000s) ok 914 - column_inserts: should not dump COMMENT ON TEXT SEARCH CONFIGURATION dump_test.alt_ts_conf1
[14:07:02.194](0.000s) ok 915 - column_inserts: should not dump COMMENT ON TEXT SEARCH DICTIONARY dump_test.alt_ts_dict1
[14:07:02.194](0.000s) ok 916 - column_inserts: should not dump COMMENT ON TEXT SEARCH PARSER dump_test.alt_ts_prs1
[14:07:02.194](0.000s) ok 917 - column_inserts: should not dump COMMENT ON TEXT SEARCH TEMPLATE dump_test.alt_ts_temp1
[14:07:02.194](0.000s) ok 918 - column_inserts: should not dump COMMENT ON TYPE dump_test.int42 - Regular
[14:07:02.194](0.000s) ok 919 - column_inserts: should not dump COMMENT ON TYPE dump_test.planets - ENUM
[14:07:02.195](0.000s) ok 920 - column_inserts: should not dump COMMENT ON TYPE dump_test.textrange - RANGE
[14:07:02.195](0.000s) ok 921 - column_inserts: should not dump COMMENT ON TYPE dump_test.undefined - Undefined
[14:07:02.195](0.000s) ok 922 - column_inserts: should not dump CONSTRAINT NOT NULL / NO INHERIT
[14:07:02.195](0.000s) ok 923 - column_inserts: should not dump CONSTRAINT NOT NULL / NO INHERIT (child1)
[14:07:02.196](0.000s) ok 924 - column_inserts: should not dump CONSTRAINT NOT NULL / NOT VALID
[14:07:02.196](0.000s) ok 925 - column_inserts: should not dump CONSTRAINT NOT NULL / NOT VALID (child1)
[14:07:02.196](0.000s) ok 926 - column_inserts: should not dump CONSTRAINT NOT NULL / NOT VALID (child2)
[14:07:02.196](0.000s) ok 927 - column_inserts: should not dump CONSTRAINT NOT NULL / NOT VALID (child3)
[14:07:02.196](0.000s) ok 928 - column_inserts: should not dump CONSTRAINT PRIMARY KEY / WITHOUT OVERLAPS
[14:07:02.197](0.000s) ok 929 - column_inserts: should not dump CONSTRAINT UNIQUE / WITHOUT OVERLAPS
[14:07:02.197](0.000s) ok 930 - column_inserts: should not dump COPY fk_reference_test_table
[14:07:02.197](0.000s) ok 931 - column_inserts: should not dump COPY fk_reference_test_table second
[14:07:02.197](0.000s) ok 932 - column_inserts: should not dump COPY measurement
[14:07:02.197](0.000s) ok 933 - column_inserts: should not dump COPY test_fifth_table
[14:07:02.198](0.000s) ok 934 - column_inserts: should not dump COPY test_fourth_table
[14:07:02.198](0.000s) ok 935 - column_inserts: should not dump COPY test_second_table
[14:07:02.198](0.000s) ok 936 - column_inserts: should not dump COPY test_table
[14:07:02.198](0.000s) ok 937 - column_inserts: should not dump COPY test_table_identity
[14:07:02.198](0.000s) ok 938 - column_inserts: should not dump COPY test_third_table
[14:07:02.199](0.000s) ok 939 - column_inserts: should not dump CREATE ACCESS METHOD gist2
[14:07:02.199](0.000s) ok 940 - column_inserts: should not dump CREATE ACCESS METHOD regress_test_table_am
[14:07:02.199](0.000s) ok 941 - column_inserts: should not dump CREATE AGGREGATE dump_test.newavg
[14:07:02.199](0.000s) ok 942 - column_inserts: should not dump CREATE CAST FOR timestamptz
[14:07:02.199](0.000s) ok 943 - column_inserts: should not dump CREATE COLLATION test0 FROM "C"
[14:07:02.200](0.000s) ok 944 - column_inserts: should not dump CREATE CONVERSION dump_test.test_conversion
[14:07:02.200](0.000s) ok 945 - column_inserts: should not dump CREATE DATABASE dump_test
[14:07:02.200](0.000s) ok 946 - column_inserts: should not dump CREATE DATABASE dump_test2 LOCALE = 'C'
[14:07:02.200](0.000s) ok 947 - column_inserts: should not dump CREATE DATABASE postgres
[14:07:02.201](0.000s) ok 948 - column_inserts: should not dump CREATE DATABASE regression_invalid...
[14:07:02.201](0.000s) ok 949 - column_inserts: should not dump CREATE DOMAIN dump_test.us_postal_code
[14:07:02.201](0.000s) ok 950 - column_inserts: should not dump CREATE EVENT TRIGGER test_event_trigger
[14:07:02.201](0.000s) ok 951 - column_inserts: should not dump CREATE EXTENSION ... plpgsql
[14:07:02.201](0.000s) ok 952 - column_inserts: should not dump CREATE FOREIGN DATA WRAPPER dummy
[14:07:02.201](0.000s) ok 953 - column_inserts: should not dump CREATE FOREIGN TABLE dump_test.foreign_table SERVER s1
[14:07:02.202](0.000s) ok 954 - column_inserts: should not dump CREATE FUNCTION ... SUPPORT
[14:07:02.202](0.000s) ok 955 - column_inserts: should not dump CREATE FUNCTION dump_test.event_trigger_func
[14:07:02.202](0.000s) ok 956 - column_inserts: should not dump CREATE FUNCTION dump_test.int42_in
[14:07:02.202](0.000s) ok 957 - column_inserts: should not dump CREATE FUNCTION dump_test.int42_out
[14:07:02.203](0.000s) ok 958 - column_inserts: should not dump CREATE FUNCTION dump_test.pltestlang_call_handler
[14:07:02.203](0.000s) ok 959 - column_inserts: should not dump CREATE FUNCTION dump_test.trigger_func
[14:07:02.203](0.000s) ok 960 - column_inserts: should not dump CREATE INDEX ... ON measurement_y2006_m2
[14:07:02.203](0.000s) ok 961 - column_inserts: should not dump CREATE INDEX ON ONLY measurement
[14:07:02.203](0.000s) ok 962 - column_inserts: should not dump CREATE LANGUAGE pltestlang
[14:07:02.204](0.000s) ok 963 - column_inserts: should not dump CREATE MATERIALIZED VIEW matview
[14:07:02.204](0.000s) ok 964 - column_inserts: should not dump CREATE MATERIALIZED VIEW matview_fourth
[14:07:02.204](0.000s) ok 965 - column_inserts: should not dump CREATE MATERIALIZED VIEW matview_second
[14:07:02.204](0.000s) ok 966 - column_inserts: should not dump CREATE MATERIALIZED VIEW matview_third
[14:07:02.204](0.000s) ok 967 - column_inserts: should not dump CREATE MATERIALIZED VIEW regress_pg_dump_matview_am
[14:07:02.205](0.000s) ok 968 - column_inserts: should not dump CREATE OPERATOR CLASS dump_test.op_class
[14:07:02.205](0.000s) ok 969 - column_inserts: should not dump CREATE OPERATOR CLASS dump_test.op_class_custom
[14:07:02.205](0.000s) ok 970 - column_inserts: should not dump CREATE OPERATOR CLASS dump_test.op_class_empty
[14:07:02.205](0.000s) ok 971 - column_inserts: should not dump CREATE OPERATOR FAMILY dump_test.op_family
[14:07:02.205](0.000s) ok 972 - column_inserts: should not dump CREATE POLICY p1 ON test_table
[14:07:02.206](0.000s) ok 973 - column_inserts: should not dump CREATE POLICY p2 ON test_table FOR SELECT
[14:07:02.206](0.000s) ok 974 - column_inserts: should not dump CREATE POLICY p3 ON test_table FOR INSERT
[14:07:02.206](0.000s) ok 975 - column_inserts: should not dump CREATE POLICY p4 ON test_table FOR UPDATE
[14:07:02.206](0.000s) ok 976 - column_inserts: should not dump CREATE POLICY p5 ON test_table FOR DELETE
[14:07:02.207](0.000s) ok 977 - column_inserts: should not dump CREATE POLICY p6 ON test_table AS RESTRICTIVE
[14:07:02.207](0.000s) ok 978 - column_inserts: should not dump CREATE PROCEDURE dump_test.ptest1
[14:07:02.207](0.000s) ok 979 - column_inserts: should not dump CREATE PROPERTY GRAPH propgraph
[14:07:02.207](0.000s) ok 980 - column_inserts: should not dump CREATE PUBLICATION pub1
[14:07:02.207](0.000s) ok 981 - column_inserts: should not dump CREATE PUBLICATION pub10
[14:07:02.208](0.000s) ok 982 - column_inserts: should not dump CREATE PUBLICATION pub2
[14:07:02.208](0.000s) ok 983 - column_inserts: should not dump CREATE PUBLICATION pub3
[14:07:02.208](0.000s) ok 984 - column_inserts: should not dump CREATE PUBLICATION pub4
[14:07:02.208](0.000s) ok 985 - column_inserts: should not dump CREATE PUBLICATION pub5
[14:07:02.208](0.000s) ok 986 - column_inserts: should not dump CREATE PUBLICATION pub6
[14:07:02.209](0.000s) ok 987 - column_inserts: should not dump CREATE PUBLICATION pub7
[14:07:02.209](0.000s) ok 988 - column_inserts: should not dump CREATE PUBLICATION pub8
[14:07:02.209](0.000s) ok 989 - column_inserts: should not dump CREATE PUBLICATION pub9
[14:07:02.209](0.000s) ok 990 - column_inserts: should not dump CREATE ROLE regress_dump_test_role
[14:07:02.210](0.000s) ok 991 - column_inserts: should not dump CREATE ROLE regress_quoted...
[14:07:02.210](0.000s) ok 992 - column_inserts: should not dump CREATE SCHEMA dump_test
[14:07:02.210](0.000s) ok 993 - column_inserts: should not dump CREATE SCHEMA dump_test_second_schema
[14:07:02.210](0.000s) ok 994 - column_inserts: should not dump CREATE SCHEMA public
[14:07:02.210](0.000s) ok 995 - column_inserts: should not dump CREATE SEQUENCE test_table_col1_seq
[14:07:02.211](0.000s) ok 996 - column_inserts: should not dump CREATE SERVER s1 FOREIGN DATA WRAPPER dummy
[14:07:02.211](0.000s) ok 997 - column_inserts: should not dump CREATE STATISTICS extended_stats_expression
[14:07:02.211](0.000s) ok 998 - column_inserts: should not dump CREATE STATISTICS extended_stats_no_options
[14:07:02.211](0.000s) ok 999 - column_inserts: should not dump CREATE STATISTICS extended_stats_options
[14:07:02.211](0.000s) ok 1000 - column_inserts: should not dump CREATE SUBSCRIPTION sub1
[14:07:02.212](0.000s) ok 1001 - column_inserts: should not dump CREATE SUBSCRIPTION sub2
[14:07:02.212](0.000s) ok 1002 - column_inserts: should not dump CREATE SUBSCRIPTION sub3
[14:07:02.212](0.000s) ok 1003 - column_inserts: should not dump CREATE TABLE fk_reference_test_table
[14:07:02.212](0.000s) ok 1004 - column_inserts: should not dump CREATE TABLE measurement PARTITIONED BY
[14:07:02.212](0.000s) ok 1005 - column_inserts: should not dump CREATE TABLE regress_pg_dump_table_am
[14:07:02.213](0.000s) ok 1006 - column_inserts: should not dump CREATE TABLE regress_pg_dump_table_part
[14:07:02.213](0.000s) ok 1007 - column_inserts: should not dump CREATE TABLE table_with_stats
[14:07:02.213](0.000s) ok 1008 - column_inserts: should not dump CREATE TABLE test_fifth_table
[14:07:02.213](0.000s) ok 1009 - column_inserts: should not dump CREATE TABLE test_fourth_table_zero_col
[14:07:02.213](0.000s) ok 1010 - column_inserts: should not dump CREATE TABLE test_inheritance_child
[14:07:02.214](0.000s) ok 1011 - column_inserts: should not dump CREATE TABLE test_inheritance_parent
[14:07:02.214](0.000s) ok 1012 - column_inserts: should not dump CREATE TABLE test_second_table
[14:07:02.214](0.000s) ok 1013 - column_inserts: should not dump CREATE TABLE test_seventh_table
[14:07:02.214](0.000s) ok 1014 - column_inserts: should not dump CREATE TABLE test_sixth_table
[14:07:02.214](0.000s) ok 1015 - column_inserts: should not dump CREATE TABLE test_table
[14:07:02.215](0.000s) ok 1016 - column_inserts: should not dump CREATE TABLE test_table_generated
[14:07:02.215](0.000s) ok 1017 - column_inserts: should not dump CREATE TABLE test_table_generated_child1 (without local columns)
[14:07:02.215](0.000s) ok 1018 - column_inserts: should not dump CREATE TABLE test_table_generated_child2 (with local columns)
[14:07:02.215](0.000s) ok 1019 - column_inserts: should not dump CREATE TABLE test_table_identity
[14:07:02.216](0.000s) ok 1020 - column_inserts: should not dump CREATE TABLE test_third_table_generated_cols
[14:07:02.216](0.000s) ok 1021 - column_inserts: should not dump CREATE TABLESPACE regress_dump_tablespace
[14:07:02.216](0.000s) ok 1022 - column_inserts: should not dump CREATE TEXT SEARCH CONFIGURATION dump_test.alt_ts_conf1
[14:07:02.216](0.000s) ok 1023 - column_inserts: should not dump CREATE TEXT SEARCH DICTIONARY dump_test.alt_ts_dict1
[14:07:02.216](0.000s) ok 1024 - column_inserts: should not dump CREATE TEXT SEARCH PARSER dump_test.alt_ts_prs1
[14:07:02.217](0.000s) ok 1025 - column_inserts: should not dump CREATE TEXT SEARCH TEMPLATE dump_test.alt_ts_temp1
[14:07:02.217](0.000s) ok 1026 - column_inserts: should not dump CREATE TRANSFORM FOR int
[14:07:02.217](0.000s) ok 1027 - column_inserts: should not dump CREATE TRIGGER test_trigger
[14:07:02.217](0.000s) ok 1028 - column_inserts: should not dump CREATE TYPE dump_test.composite
[14:07:02.217](0.000s) ok 1029 - column_inserts: should not dump CREATE TYPE dump_test.int42
[14:07:02.218](0.000s) ok 1030 - column_inserts: should not dump CREATE TYPE dump_test.int42 populated
[14:07:02.218](0.000s) ok 1031 - column_inserts: should not dump CREATE TYPE dump_test.planets AS ENUM
[14:07:02.218](0.000s) ok 1032 - column_inserts: should not dump CREATE TYPE dump_test.planets AS ENUM pg_upgrade
[14:07:02.218](0.000s) ok 1033 - column_inserts: should not dump CREATE TYPE dump_test.textrange AS RANGE
[14:07:02.218](0.000s) ok 1034 - column_inserts: should not dump CREATE TYPE dump_test.undefined
[14:07:02.219](0.000s) ok 1035 - column_inserts: should not dump CREATE USER MAPPING FOR regress_dump_test_role SERVER s1
[14:07:02.219](0.000s) ok 1036 - column_inserts: should not dump CREATE VIEW test_view
[14:07:02.219](0.000s) ok 1037 - column_inserts: should not dump Check ordering of a function that depends on a primary key
[14:07:02.219](0.000s) ok 1038 - column_inserts: should not dump Check ordering of a matview that depends on a primary key
[14:07:02.219](0.000s) ok 1039 - column_inserts: should not dump Creation of row-level trigger in partitioned table
[14:07:02.220](0.000s) ok 1040 - column_inserts: should not dump DROP EXTENSION IF EXISTS plpgsql
[14:07:02.220](0.000s) ok 1041 - column_inserts: should not dump DROP EXTENSION plpgsql
[14:07:02.220](0.000s) ok 1042 - column_inserts: should not dump DROP FUNCTION IF EXISTS dump_test.pltestlang_call_handler()
[14:07:02.220](0.000s) ok 1043 - column_inserts: should not dump DROP FUNCTION dump_test.pltestlang_call_handler()
[14:07:02.220](0.000s) ok 1044 - column_inserts: should not dump DROP LANGUAGE IF EXISTS pltestlang
[14:07:02.221](0.000s) ok 1045 - column_inserts: should not dump DROP LANGUAGE pltestlang
[14:07:02.221](0.000s) ok 1046 - column_inserts: should not dump DROP ROLE pg_
[14:07:02.221](0.000s) ok 1047 - column_inserts: should not dump DROP ROLE regress_dump_test_role
[14:07:02.221](0.000s) ok 1048 - column_inserts: should not dump DROP SCHEMA IF EXISTS dump_test
[14:07:02.222](0.000s) ok 1049 - column_inserts: should not dump DROP SCHEMA IF EXISTS dump_test_second_schema
[14:07:02.222](0.000s) ok 1050 - column_inserts: should not dump DROP SCHEMA IF EXISTS public
[14:07:02.222](0.000s) ok 1051 - column_inserts: should not dump DROP SCHEMA dump_test
[14:07:02.222](0.000s) ok 1052 - column_inserts: should not dump DROP SCHEMA dump_test_second_schema
[14:07:02.222](0.000s) ok 1053 - column_inserts: should not dump DROP SCHEMA public
[14:07:02.223](0.000s) ok 1054 - column_inserts: should not dump DROP TABLE IF EXISTS test_second_table
[14:07:02.223](0.000s) ok 1055 - column_inserts: should not dump DROP TABLE IF EXISTS test_table
[14:07:02.223](0.000s) ok 1056 - column_inserts: should not dump DROP TABLE fk_reference_test_table
[14:07:02.223](0.000s) ok 1057 - column_inserts: should not dump DROP TABLE test_second_table
[14:07:02.223](0.000s) ok 1058 - column_inserts: should not dump DROP TABLE test_table
[14:07:02.224](0.000s) ok 1059 - column_inserts: should not dump Disabled trigger on partition is altered
[14:07:02.224](0.000s) ok 1060 - column_inserts: should not dump Disabled trigger on partition is not created
[14:07:02.224](0.000s) ok 1061 - column_inserts: should dump GRANT ALL ON LARGE OBJECT ...
[14:07:02.224](0.000s) ok 1062 - column_inserts: should not dump GRANT CREATE ON DATABASE dump_test
[14:07:02.224](0.000s) ok 1063 - column_inserts: should not dump GRANT EXECUTE ON FUNCTION pg_sleep() TO regress_dump_test_role
[14:07:02.225](0.000s) ok 1064 - column_inserts: should not dump GRANT INSERT(col1) ON TABLE test_second_table
[14:07:02.225](0.000s) ok 1065 - column_inserts: should not dump GRANT SELECT (proname ...) ON TABLE pg_proc TO public
[14:07:02.225](0.000s) ok 1066 - column_inserts: should not dump GRANT SELECT ON PROPERTY GRAPH propgraph
[14:07:02.225](0.000s) ok 1067 - column_inserts: should not dump GRANT SELECT ON TABLE measurement
[14:07:02.226](0.000s) ok 1068 - column_inserts: should not dump GRANT SELECT ON TABLE measurement_y2006m2
[14:07:02.226](0.000s) ok 1069 - column_inserts: should not dump GRANT SELECT ON TABLE test_table
[14:07:02.226](0.000s) ok 1070 - column_inserts: should not dump GRANT USAGE ON DOMAIN dump_test.us_postal_code
[14:07:02.226](0.000s) ok 1071 - column_inserts: should not dump GRANT USAGE ON FOREIGN DATA WRAPPER dummy
[14:07:02.226](0.000s) ok 1072 - column_inserts: should not dump GRANT USAGE ON FOREIGN SERVER s1
[14:07:02.227](0.000s) ok 1073 - column_inserts: should not dump GRANT USAGE ON SCHEMA dump_test_second_schema
[14:07:02.227](0.000s) ok 1074 - column_inserts: should not dump GRANT USAGE ON SCHEMA public TO public
[14:07:02.227](0.000s) ok 1075 - column_inserts: should not dump GRANT USAGE ON TYPE dump_test.int42
[14:07:02.227](0.000s) ok 1076 - column_inserts: should not dump GRANT USAGE ON TYPE dump_test.planets - ENUM
[14:07:02.227](0.000s) ok 1077 - column_inserts: should not dump GRANT USAGE ON TYPE dump_test.textrange - RANGE
[14:07:02.228](0.000s) ok 1078 - column_inserts: should dump INSERT INTO test_fifth_table
[14:07:02.228](0.000s) ok 1079 - column_inserts: should dump INSERT INTO test_fourth_table
[14:07:02.228](0.000s) ok 1080 - column_inserts: should dump INSERT INTO test_second_table
[14:07:02.228](0.000s) ok 1081 - column_inserts: should dump INSERT INTO test_table
[14:07:02.228](0.000s) ok 1082 - column_inserts: should dump INSERT INTO test_table_identity
[14:07:02.229](0.000s) ok 1083 - column_inserts: should not dump INSERT INTO test_third_table
[14:07:02.229](0.000s) ok 1084 - column_inserts: should dump INSERT INTO test_third_table (colnames)
[14:07:02.229](0.000s) ok 1085 - column_inserts: should dump LO create (using lo_from_bytea)
[14:07:02.229](0.000s) ok 1086 - column_inserts: should dump LO create (with no data)
[14:07:02.229](0.000s) ok 1087 - column_inserts: should dump LO load (using lo_from_bytea)
[14:07:02.230](0.000s) ok 1088 - column_inserts: should not dump Partition measurement_y2006m2 creation
[14:07:02.230](0.000s) ok 1089 - column_inserts: should not dump REFRESH MATERIALIZED VIEW matview
[14:07:02.230](0.000s) ok 1090 - column_inserts: should not dump REFRESH MATERIALIZED VIEW matview_fourth
[14:07:02.230](0.000s) ok 1091 - column_inserts: should not dump REFRESH MATERIALIZED VIEW matview_second
[14:07:02.230](0.000s) ok 1092 - column_inserts: should not dump REFRESH MATERIALIZED VIEW matview_third
[14:07:02.230](0.000s) ok 1093 - column_inserts: should not dump REVOKE ALL ON SCHEMA public
[14:07:02.231](0.000s) ok 1094 - column_inserts: should not dump REVOKE CONNECT ON DATABASE dump_test FROM public
[14:07:02.231](0.000s) ok 1095 - column_inserts: should not dump REVOKE EXECUTE ON FUNCTION pg_sleep() FROM public
[14:07:02.233](0.002s) ok 1096 - column_inserts: should not dump REVOKE EXECUTE ON FUNCTION pg_stat_reset FROM regress_dump_test_role
[14:07:02.233](0.000s) ok 1097 - column_inserts: should not dump REVOKE SELECT ON TABLE pg_proc FROM public
[14:07:02.233](0.000s) ok 1098 - column_inserts: should not dump REVOKE USAGE ON LANGUAGE plpgsql FROM public
[14:07:02.234](0.000s) ok 1099 - column_inserts: should not dump Replica trigger on partition is altered
[14:07:02.234](0.000s) ok 1100 - column_inserts: should not dump Triggers on partitions are not dropped
[14:07:02.234](0.000s) ok 1101 - column_inserts: should not dump extended_statistics_import
[14:07:02.234](0.000s) ok 1102 - column_inserts: should not dump newline of table name in comment
[14:07:02.234](0.000s) ok 1103 - column_inserts: should not dump relstats_on_unanalyzed_tables
[14:07:02.235](0.000s) ok 1104 - column_inserts: should dump restrict
[14:07:02.235](0.000s) ok 1105 - column_inserts: should not dump statistics_import
[14:07:02.235](0.000s) ok 1106 - column_inserts: should not dump test_table with 4-row INSERTs
[14:07:02.235](0.000s) ok 1107 - column_inserts: should dump unrestrict
# Running: pg_dump --no-sync --file C:\cirrus\build\testrun\pg_dump\002_pg_dump\data\tmp_test_9UIx/createdb.sql --create --no-reconnect --verbose --statistics postgres
[14:07:05.225](2.990s) ok 1108 - createdb: pg_dump runs
[14:07:05.228](0.003s) ok 1109 - createdb: should dump ALTER COLLATION test0 OWNER TO
[14:07:05.229](0.001s) ok 1110 - createdb: should dump ALTER DEFAULT PRIVILEGES FOR ROLE regress_dump_test_role GRANT
[14:07:05.229](0.000s) ok 1111 - createdb: should dump ALTER DEFAULT PRIVILEGES FOR ROLE regress_dump_test_role GRANT EXECUTE ON FUNCTIONS
[14:07:05.229](0.000s) ok 1112 - createdb: should dump ALTER DEFAULT PRIVILEGES FOR ROLE regress_dump_test_role REVOKE
[14:07:05.229](0.000s) ok 1113 - createdb: should dump ALTER DEFAULT PRIVILEGES FOR ROLE regress_dump_test_role REVOKE SELECT
[14:07:05.230](0.000s) ok 1114 - createdb: should dump ALTER FOREIGN DATA WRAPPER dummy OWNER TO
[14:07:05.230](0.000s) ok 1115 - createdb: should dump ALTER FOREIGN TABLE foreign_table ALTER COLUMN c1 OPTIONS
[14:07:05.230](0.000s) ok 1116 - createdb: should dump ALTER FOREIGN TABLE foreign_table OWNER TO
[14:07:05.230](0.000s) ok 1117 - createdb: should dump ALTER FUNCTION dump_test.pltestlang_call_handler() OWNER TO
[14:07:05.231](0.000s) ok 1118 - createdb: should dump ALTER INDEX ... ATTACH PARTITION
[14:07:05.231](0.000s) ok 1119 - createdb: should dump ALTER INDEX ... ATTACH PARTITION (primary key)
[14:07:05.231](0.000s) ok 1120 - createdb: should dump ALTER LARGE OBJECT ... OWNER TO
[14:07:05.231](0.000s) ok 1121 - createdb: should dump ALTER OPERATOR CLASS dump_test.op_class OWNER TO
[14:07:05.231](0.000s) ok 1122 - createdb: should dump ALTER OPERATOR FAMILY dump_test.op_family OWNER TO
[14:07:05.232](0.000s) ok 1123 - createdb: should dump ALTER OPERATOR FAMILY dump_test.op_family USING btree
[14:07:05.232](0.000s) ok 1124 - createdb: should dump ALTER PROCEDURAL LANGUAGE pltestlang OWNER TO
[14:07:05.232](0.000s) ok 1125 - createdb: should dump ALTER PUBLICATION pub1 ADD TABLE test_second_table
[14:07:05.232](0.000s) ok 1126 - createdb: should dump ALTER PUBLICATION pub1 ADD TABLE test_seventh_table (col3, col2) WHERE (col1 = 1)
[14:07:05.232](0.000s) ok 1127 - createdb: should dump ALTER PUBLICATION pub1 ADD TABLE test_sixth_table (col3, col2)
[14:07:05.233](0.000s) ok 1128 - createdb: should dump ALTER PUBLICATION pub1 ADD TABLE test_table
[14:07:05.233](0.000s) ok 1129 - createdb: should dump ALTER PUBLICATION pub1 OWNER TO
[14:07:05.233](0.000s) ok 1130 - createdb: should dump ALTER PUBLICATION pub3 ADD TABLE test_table
[14:07:05.234](0.000s) ok 1131 - createdb: should dump ALTER PUBLICATION pub3 ADD TABLES IN SCHEMA dump_test
[14:07:05.234](0.000s) ok 1132 - createdb: should dump ALTER PUBLICATION pub3 ADD TABLES IN SCHEMA public
[14:07:05.234](0.000s) ok 1133 - createdb: should dump ALTER PUBLICATION pub4 ADD TABLE test_second_table WHERE (col2 = 'test');
[14:07:05.235](0.000s) ok 1134 - createdb: should dump ALTER PUBLICATION pub4 ADD TABLE test_table WHERE (col1 > 0);
[14:07:05.235](0.000s) ok 1135 - createdb: should not dump ALTER ROLE regress_dump_test_role
[14:07:05.236](0.000s) ok 1136 - createdb: should dump ALTER SCHEMA dump_test OWNER TO
[14:07:05.236](0.000s) ok 1137 - createdb: should dump ALTER SCHEMA dump_test_second_schema OWNER TO
[14:07:05.236](0.000s) ok 1138 - createdb: should dump ALTER SCHEMA public OWNER TO
[14:07:05.236](0.000s) ok 1139 - createdb: should dump ALTER SEQUENCE test_table_col1_seq
[14:07:05.237](0.000s) ok 1140 - createdb: should dump ALTER SERVER s1 OWNER TO
[14:07:05.237](0.000s) ok 1141 - createdb: should dump ALTER STATISTICS extended_stats_options
[14:07:05.237](0.000s) ok 1142 - createdb: should dump ALTER TABLE (partitioned) ADD CONSTRAINT ... FOREIGN KEY
[14:07:05.237](0.000s) ok 1143 - createdb: should dump ALTER TABLE ONLY dump_test.measurement ATTACH PARTITION measurement_y2006m2
[14:07:05.237](0.000s) ok 1144 - createdb: should dump ALTER TABLE ONLY test_table ADD CONSTRAINT ... PRIMARY KEY
[14:07:05.238](0.000s) ok 1145 - createdb: should dump ALTER TABLE ONLY test_table ALTER COLUMN col1 SET STATISTICS 90
[14:07:05.238](0.000s) ok 1146 - createdb: should dump ALTER TABLE ONLY test_table ALTER COLUMN col2 SET STORAGE
[14:07:05.238](0.000s) ok 1147 - createdb: should dump ALTER TABLE ONLY test_table ALTER COLUMN col3 SET STORAGE
[14:07:05.238](0.000s) ok 1148 - createdb: should dump ALTER TABLE ONLY test_table ALTER COLUMN col4 SET n_distinct
[14:07:05.238](0.000s) ok 1149 - createdb: should dump ALTER TABLE measurement OWNER TO
[14:07:05.239](0.000s) ok 1150 - createdb: should dump ALTER TABLE measurement PRIMARY KEY
[14:07:05.239](0.000s) ok 1151 - createdb: should dump ALTER TABLE measurement_y2006m2 OWNER TO
[14:07:05.239](0.000s) ok 1152 - createdb: should dump ALTER TABLE test_second_table OWNER TO
[14:07:05.239](0.000s) ok 1153 - createdb: should dump ALTER TABLE test_table CLUSTER ON test_table_pkey
[14:07:05.239](0.000s) ok 1154 - createdb: should not dump ALTER TABLE test_table DISABLE TRIGGER ALL
[14:07:05.240](0.000s) ok 1155 - createdb: should dump ALTER TABLE test_table ENABLE ROW LEVEL SECURITY
[14:07:05.240](0.000s) ok 1156 - createdb: should dump ALTER TABLE test_table OWNER TO
[14:07:05.240](0.000s) ok 1157 - createdb: should not dump ALTER TABLE test_table_generated_child1
[14:07:05.240](0.000s) ok 1158 - createdb: should dump ALTER TEXT SEARCH CONFIGURATION alt_ts_conf1 OWNER TO
[14:07:05.241](0.000s) ok 1159 - createdb: should dump ALTER TEXT SEARCH CONFIGURATION dump_test.alt_ts_conf1 ...
[14:07:05.241](0.000s) ok 1160 - createdb: should dump ALTER TEXT SEARCH DICTIONARY alt_ts_dict1 OWNER TO
[14:07:05.241](0.000s) ok 1161 - createdb: should dump ALTER VIEW test_view SET DEFAULT
[14:07:05.242](0.000s) ok 1162 - createdb: should dump Always trigger on partition is altered
[14:07:05.242](0.000s) ok 1163 - createdb: should dump COMMENT ON COLLATION test0
[14:07:05.242](0.000s) ok 1164 - createdb: should dump COMMENT ON COLUMN dump_test.composite.f1
[14:07:05.242](0.000s) ok 1165 - createdb: should dump COMMENT ON COLUMN dump_test.test_second_table.col1
[14:07:05.242](0.000s) ok 1166 - createdb: should dump COMMENT ON COLUMN dump_test.test_second_table.col2
[14:07:05.243](0.000s) ok 1167 - createdb: should dump COMMENT ON COLUMN dump_test.test_table.col1
[14:07:05.243](0.000s) ok 1168 - createdb: should dump COMMENT ON CONSTRAINT ON DOMAIN (1)
[14:07:05.243](0.000s) ok 1169 - createdb: should dump COMMENT ON CONSTRAINT ON DOMAIN (2)
[14:07:05.243](0.000s) ok 1170 - createdb: should dump COMMENT ON CONSTRAINT ON test_table_chld2
[14:07:05.243](0.000s) ok 1171 - createdb: should dump COMMENT ON CONSTRAINT ON test_table_nn
[14:07:05.244](0.000s) ok 1172 - createdb: should dump COMMENT ON CONVERSION dump_test.test_conversion
[14:07:05.244](0.000s) ok 1173 - createdb: should dump COMMENT ON DATABASE postgres
[14:07:05.244](0.000s) ok 1174 - createdb: should not dump COMMENT ON EXTENSION plpgsql
[14:07:05.244](0.000s) ok 1175 - createdb: should dump COMMENT ON LARGE OBJECT ...
[14:07:05.245](0.000s) ok 1176 - createdb: should dump COMMENT ON POLICY p1
[14:07:05.245](0.000s) ok 1177 - createdb: should dump COMMENT ON PUBLICATION pub1
[14:07:05.245](0.000s) ok 1178 - createdb: should not dump COMMENT ON SCHEMA public
[14:07:05.245](0.000s) ok 1179 - createdb: should dump COMMENT ON SUBSCRIPTION sub1
[14:07:05.246](0.000s) ok 1180 - createdb: should dump COMMENT ON TABLE dump_test.test_table
[14:07:05.246](0.000s) ok 1181 - createdb: should dump COMMENT ON TEXT SEARCH CONFIGURATION dump_test.alt_ts_conf1
[14:07:05.246](0.000s) ok 1182 - createdb: should dump COMMENT ON TEXT SEARCH DICTIONARY dump_test.alt_ts_dict1
[14:07:05.246](0.000s) ok 1183 - createdb: should dump COMMENT ON TEXT SEARCH PARSER dump_test.alt_ts_prs1
[14:07:05.246](0.000s) ok 1184 - createdb: should dump COMMENT ON TEXT SEARCH TEMPLATE dump_test.alt_ts_temp1
[14:07:05.246](0.000s) ok 1185 - createdb: should dump COMMENT ON TYPE dump_test.int42 - Regular
[14:07:05.247](0.000s) ok 1186 - createdb: should dump COMMENT ON TYPE dump_test.planets - ENUM
[14:07:05.247](0.000s) ok 1187 - createdb: should dump COMMENT ON TYPE dump_test.textrange - RANGE
[14:07:05.247](0.000s) ok 1188 - createdb: should dump COMMENT ON TYPE dump_test.undefined - Undefined
[14:07:05.247](0.000s) ok 1189 - createdb: should dump CONSTRAINT NOT NULL / NO INHERIT
[14:07:05.247](0.000s) ok 1190 - createdb: should dump CONSTRAINT NOT NULL / NO INHERIT (child1)
[14:07:05.248](0.000s) ok 1191 - createdb: should dump CONSTRAINT NOT NULL / NOT VALID
[14:07:05.248](0.000s) ok 1192 - createdb: should dump CONSTRAINT NOT NULL / NOT VALID (child1)
[14:07:05.248](0.000s) ok 1193 - createdb: should dump CONSTRAINT NOT NULL / NOT VALID (child2)
[14:07:05.248](0.000s) ok 1194 - createdb: should dump CONSTRAINT NOT NULL / NOT VALID (child3)
[14:07:05.249](0.000s) ok 1195 - createdb: should dump CONSTRAINT PRIMARY KEY / WITHOUT OVERLAPS
[14:07:05.249](0.001s) ok 1196 - createdb: should dump CONSTRAINT UNIQUE / WITHOUT OVERLAPS
[14:07:05.249](0.000s) ok 1197 - createdb: should dump COPY fk_reference_test_table
[14:07:05.250](0.000s) ok 1198 - createdb: should not dump COPY fk_reference_test_table second
[14:07:05.250](0.000s) ok 1199 - createdb: should dump COPY measurement
[14:07:05.250](0.000s) ok 1200 - createdb: should dump COPY test_fifth_table
[14:07:05.250](0.000s) ok 1201 - createdb: should dump COPY test_fourth_table
[14:07:05.250](0.000s) ok 1202 - createdb: should dump COPY test_second_table
[14:07:05.251](0.000s) ok 1203 - createdb: should dump COPY test_table
[14:07:05.251](0.000s) ok 1204 - createdb: should dump COPY test_table_identity
[14:07:05.251](0.000s) ok 1205 - createdb: should dump COPY test_third_table
[14:07:05.251](0.000s) ok 1206 - createdb: should dump CREATE ACCESS METHOD gist2
[14:07:05.251](0.000s) ok 1207 - createdb: should dump CREATE ACCESS METHOD regress_test_table_am
[14:07:05.252](0.000s) ok 1208 - createdb: should dump CREATE AGGREGATE dump_test.newavg
[14:07:05.252](0.000s) ok 1209 - createdb: should dump CREATE CAST FOR timestamptz
[14:07:05.252](0.000s) ok 1210 - createdb: should dump CREATE COLLATION test0 FROM "C"
[14:07:05.252](0.000s) ok 1211 - createdb: should dump CREATE CONVERSION dump_test.test_conversion
[14:07:05.252](0.000s) ok 1212 - createdb: should not dump CREATE DATABASE dump_test
[14:07:05.253](0.000s) ok 1213 - createdb: should not dump CREATE DATABASE dump_test2 LOCALE = 'C'
[14:07:05.253](0.000s) ok 1214 - createdb: should dump CREATE DATABASE postgres
[14:07:05.253](0.000s) ok 1215 - createdb: should not dump CREATE DATABASE regression_invalid...
[14:07:05.256](0.003s) ok 1216 - createdb: should dump CREATE DOMAIN dump_test.us_postal_code
[14:07:05.256](0.000s) ok 1217 - createdb: should dump CREATE EVENT TRIGGER test_event_trigger
[14:07:05.256](0.000s) ok 1218 - createdb: should not dump CREATE EXTENSION ... plpgsql
[14:07:05.256](0.000s) ok 1219 - createdb: should dump CREATE FOREIGN DATA WRAPPER dummy
[14:07:05.257](0.000s) ok 1220 - createdb: should dump CREATE FOREIGN TABLE dump_test.foreign_table SERVER s1
[14:07:05.257](0.000s) ok 1221 - createdb: should dump CREATE FUNCTION ... SUPPORT
[14:07:05.257](0.000s) ok 1222 - createdb: should dump CREATE FUNCTION dump_test.event_trigger_func
[14:07:05.257](0.000s) ok 1223 - createdb: should dump CREATE FUNCTION dump_test.int42_in
[14:07:05.257](0.000s) ok 1224 - createdb: should dump CREATE FUNCTION dump_test.int42_out
[14:07:05.258](0.000s) ok 1225 - createdb: should dump CREATE FUNCTION dump_test.pltestlang_call_handler
[14:07:05.258](0.000s) ok 1226 - createdb: should dump CREATE FUNCTION dump_test.trigger_func
[14:07:05.258](0.000s) ok 1227 - createdb: should dump CREATE INDEX ... ON measurement_y2006_m2
[14:07:05.258](0.000s) ok 1228 - createdb: should dump CREATE INDEX ON ONLY measurement
[14:07:05.258](0.000s) ok 1229 - createdb: should dump CREATE LANGUAGE pltestlang
[14:07:05.259](0.000s) ok 1230 - createdb: should dump CREATE MATERIALIZED VIEW matview
[14:07:05.259](0.000s) ok 1231 - createdb: should dump CREATE MATERIALIZED VIEW matview_fourth
[14:07:05.259](0.000s) ok 1232 - createdb: should dump CREATE MATERIALIZED VIEW matview_second
[14:07:05.259](0.000s) ok 1233 - createdb: should dump CREATE MATERIALIZED VIEW matview_third
[14:07:05.259](0.000s) ok 1234 - createdb: should dump CREATE MATERIALIZED VIEW regress_pg_dump_matview_am
[14:07:05.260](0.000s) ok 1235 - createdb: should dump CREATE OPERATOR CLASS dump_test.op_class
[14:07:05.262](0.002s) ok 1236 - createdb: should dump CREATE OPERATOR CLASS dump_test.op_class_custom
[14:07:05.263](0.001s) ok 1237 - createdb: should dump CREATE OPERATOR CLASS dump_test.op_class_empty
[14:07:05.263](0.000s) ok 1238 - createdb: should dump CREATE OPERATOR FAMILY dump_test.op_family
[14:07:05.263](0.000s) ok 1239 - createdb: should dump CREATE POLICY p1 ON test_table
[14:07:05.264](0.000s) ok 1240 - createdb: should dump CREATE POLICY p2 ON test_table FOR SELECT
[14:07:05.264](0.000s) ok 1241 - createdb: should dump CREATE POLICY p3 ON test_table FOR INSERT
[14:07:05.264](0.000s) ok 1242 - createdb: should dump CREATE POLICY p4 ON test_table FOR UPDATE
[14:07:05.264](0.000s) ok 1243 - createdb: should dump CREATE POLICY p5 ON test_table FOR DELETE
[14:07:05.265](0.000s) ok 1244 - createdb: should dump CREATE POLICY p6 ON test_table AS RESTRICTIVE
[14:07:05.265](0.000s) ok 1245 - createdb: should dump CREATE PROCEDURE dump_test.ptest1
[14:07:05.265](0.000s) ok 1246 - createdb: should dump CREATE PROPERTY GRAPH propgraph
[14:07:05.265](0.000s) ok 1247 - createdb: should dump CREATE PUBLICATION pub1
[14:07:05.266](0.000s) ok 1248 - createdb: should dump CREATE PUBLICATION pub10
[14:07:05.266](0.000s) ok 1249 - createdb: should dump CREATE PUBLICATION pub2
[14:07:05.266](0.000s) ok 1250 - createdb: should dump CREATE PUBLICATION pub3
[14:07:05.266](0.000s) ok 1251 - createdb: should dump CREATE PUBLICATION pub4
[14:07:05.267](0.000s) ok 1252 - createdb: should dump CREATE PUBLICATION pub5
[14:07:05.267](0.000s) ok 1253 - createdb: should dump CREATE PUBLICATION pub6
[14:07:05.267](0.000s) ok 1254 - createdb: should dump CREATE PUBLICATION pub7
[14:07:05.267](0.000s) ok 1255 - createdb: should dump CREATE PUBLICATION pub8
[14:07:05.268](0.000s) ok 1256 - createdb: should dump CREATE PUBLICATION pub9
[14:07:05.268](0.000s) ok 1257 - createdb: should not dump CREATE ROLE regress_dump_test_role
[14:07:05.268](0.000s) ok 1258 - createdb: should not dump CREATE ROLE regress_quoted...
[14:07:05.268](0.000s) ok 1259 - createdb: should dump CREATE SCHEMA dump_test
[14:07:05.269](0.000s) ok 1260 - createdb: should dump CREATE SCHEMA dump_test_second_schema
[14:07:05.269](0.000s) ok 1261 - createdb: should not dump CREATE SCHEMA public
[14:07:05.269](0.000s) ok 1262 - createdb: should dump CREATE SEQUENCE test_table_col1_seq
[14:07:05.269](0.000s) ok 1263 - createdb: should dump CREATE SERVER s1 FOREIGN DATA WRAPPER dummy
[14:07:05.270](0.000s) ok 1264 - createdb: should dump CREATE STATISTICS extended_stats_expression
[14:07:05.270](0.000s) ok 1265 - createdb: should dump CREATE STATISTICS extended_stats_no_options
[14:07:05.270](0.000s) ok 1266 - createdb: should dump CREATE STATISTICS extended_stats_options
[14:07:05.271](0.001s) ok 1267 - createdb: should dump CREATE SUBSCRIPTION sub1
[14:07:05.272](0.001s) ok 1268 - createdb: should dump CREATE SUBSCRIPTION sub2
[14:07:05.272](0.000s) ok 1269 - createdb: should dump CREATE SUBSCRIPTION sub3
[14:07:05.272](0.000s) ok 1270 - createdb: should dump CREATE TABLE fk_reference_test_table
[14:07:05.273](0.000s) ok 1271 - createdb: should dump CREATE TABLE measurement PARTITIONED BY
[14:07:05.273](0.000s) ok 1272 - createdb: should dump CREATE TABLE regress_pg_dump_table_am
[14:07:05.284](0.010s) ok 1273 - createdb: should dump CREATE TABLE regress_pg_dump_table_part
[14:07:05.284](0.001s) ok 1274 - createdb: should dump CREATE TABLE table_with_stats
[14:07:05.285](0.001s) ok 1275 - createdb: should dump CREATE TABLE test_fifth_table
[14:07:05.286](0.001s) ok 1276 - createdb: should dump CREATE TABLE test_fourth_table_zero_col
[14:07:05.286](0.001s) ok 1277 - createdb: should dump CREATE TABLE test_inheritance_child
[14:07:05.287](0.000s) ok 1278 - createdb: should dump CREATE TABLE test_inheritance_parent
[14:07:05.287](0.000s) ok 1279 - createdb: should dump CREATE TABLE test_second_table
[14:07:05.287](0.000s) ok 1280 - createdb: should dump CREATE TABLE test_seventh_table
[14:07:05.288](0.000s) ok 1281 - createdb: should dump CREATE TABLE test_sixth_table
[14:07:05.291](0.004s) ok 1282 - createdb: should dump CREATE TABLE test_table
[14:07:05.292](0.000s) ok 1283 - createdb: should dump CREATE TABLE test_table_generated
[14:07:05.293](0.001s) ok 1284 - createdb: should dump CREATE TABLE test_table_generated_child1 (without local columns)
[14:07:05.293](0.000s) ok 1285 - createdb: should dump CREATE TABLE test_table_generated_child2 (with local columns)
[14:07:05.294](0.001s) ok 1286 - createdb: should dump CREATE TABLE test_table_identity
[14:07:05.295](0.000s) ok 1287 - createdb: should dump CREATE TABLE test_third_table_generated_cols
[14:07:05.295](0.000s) ok 1288 - createdb: should not dump CREATE TABLESPACE regress_dump_tablespace
[14:07:05.295](0.000s) ok 1289 - createdb: should dump CREATE TEXT SEARCH CONFIGURATION dump_test.alt_ts_conf1
[14:07:05.296](0.000s) ok 1290 - createdb: should dump CREATE TEXT SEARCH DICTIONARY dump_test.alt_ts_dict1
[14:07:05.296](0.000s) ok 1291 - createdb: should dump CREATE TEXT SEARCH PARSER dump_test.alt_ts_prs1
[14:07:05.296](0.000s) ok 1292 - createdb: should dump CREATE TEXT SEARCH TEMPLATE dump_test.alt_ts_temp1
[14:07:05.297](0.000s) ok 1293 - createdb: should dump CREATE TRANSFORM FOR int
[14:07:05.297](0.000s) ok 1294 - createdb: should dump CREATE TRIGGER test_trigger
[14:07:05.297](0.000s) ok 1295 - createdb: should dump CREATE TYPE dump_test.composite
[14:07:05.297](0.000s) ok 1296 - createdb: should dump CREATE TYPE dump_test.int42
[14:07:05.298](0.000s) ok 1297 - createdb: should dump CREATE TYPE dump_test.int42 populated
[14:07:05.298](0.000s) ok 1298 - createdb: should dump CREATE TYPE dump_test.planets AS ENUM
[14:07:05.298](0.000s) ok 1299 - createdb: should not dump CREATE TYPE dump_test.planets AS ENUM pg_upgrade
[14:07:05.299](0.000s) ok 1300 - createdb: should dump CREATE TYPE dump_test.textrange AS RANGE
[14:07:05.299](0.000s) ok 1301 - createdb: should dump CREATE TYPE dump_test.undefined
[14:07:05.299](0.000s) ok 1302 - createdb: should dump CREATE USER MAPPING FOR regress_dump_test_role SERVER s1
[14:07:05.300](0.000s) ok 1303 - createdb: should dump CREATE VIEW test_view
[14:07:05.301](0.002s) ok 1304 - createdb: should dump Check ordering of a function that depends on a primary key
[14:07:05.302](0.001s) ok 1305 - createdb: should dump Check ordering of a matview that depends on a primary key
[14:07:05.303](0.001s) ok 1306 - createdb: should dump Creation of row-level trigger in partitioned table
[14:07:05.304](0.001s) ok 1307 - createdb: should not dump DROP EXTENSION IF EXISTS plpgsql
[14:07:05.304](0.000s) ok 1308 - createdb: should not dump DROP EXTENSION plpgsql
[14:07:05.304](0.000s) ok 1309 - createdb: should not dump DROP FUNCTION IF EXISTS dump_test.pltestlang_call_handler()
[14:07:05.305](0.000s) ok 1310 - createdb: should not dump DROP FUNCTION dump_test.pltestlang_call_handler()
[14:07:05.305](0.000s) ok 1311 - createdb: should not dump DROP LANGUAGE IF EXISTS pltestlang
[14:07:05.305](0.000s) ok 1312 - createdb: should not dump DROP LANGUAGE pltestlang
[14:07:05.306](0.000s) ok 1313 - createdb: should not dump DROP ROLE pg_
[14:07:05.306](0.000s) ok 1314 - createdb: should not dump DROP ROLE regress_dump_test_role
[14:07:05.306](0.000s) ok 1315 - createdb: should not dump DROP SCHEMA IF EXISTS dump_test
[14:07:05.307](0.001s) ok 1316 - createdb: should not dump DROP SCHEMA IF EXISTS dump_test_second_schema
[14:07:05.308](0.001s) ok 1317 - createdb: should not dump DROP SCHEMA IF EXISTS public
[14:07:05.309](0.001s) ok 1318 - createdb: should not dump DROP SCHEMA dump_test
[14:07:05.309](0.001s) ok 1319 - createdb: should not dump DROP SCHEMA dump_test_second_schema
[14:07:05.310](0.001s) ok 1320 - createdb: should not dump DROP SCHEMA public
[14:07:05.310](0.000s) ok 1321 - createdb: should not dump DROP TABLE IF EXISTS test_second_table
[14:07:05.310](0.001s) ok 1322 - createdb: should not dump DROP TABLE IF EXISTS test_table
[14:07:05.311](0.000s) ok 1323 - createdb: should not dump DROP TABLE fk_reference_test_table
[14:07:05.311](0.000s) ok 1324 - createdb: should not dump DROP TABLE test_second_table
[14:07:05.312](0.000s) ok 1325 - createdb: should not dump DROP TABLE test_table
[14:07:05.312](0.000s) ok 1326 - createdb: should dump Disabled trigger on partition is altered
[14:07:05.312](0.000s) ok 1327 - createdb: should not dump Disabled trigger on partition is not created
[14:07:05.313](0.000s) ok 1328 - createdb: should dump GRANT ALL ON LARGE OBJECT ...
[14:07:05.313](0.000s) ok 1329 - createdb: should not dump GRANT CREATE ON DATABASE dump_test
[14:07:05.314](0.000s) ok 1330 - createdb: should dump GRANT EXECUTE ON FUNCTION pg_sleep() TO regress_dump_test_role
[14:07:05.314](0.000s) ok 1331 - createdb: should dump GRANT INSERT(col1) ON TABLE test_second_table
[14:07:05.318](0.004s) ok 1332 - createdb: should dump GRANT SELECT (proname ...) ON TABLE pg_proc TO public
[14:07:05.318](0.000s) ok 1333 - createdb: should dump GRANT SELECT ON PROPERTY GRAPH propgraph
[14:07:05.319](0.001s) ok 1334 - createdb: should dump GRANT SELECT ON TABLE measurement
[14:07:05.319](0.000s) ok 1335 - createdb: should dump GRANT SELECT ON TABLE measurement_y2006m2
[14:07:05.319](0.000s) ok 1336 - createdb: should dump GRANT SELECT ON TABLE test_table
[14:07:05.320](0.001s) ok 1337 - createdb: should dump GRANT USAGE ON DOMAIN dump_test.us_postal_code
[14:07:05.320](0.000s) ok 1338 - createdb: should dump GRANT USAGE ON FOREIGN DATA WRAPPER dummy
[14:07:05.321](0.000s) ok 1339 - createdb: should dump GRANT USAGE ON FOREIGN SERVER s1
[14:07:05.321](0.000s) ok 1340 - createdb: should dump GRANT USAGE ON SCHEMA dump_test_second_schema
[14:07:05.321](0.000s) ok 1341 - createdb: should not dump GRANT USAGE ON SCHEMA public TO public
[14:07:05.322](0.000s) ok 1342 - createdb: should dump GRANT USAGE ON TYPE dump_test.int42
[14:07:05.322](0.000s) ok 1343 - createdb: should dump GRANT USAGE ON TYPE dump_test.planets - ENUM
[14:07:05.322](0.000s) ok 1344 - createdb: should dump GRANT USAGE ON TYPE dump_test.textrange - RANGE
[14:07:05.322](0.000s) ok 1345 - createdb: should not dump INSERT INTO test_fifth_table
[14:07:05.322](0.000s) ok 1346 - createdb: should not dump INSERT INTO test_fourth_table
[14:07:05.323](0.000s) ok 1347 - createdb: should not dump INSERT INTO test_second_table
[14:07:05.323](0.000s) ok 1348 - createdb: should not dump INSERT INTO test_table
[14:07:05.323](0.000s) ok 1349 - createdb: should not dump INSERT INTO test_table_identity
[14:07:05.323](0.000s) ok 1350 - createdb: should not dump INSERT INTO test_third_table
[14:07:05.324](0.000s) ok 1351 - createdb: should not dump INSERT INTO test_third_table (colnames)
[14:07:05.324](0.000s) ok 1352 - createdb: should dump LO create (using lo_from_bytea)
[14:07:05.324](0.000s) ok 1353 - createdb: should dump LO create (with no data)
[14:07:05.325](0.000s) ok 1354 - createdb: should dump LO load (using lo_from_bytea)
[14:07:05.325](0.000s) ok 1355 - createdb: should dump Partition measurement_y2006m2 creation
[14:07:05.325](0.000s) ok 1356 - createdb: should dump REFRESH MATERIALIZED VIEW matview
[14:07:05.326](0.000s) ok 1357 - createdb: should not dump REFRESH MATERIALIZED VIEW matview_fourth
[14:07:05.326](0.000s) ok 1358 - createdb: should dump REFRESH MATERIALIZED VIEW matview_second
[14:07:05.326](0.000s) ok 1359 - createdb: should not dump REFRESH MATERIALIZED VIEW matview_third
[14:07:05.327](0.000s) ok 1360 - createdb: should dump REVOKE ALL ON SCHEMA public
[14:07:05.327](0.001s) ok 1361 - createdb: should not dump REVOKE CONNECT ON DATABASE dump_test FROM public
[14:07:05.328](0.000s) ok 1362 - createdb: should dump REVOKE EXECUTE ON FUNCTION pg_sleep() FROM public
[14:07:05.369](0.041s) ok 1363 - createdb: should not dump REVOKE EXECUTE ON FUNCTION pg_stat_reset FROM regress_dump_test_role
[14:07:05.369](0.000s) ok 1364 - createdb: should dump REVOKE SELECT ON TABLE pg_proc FROM public
[14:07:05.370](0.000s) ok 1365 - createdb: should dump REVOKE USAGE ON LANGUAGE plpgsql FROM public
[14:07:05.370](0.000s) ok 1366 - createdb: should dump Replica trigger on partition is altered
[14:07:05.370](0.000s) ok 1367 - createdb: should not dump Triggers on partitions are not dropped
[14:07:05.370](0.000s) ok 1368 - createdb: should dump extended_statistics_import
[14:07:05.371](0.001s) ok 1369 - createdb: should not dump newline of table name in comment
[14:07:05.371](0.000s) ok 1370 - createdb: should dump relstats_on_unanalyzed_tables
[14:07:05.372](0.000s) ok 1371 - createdb: should dump restrict
[14:07:05.373](0.001s) ok 1372 - createdb: should dump statistics_import
[14:07:05.373](0.000s) ok 1373 - createdb: should not dump test_table with 4-row INSERTs
[14:07:05.373](0.000s) ok 1374 - createdb: should dump unrestrict
# Running: pg_dump --no-sync --file C:\cirrus\build\testrun\pg_dump\002_pg_dump\data\tmp_test_9UIx/data_only.sql --data-only --superuser test_superuser --disable-triggers --verbose postgres
[14:07:07.272](1.898s) ok 1375 - data_only: pg_dump runs
[14:07:07.275](0.004s) ok 1376 - data_only: should not dump ALTER COLLATION test0 OWNER TO
[14:07:07.276](0.000s) ok 1377 - data_only: should not dump ALTER DEFAULT PRIVILEGES FOR ROLE regress_dump_test_role GRANT
[14:07:07.276](0.000s) ok 1378 - data_only: should not dump ALTER DEFAULT PRIVILEGES FOR ROLE regress_dump_test_role GRANT EXECUTE ON FUNCTIONS
[14:07:07.276](0.000s) ok 1379 - data_only: should not dump ALTER DEFAULT PRIVILEGES FOR ROLE regress_dump_test_role REVOKE
[14:07:07.276](0.000s) ok 1380 - data_only: should not dump ALTER DEFAULT PRIVILEGES FOR ROLE regress_dump_test_role REVOKE SELECT
[14:07:07.277](0.000s) ok 1381 - data_only: should not dump ALTER FOREIGN DATA WRAPPER dummy OWNER TO
[14:07:07.277](0.000s) ok 1382 - data_only: should not dump ALTER FOREIGN TABLE foreign_table ALTER COLUMN c1 OPTIONS
[14:07:07.277](0.000s) ok 1383 - data_only: should not dump ALTER FOREIGN TABLE foreign_table OWNER TO
[14:07:07.278](0.001s) ok 1384 - data_only: should not dump ALTER FUNCTION dump_test.pltestlang_call_handler() OWNER TO
[14:07:07.278](0.000s) ok 1385 - data_only: should not dump ALTER INDEX ... ATTACH PARTITION
[14:07:07.278](0.000s) ok 1386 - data_only: should not dump ALTER INDEX ... ATTACH PARTITION (primary key)
[14:07:07.279](0.000s) ok 1387 - data_only: should dump ALTER LARGE OBJECT ... OWNER TO
[14:07:07.279](0.000s) ok 1388 - data_only: should not dump ALTER OPERATOR CLASS dump_test.op_class OWNER TO
[14:07:07.279](0.000s) ok 1389 - data_only: should not dump ALTER OPERATOR FAMILY dump_test.op_family OWNER TO
[14:07:07.279](0.000s) ok 1390 - data_only: should not dump ALTER OPERATOR FAMILY dump_test.op_family USING btree
[14:07:07.280](0.000s) ok 1391 - data_only: should not dump ALTER PROCEDURAL LANGUAGE pltestlang OWNER TO
[14:07:07.280](0.000s) ok 1392 - data_only: should not dump ALTER PUBLICATION pub1 ADD TABLE test_second_table
[14:07:07.280](0.000s) ok 1393 - data_only: should not dump ALTER PUBLICATION pub1 ADD TABLE test_seventh_table (col3, col2) WHERE (col1 = 1)
[14:07:07.280](0.000s) ok 1394 - data_only: should not dump ALTER PUBLICATION pub1 ADD TABLE test_sixth_table (col3, col2)
[14:07:07.280](0.000s) ok 1395 - data_only: should not dump ALTER PUBLICATION pub1 ADD TABLE test_table
[14:07:07.281](0.000s) ok 1396 - data_only: should not dump ALTER PUBLICATION pub1 OWNER TO
[14:07:07.281](0.000s) ok 1397 - data_only: should not dump ALTER PUBLICATION pub3 ADD TABLE test_table
[14:07:07.281](0.000s) ok 1398 - data_only: should not dump ALTER PUBLICATION pub3 ADD TABLES IN SCHEMA dump_test
[14:07:07.281](0.000s) ok 1399 - data_only: should not dump ALTER PUBLICATION pub3 ADD TABLES IN SCHEMA public
[14:07:07.281](0.000s) ok 1400 - data_only: should not dump ALTER PUBLICATION pub4 ADD TABLE test_second_table WHERE (col2 = 'test');
[14:07:07.282](0.000s) ok 1401 - data_only: should not dump ALTER PUBLICATION pub4 ADD TABLE test_table WHERE (col1 > 0);
[14:07:07.282](0.000s) ok 1402 - data_only: should not dump ALTER ROLE regress_dump_test_role
[14:07:07.282](0.000s) ok 1403 - data_only: should not dump ALTER SCHEMA dump_test OWNER TO
[14:07:07.282](0.000s) ok 1404 - data_only: should not dump ALTER SCHEMA dump_test_second_schema OWNER TO
[14:07:07.282](0.000s) ok 1405 - data_only: should not dump ALTER SCHEMA public OWNER TO
[14:07:07.283](0.000s) ok 1406 - data_only: should not dump ALTER SEQUENCE test_table_col1_seq
[14:07:07.283](0.000s) ok 1407 - data_only: should not dump ALTER SERVER s1 OWNER TO
[14:07:07.283](0.000s) ok 1408 - data_only: should not dump ALTER STATISTICS extended_stats_options
[14:07:07.283](0.000s) ok 1409 - data_only: should not dump ALTER TABLE (partitioned) ADD CONSTRAINT ... FOREIGN KEY
[14:07:07.284](0.000s) ok 1410 - data_only: should not dump ALTER TABLE ONLY dump_test.measurement ATTACH PARTITION measurement_y2006m2
[14:07:07.284](0.000s) ok 1411 - data_only: should not dump ALTER TABLE ONLY test_table ADD CONSTRAINT ... PRIMARY KEY
[14:07:07.284](0.001s) ok 1412 - data_only: should not dump ALTER TABLE ONLY test_table ALTER COLUMN col1 SET STATISTICS 90
[14:07:07.285](0.001s) ok 1413 - data_only: should not dump ALTER TABLE ONLY test_table ALTER COLUMN col2 SET STORAGE
[14:07:07.285](0.000s) ok 1414 - data_only: should not dump ALTER TABLE ONLY test_table ALTER COLUMN col3 SET STORAGE
[14:07:07.286](0.000s) ok 1415 - data_only: should not dump ALTER TABLE ONLY test_table ALTER COLUMN col4 SET n_distinct
[14:07:07.286](0.000s) ok 1416 - data_only: should not dump ALTER TABLE measurement OWNER TO
[14:07:07.286](0.000s) ok 1417 - data_only: should not dump ALTER TABLE measurement PRIMARY KEY
[14:07:07.286](0.000s) ok 1418 - data_only: should not dump ALTER TABLE measurement_y2006m2 OWNER TO
[14:07:07.287](0.000s) ok 1419 - data_only: should not dump ALTER TABLE test_second_table OWNER TO
[14:07:07.287](0.000s) ok 1420 - data_only: should not dump ALTER TABLE test_table CLUSTER ON test_table_pkey
[14:07:07.287](0.000s) ok 1421 - data_only: should dump ALTER TABLE test_table DISABLE TRIGGER ALL
[14:07:07.287](0.000s) ok 1422 - data_only: should not dump ALTER TABLE test_table ENABLE ROW LEVEL SECURITY
[14:07:07.287](0.000s) ok 1423 - data_only: should not dump ALTER TABLE test_table OWNER TO
[14:07:07.287](0.000s) ok 1424 - data_only: should not dump ALTER TABLE test_table_generated_child1
[14:07:07.288](0.000s) ok 1425 - data_only: should not dump ALTER TEXT SEARCH CONFIGURATION alt_ts_conf1 OWNER TO
[14:07:07.288](0.001s) ok 1426 - data_only: should not dump ALTER TEXT SEARCH CONFIGURATION dump_test.alt_ts_conf1 ...
[14:07:07.289](0.000s) ok 1427 - data_only: should not dump ALTER TEXT SEARCH DICTIONARY alt_ts_dict1 OWNER TO
[14:07:07.289](0.000s) ok 1428 - data_only: should not dump ALTER VIEW test_view SET DEFAULT
[14:07:07.289](0.000s) ok 1429 - data_only: should not dump Always trigger on partition is altered
[14:07:07.289](0.000s) ok 1430 - data_only: should not dump COMMENT ON COLLATION test0
[14:07:07.290](0.000s) ok 1431 - data_only: should not dump COMMENT ON COLUMN dump_test.composite.f1
[14:07:07.290](0.000s) ok 1432 - data_only: should not dump COMMENT ON COLUMN dump_test.test_second_table.col1
[14:07:07.290](0.000s) ok 1433 - data_only: should not dump COMMENT ON COLUMN dump_test.test_second_table.col2
[14:07:07.290](0.000s) ok 1434 - data_only: should not dump COMMENT ON COLUMN dump_test.test_table.col1
[14:07:07.290](0.000s) ok 1435 - data_only: should not dump COMMENT ON CONSTRAINT ON DOMAIN (1)
[14:07:07.291](0.000s) ok 1436 - data_only: should not dump COMMENT ON CONSTRAINT ON DOMAIN (2)
[14:07:07.291](0.000s) ok 1437 - data_only: should not dump COMMENT ON CONSTRAINT ON test_table_chld2
[14:07:07.291](0.000s) ok 1438 - data_only: should not dump COMMENT ON CONSTRAINT ON test_table_nn
[14:07:07.291](0.000s) ok 1439 - data_only: should not dump COMMENT ON CONVERSION dump_test.test_conversion
[14:07:07.291](0.000s) ok 1440 - data_only: should not dump COMMENT ON DATABASE postgres
[14:07:07.292](0.000s) ok 1441 - data_only: should not dump COMMENT ON EXTENSION plpgsql
[14:07:07.292](0.000s) ok 1442 - data_only: should dump COMMENT ON LARGE OBJECT ...
[14:07:07.292](0.000s) ok 1443 - data_only: should not dump COMMENT ON POLICY p1
[14:07:07.293](0.000s) ok 1444 - data_only: should not dump COMMENT ON PUBLICATION pub1
[14:07:07.293](0.000s) ok 1445 - data_only: should not dump COMMENT ON SCHEMA public
[14:07:07.293](0.000s) ok 1446 - data_only: should not dump COMMENT ON SUBSCRIPTION sub1
[14:07:07.293](0.000s) ok 1447 - data_only: should not dump COMMENT ON TABLE dump_test.test_table
[14:07:07.294](0.000s) ok 1448 - data_only: should not dump COMMENT ON TEXT SEARCH CONFIGURATION dump_test.alt_ts_conf1
[14:07:07.294](0.000s) ok 1449 - data_only: should not dump COMMENT ON TEXT SEARCH DICTIONARY dump_test.alt_ts_dict1
[14:07:07.294](0.000s) ok 1450 - data_only: should not dump COMMENT ON TEXT SEARCH PARSER dump_test.alt_ts_prs1
[14:07:07.294](0.000s) ok 1451 - data_only: should not dump COMMENT ON TEXT SEARCH TEMPLATE dump_test.alt_ts_temp1
[14:07:07.294](0.000s) ok 1452 - data_only: should not dump COMMENT ON TYPE dump_test.int42 - Regular
[14:07:07.295](0.000s) ok 1453 - data_only: should not dump COMMENT ON TYPE dump_test.planets - ENUM
[14:07:07.295](0.000s) ok 1454 - data_only: should not dump COMMENT ON TYPE dump_test.textrange - RANGE
[14:07:07.295](0.000s) ok 1455 - data_only: should not dump COMMENT ON TYPE dump_test.undefined - Undefined
[14:07:07.296](0.000s) ok 1456 - data_only: should not dump CONSTRAINT NOT NULL / NO INHERIT
[14:07:07.296](0.000s) ok 1457 - data_only: should not dump CONSTRAINT NOT NULL / NO INHERIT (child1)
[14:07:07.296](0.000s) ok 1458 - data_only: should not dump CONSTRAINT NOT NULL / NOT VALID
[14:07:07.296](0.000s) ok 1459 - data_only: should not dump CONSTRAINT NOT NULL / NOT VALID (child1)
[14:07:07.296](0.000s) ok 1460 - data_only: should not dump CONSTRAINT NOT NULL / NOT VALID (child2)
[14:07:07.297](0.000s) ok 1461 - data_only: should not dump CONSTRAINT NOT NULL / NOT VALID (child3)
[14:07:07.297](0.000s) ok 1462 - data_only: should not dump CONSTRAINT PRIMARY KEY / WITHOUT OVERLAPS
[14:07:07.297](0.000s) ok 1463 - data_only: should not dump CONSTRAINT UNIQUE / WITHOUT OVERLAPS
[14:07:07.297](0.000s) ok 1464 - data_only: should dump COPY fk_reference_test_table
[14:07:07.298](0.000s) ok 1465 - data_only: should dump COPY fk_reference_test_table second
[14:07:07.298](0.000s) ok 1466 - data_only: should dump COPY measurement
[14:07:07.298](0.000s) ok 1467 - data_only: should dump COPY test_fifth_table
[14:07:07.298](0.000s) ok 1468 - data_only: should dump COPY test_fourth_table
[14:07:07.298](0.000s) ok 1469 - data_only: should dump COPY test_second_table
[14:07:07.299](0.000s) ok 1470 - data_only: should dump COPY test_table
[14:07:07.299](0.000s) ok 1471 - data_only: should dump COPY test_table_identity
[14:07:07.300](0.000s) ok 1472 - data_only: should dump COPY test_third_table
[14:07:07.300](0.001s) ok 1473 - data_only: should not dump CREATE ACCESS METHOD gist2
[14:07:07.301](0.000s) ok 1474 - data_only: should not dump CREATE ACCESS METHOD regress_test_table_am
[14:07:07.301](0.000s) ok 1475 - data_only: should not dump CREATE AGGREGATE dump_test.newavg
[14:07:07.301](0.000s) ok 1476 - data_only: should not dump CREATE CAST FOR timestamptz
[14:07:07.301](0.000s) ok 1477 - data_only: should not dump CREATE COLLATION test0 FROM "C"
[14:07:07.302](0.000s) ok 1478 - data_only: should not dump CREATE CONVERSION dump_test.test_conversion
[14:07:07.302](0.000s) ok 1479 - data_only: should not dump CREATE DATABASE dump_test
[14:07:07.302](0.000s) ok 1480 - data_only: should not dump CREATE DATABASE dump_test2 LOCALE = 'C'
[14:07:07.302](0.000s) ok 1481 - data_only: should not dump CREATE DATABASE postgres
[14:07:07.302](0.000s) ok 1482 - data_only: should not dump CREATE DATABASE regression_invalid...
[14:07:07.303](0.000s) ok 1483 - data_only: should not dump CREATE DOMAIN dump_test.us_postal_code
[14:07:07.303](0.000s) ok 1484 - data_only: should not dump CREATE EVENT TRIGGER test_event_trigger
[14:07:07.303](0.000s) ok 1485 - data_only: should not dump CREATE EXTENSION ... plpgsql
[14:07:07.303](0.000s) ok 1486 - data_only: should not dump CREATE FOREIGN DATA WRAPPER dummy
[14:07:07.303](0.000s) ok 1487 - data_only: should not dump CREATE FOREIGN TABLE dump_test.foreign_table SERVER s1
[14:07:07.304](0.000s) ok 1488 - data_only: should not dump CREATE FUNCTION ... SUPPORT
[14:07:07.304](0.000s) ok 1489 - data_only: should not dump CREATE FUNCTION dump_test.event_trigger_func
[14:07:07.304](0.000s) ok 1490 - data_only: should not dump CREATE FUNCTION dump_test.int42_in
[14:07:07.304](0.000s) ok 1491 - data_only: should not dump CREATE FUNCTION dump_test.int42_out
[14:07:07.304](0.000s) ok 1492 - data_only: should not dump CREATE FUNCTION dump_test.pltestlang_call_handler
[14:07:07.304](0.000s) ok 1493 - data_only: should not dump CREATE FUNCTION dump_test.trigger_func
[14:07:07.305](0.000s) ok 1494 - data_only: should not dump CREATE INDEX ... ON measurement_y2006_m2
[14:07:07.305](0.000s) ok 1495 - data_only: should not dump CREATE INDEX ON ONLY measurement
[14:07:07.305](0.000s) ok 1496 - data_only: should not dump CREATE LANGUAGE pltestlang
[14:07:07.305](0.000s) ok 1497 - data_only: should not dump CREATE MATERIALIZED VIEW matview
[14:07:07.305](0.000s) ok 1498 - data_only: should not dump CREATE MATERIALIZED VIEW matview_fourth
[14:07:07.306](0.000s) ok 1499 - data_only: should not dump CREATE MATERIALIZED VIEW matview_second
[14:07:07.306](0.000s) ok 1500 - data_only: should not dump CREATE MATERIALIZED VIEW matview_third
[14:07:07.306](0.000s) ok 1501 - data_only: should not dump CREATE MATERIALIZED VIEW regress_pg_dump_matview_am
[14:07:07.306](0.000s) ok 1502 - data_only: should not dump CREATE OPERATOR CLASS dump_test.op_class
[14:07:07.307](0.000s) ok 1503 - data_only: should not dump CREATE OPERATOR CLASS dump_test.op_class_custom
[14:07:07.307](0.001s) ok 1504 - data_only: should not dump CREATE OPERATOR CLASS dump_test.op_class_empty
[14:07:07.308](0.000s) ok 1505 - data_only: should not dump CREATE OPERATOR FAMILY dump_test.op_family
[14:07:07.308](0.000s) ok 1506 - data_only: should not dump CREATE POLICY p1 ON test_table
[14:07:07.308](0.000s) ok 1507 - data_only: should not dump CREATE POLICY p2 ON test_table FOR SELECT
[14:07:07.309](0.000s) ok 1508 - data_only: should not dump CREATE POLICY p3 ON test_table FOR INSERT
[14:07:07.309](0.000s) ok 1509 - data_only: should not dump CREATE POLICY p4 ON test_table FOR UPDATE
[14:07:07.309](0.000s) ok 1510 - data_only: should not dump CREATE POLICY p5 ON test_table FOR DELETE
[14:07:07.309](0.000s) ok 1511 - data_only: should not dump CREATE POLICY p6 ON test_table AS RESTRICTIVE
[14:07:07.309](0.000s) ok 1512 - data_only: should not dump CREATE PROCEDURE dump_test.ptest1
[14:07:07.310](0.000s) ok 1513 - data_only: should not dump CREATE PROPERTY GRAPH propgraph
[14:07:07.310](0.000s) ok 1514 - data_only: should not dump CREATE PUBLICATION pub1
[14:07:07.310](0.000s) ok 1515 - data_only: should not dump CREATE PUBLICATION pub10
[14:07:07.310](0.000s) ok 1516 - data_only: should not dump CREATE PUBLICATION pub2
[14:07:07.310](0.000s) ok 1517 - data_only: should not dump CREATE PUBLICATION pub3
[14:07:07.311](0.000s) ok 1518 - data_only: should not dump CREATE PUBLICATION pub4
[14:07:07.311](0.000s) ok 1519 - data_only: should not dump CREATE PUBLICATION pub5
[14:07:07.311](0.000s) ok 1520 - data_only: should not dump CREATE PUBLICATION pub6
[14:07:07.311](0.000s) ok 1521 - data_only: should not dump CREATE PUBLICATION pub7
[14:07:07.311](0.000s) ok 1522 - data_only: should not dump CREATE PUBLICATION pub8
[14:07:07.312](0.000s) ok 1523 - data_only: should not dump CREATE PUBLICATION pub9
[14:07:07.312](0.000s) ok 1524 - data_only: should not dump CREATE ROLE regress_dump_test_role
[14:07:07.312](0.000s) ok 1525 - data_only: should not dump CREATE ROLE regress_quoted...
[14:07:07.312](0.000s) ok 1526 - data_only: should not dump CREATE SCHEMA dump_test
[14:07:07.312](0.000s) ok 1527 - data_only: should not dump CREATE SCHEMA dump_test_second_schema
[14:07:07.313](0.000s) ok 1528 - data_only: should not dump CREATE SCHEMA public
[14:07:07.313](0.000s) ok 1529 - data_only: should not dump CREATE SEQUENCE test_table_col1_seq
[14:07:07.313](0.000s) ok 1530 - data_only: should not dump CREATE SERVER s1 FOREIGN DATA WRAPPER dummy
[14:07:07.313](0.000s) ok 1531 - data_only: should not dump CREATE STATISTICS extended_stats_expression
[14:07:07.313](0.000s) ok 1532 - data_only: should not dump CREATE STATISTICS extended_stats_no_options
[14:07:07.313](0.000s) ok 1533 - data_only: should not dump CREATE STATISTICS extended_stats_options
[14:07:07.314](0.000s) ok 1534 - data_only: should not dump CREATE SUBSCRIPTION sub1
[14:07:07.314](0.000s) ok 1535 - data_only: should not dump CREATE SUBSCRIPTION sub2
[14:07:07.314](0.000s) ok 1536 - data_only: should not dump CREATE SUBSCRIPTION sub3
[14:07:07.315](0.000s) ok 1537 - data_only: should not dump CREATE TABLE fk_reference_test_table
[14:07:07.315](0.001s) ok 1538 - data_only: should not dump CREATE TABLE measurement PARTITIONED BY
[14:07:07.315](0.000s) ok 1539 - data_only: should not dump CREATE TABLE regress_pg_dump_table_am
[14:07:07.316](0.000s) ok 1540 - data_only: should not dump CREATE TABLE regress_pg_dump_table_part
[14:07:07.316](0.001s) ok 1541 - data_only: should not dump CREATE TABLE table_with_stats
[14:07:07.317](0.000s) ok 1542 - data_only: should not dump CREATE TABLE test_fifth_table
[14:07:07.317](0.000s) ok 1543 - data_only: should not dump CREATE TABLE test_fourth_table_zero_col
[14:07:07.317](0.000s) ok 1544 - data_only: should not dump CREATE TABLE test_inheritance_child
[14:07:07.318](0.000s) ok 1545 - data_only: should not dump CREATE TABLE test_inheritance_parent
[14:07:07.318](0.001s) ok 1546 - data_only: should not dump CREATE TABLE test_second_table
[14:07:07.318](0.000s) ok 1547 - data_only: should not dump CREATE TABLE test_seventh_table
[14:07:07.319](0.000s) ok 1548 - data_only: should not dump CREATE TABLE test_sixth_table
[14:07:07.319](0.000s) ok 1549 - data_only: should not dump CREATE TABLE test_table
[14:07:07.319](0.000s) ok 1550 - data_only: should not dump CREATE TABLE test_table_generated
[14:07:07.319](0.000s) ok 1551 - data_only: should not dump CREATE TABLE test_table_generated_child1 (without local columns)
[14:07:07.319](0.000s) ok 1552 - data_only: should not dump CREATE TABLE test_table_generated_child2 (with local columns)
[14:07:07.319](0.000s) ok 1553 - data_only: should not dump CREATE TABLE test_table_identity
[14:07:07.320](0.000s) ok 1554 - data_only: should not dump CREATE TABLE test_third_table_generated_cols
[14:07:07.320](0.000s) ok 1555 - data_only: should not dump CREATE TABLESPACE regress_dump_tablespace
[14:07:07.320](0.000s) ok 1556 - data_only: should not dump CREATE TEXT SEARCH CONFIGURATION dump_test.alt_ts_conf1
[14:07:07.320](0.000s) ok 1557 - data_only: should not dump CREATE TEXT SEARCH DICTIONARY dump_test.alt_ts_dict1
[14:07:07.320](0.000s) ok 1558 - data_only: should not dump CREATE TEXT SEARCH PARSER dump_test.alt_ts_prs1
[14:07:07.321](0.000s) ok 1559 - data_only: should not dump CREATE TEXT SEARCH TEMPLATE dump_test.alt_ts_temp1
[14:07:07.321](0.000s) ok 1560 - data_only: should not dump CREATE TRANSFORM FOR int
[14:07:07.321](0.000s) ok 1561 - data_only: should not dump CREATE TRIGGER test_trigger
[14:07:07.321](0.000s) ok 1562 - data_only: should not dump CREATE TYPE dump_test.composite
[14:07:07.321](0.000s) ok 1563 - data_only: should not dump CREATE TYPE dump_test.int42
[14:07:07.321](0.000s) ok 1564 - data_only: should not dump CREATE TYPE dump_test.int42 populated
[14:07:07.322](0.000s) ok 1565 - data_only: should not dump CREATE TYPE dump_test.planets AS ENUM
[14:07:07.322](0.000s) ok 1566 - data_only: should not dump CREATE TYPE dump_test.planets AS ENUM pg_upgrade
[14:07:07.322](0.000s) ok 1567 - data_only: should not dump CREATE TYPE dump_test.textrange AS RANGE
[14:07:07.322](0.000s) ok 1568 - data_only: should not dump CREATE TYPE dump_test.undefined
[14:07:07.322](0.000s) ok 1569 - data_only: should not dump CREATE USER MAPPING FOR regress_dump_test_role SERVER s1
[14:07:07.323](0.000s) ok 1570 - data_only: should not dump CREATE VIEW test_view
[14:07:07.323](0.000s) ok 1571 - data_only: should not dump Check ordering of a function that depends on a primary key
[14:07:07.323](0.000s) ok 1572 - data_only: should not dump Check ordering of a matview that depends on a primary key
[14:07:07.323](0.000s) ok 1573 - data_only: should not dump Creation of row-level trigger in partitioned table
[14:07:07.323](0.000s) ok 1574 - data_only: should not dump DROP EXTENSION IF EXISTS plpgsql
[14:07:07.324](0.000s) ok 1575 - data_only: should not dump DROP EXTENSION plpgsql
[14:07:07.324](0.000s) ok 1576 - data_only: should not dump DROP FUNCTION IF EXISTS dump_test.pltestlang_call_handler()
[14:07:07.324](0.001s) ok 1577 - data_only: should not dump DROP FUNCTION dump_test.pltestlang_call_handler()
[14:07:07.325](0.000s) ok 1578 - data_only: should not dump DROP LANGUAGE IF EXISTS pltestlang
[14:07:07.325](0.000s) ok 1579 - data_only: should not dump DROP LANGUAGE pltestlang
[14:07:07.325](0.000s) ok 1580 - data_only: should not dump DROP ROLE pg_
[14:07:07.325](0.000s) ok 1581 - data_only: should not dump DROP ROLE regress_dump_test_role
[14:07:07.325](0.000s) ok 1582 - data_only: should not dump DROP SCHEMA IF EXISTS dump_test
[14:07:07.326](0.000s) ok 1583 - data_only: should not dump DROP SCHEMA IF EXISTS dump_test_second_schema
[14:07:07.326](0.000s) ok 1584 - data_only: should not dump DROP SCHEMA IF EXISTS public
[14:07:07.326](0.000s) ok 1585 - data_only: should not dump DROP SCHEMA dump_test
[14:07:07.326](0.000s) ok 1586 - data_only: should not dump DROP SCHEMA dump_test_second_schema
[14:07:07.327](0.000s) ok 1587 - data_only: should not dump DROP SCHEMA public
[14:07:07.327](0.001s) ok 1588 - data_only: should not dump DROP TABLE IF EXISTS test_second_table
[14:07:07.328](0.001s) ok 1589 - data_only: should not dump DROP TABLE IF EXISTS test_table
[14:07:07.328](0.000s) ok 1590 - data_only: should not dump DROP TABLE fk_reference_test_table
[14:07:07.328](0.000s) ok 1591 - data_only: should not dump DROP TABLE test_second_table
[14:07:07.329](0.000s) ok 1592 - data_only: should not dump DROP TABLE test_table
[14:07:07.329](0.000s) ok 1593 - data_only: should not dump Disabled trigger on partition is altered
[14:07:07.329](0.000s) ok 1594 - data_only: should not dump Disabled trigger on partition is not created
[14:07:07.329](0.000s) ok 1595 - data_only: should dump GRANT ALL ON LARGE OBJECT ...
[14:07:07.330](0.000s) ok 1596 - data_only: should not dump GRANT CREATE ON DATABASE dump_test
[14:07:07.330](0.000s) ok 1597 - data_only: should not dump GRANT EXECUTE ON FUNCTION pg_sleep() TO regress_dump_test_role
[14:07:07.330](0.000s) ok 1598 - data_only: should not dump GRANT INSERT(col1) ON TABLE test_second_table
[14:07:07.331](0.001s) ok 1599 - data_only: should not dump GRANT SELECT (proname ...) ON TABLE pg_proc TO public
[14:07:07.332](0.001s) ok 1600 - data_only: should not dump GRANT SELECT ON PROPERTY GRAPH propgraph
[14:07:07.332](0.000s) ok 1601 - data_only: should not dump GRANT SELECT ON TABLE measurement
[14:07:07.332](0.000s) ok 1602 - data_only: should not dump GRANT SELECT ON TABLE measurement_y2006m2
[14:07:07.332](0.000s) ok 1603 - data_only: should not dump GRANT SELECT ON TABLE test_table
[14:07:07.333](0.000s) ok 1604 - data_only: should not dump GRANT USAGE ON DOMAIN dump_test.us_postal_code
[14:07:07.333](0.000s) ok 1605 - data_only: should not dump GRANT USAGE ON FOREIGN DATA WRAPPER dummy
[14:07:07.333](0.000s) ok 1606 - data_only: should not dump GRANT USAGE ON FOREIGN SERVER s1
[14:07:07.333](0.000s) ok 1607 - data_only: should not dump GRANT USAGE ON SCHEMA dump_test_second_schema
[14:07:07.333](0.000s) ok 1608 - data_only: should not dump GRANT USAGE ON SCHEMA public TO public
[14:07:07.334](0.000s) ok 1609 - data_only: should not dump GRANT USAGE ON TYPE dump_test.int42
[14:07:07.334](0.000s) ok 1610 - data_only: should not dump GRANT USAGE ON TYPE dump_test.planets - ENUM
[14:07:07.334](0.000s) ok 1611 - data_only: should not dump GRANT USAGE ON TYPE dump_test.textrange - RANGE
[14:07:07.334](0.000s) ok 1612 - data_only: should not dump INSERT INTO test_fifth_table
[14:07:07.334](0.000s) ok 1613 - data_only: should not dump INSERT INTO test_fourth_table
[14:07:07.335](0.000s) ok 1614 - data_only: should not dump INSERT INTO test_second_table
[14:07:07.335](0.000s) ok 1615 - data_only: should not dump INSERT INTO test_table
[14:07:07.335](0.000s) ok 1616 - data_only: should not dump INSERT INTO test_table_identity
[14:07:07.335](0.000s) ok 1617 - data_only: should not dump INSERT INTO test_third_table
[14:07:07.336](0.000s) ok 1618 - data_only: should not dump INSERT INTO test_third_table (colnames)
[14:07:07.336](0.000s) ok 1619 - data_only: should dump LO create (using lo_from_bytea)
[14:07:07.337](0.001s) ok 1620 - data_only: should dump LO create (with no data)
[14:07:07.337](0.000s) ok 1621 - data_only: should dump LO load (using lo_from_bytea)
[14:07:07.338](0.000s) ok 1622 - data_only: should not dump Partition measurement_y2006m2 creation
[14:07:07.338](0.000s) ok 1623 - data_only: should not dump REFRESH MATERIALIZED VIEW matview
[14:07:07.338](0.000s) ok 1624 - data_only: should not dump REFRESH MATERIALIZED VIEW matview_fourth
[14:07:07.339](0.000s) ok 1625 - data_only: should not dump REFRESH MATERIALIZED VIEW matview_second
[14:07:07.339](0.000s) ok 1626 - data_only: should not dump REFRESH MATERIALIZED VIEW matview_third
[14:07:07.340](0.001s) ok 1627 - data_only: should not dump REVOKE ALL ON SCHEMA public
[14:07:07.340](0.000s) ok 1628 - data_only: should not dump REVOKE CONNECT ON DATABASE dump_test FROM public
[14:07:07.341](0.001s) ok 1629 - data_only: should not dump REVOKE EXECUTE ON FUNCTION pg_sleep() FROM public
[14:07:07.346](0.006s) ok 1630 - data_only: should not dump REVOKE EXECUTE ON FUNCTION pg_stat_reset FROM regress_dump_test_role
[14:07:07.347](0.000s) ok 1631 - data_only: should not dump REVOKE SELECT ON TABLE pg_proc FROM public
[14:07:07.347](0.000s) ok 1632 - data_only: should not dump REVOKE USAGE ON LANGUAGE plpgsql FROM public
[14:07:07.347](0.001s) ok 1633 - data_only: should not dump Replica trigger on partition is altered
[14:07:07.348](0.001s) ok 1634 - data_only: should not dump Triggers on partitions are not dropped
[14:07:07.349](0.001s) ok 1635 - data_only: should not dump extended_statistics_import
[14:07:07.349](0.001s) ok 1636 - data_only: should not dump newline of table name in comment
[14:07:07.349](0.000s) ok 1637 - data_only: should not dump relstats_on_unanalyzed_tables
[14:07:07.350](0.000s) ok 1638 - data_only: should dump restrict
[14:07:07.350](0.001s) ok 1639 - data_only: should not dump statistics_import
[14:07:07.351](0.000s) ok 1640 - data_only: should not dump test_table with 4-row INSERTs
[14:07:07.351](0.000s) ok 1641 - data_only: should dump unrestrict
# Running: pg_dump --no-sync --file C:\cirrus\build\testrun\pg_dump\002_pg_dump\data\tmp_test_9UIx/defaults.sql --statistics postgres
[14:07:08.101](0.750s) ok 1642 - defaults: pg_dump runs
[14:07:08.104](0.003s) ok 1643 - defaults: should dump ALTER COLLATION test0 OWNER TO
[14:07:08.105](0.001s) ok 1644 - defaults: should dump ALTER DEFAULT PRIVILEGES FOR ROLE regress_dump_test_role GRANT
[14:07:08.106](0.000s) ok 1645 - defaults: should dump ALTER DEFAULT PRIVILEGES FOR ROLE regress_dump_test_role GRANT EXECUTE ON FUNCTIONS
[14:07:08.106](0.001s) ok 1646 - defaults: should dump ALTER DEFAULT PRIVILEGES FOR ROLE regress_dump_test_role REVOKE
[14:07:08.107](0.000s) ok 1647 - defaults: should dump ALTER DEFAULT PRIVILEGES FOR ROLE regress_dump_test_role REVOKE SELECT
[14:07:08.107](0.000s) ok 1648 - defaults: should dump ALTER FOREIGN DATA WRAPPER dummy OWNER TO
[14:07:08.107](0.001s) ok 1649 - defaults: should dump ALTER FOREIGN TABLE foreign_table ALTER COLUMN c1 OPTIONS
[14:07:08.108](0.000s) ok 1650 - defaults: should dump ALTER FOREIGN TABLE foreign_table OWNER TO
[14:07:08.108](0.000s) ok 1651 - defaults: should dump ALTER FUNCTION dump_test.pltestlang_call_handler() OWNER TO
[14:07:08.108](0.000s) ok 1652 - defaults: should dump ALTER INDEX ... ATTACH PARTITION
[14:07:08.109](0.000s) ok 1653 - defaults: should dump ALTER INDEX ... ATTACH PARTITION (primary key)
[14:07:08.109](0.000s) ok 1654 - defaults: should dump ALTER LARGE OBJECT ... OWNER TO
[14:07:08.109](0.000s) ok 1655 - defaults: should dump ALTER OPERATOR CLASS dump_test.op_class OWNER TO
[14:07:08.109](0.000s) ok 1656 - defaults: should dump ALTER OPERATOR FAMILY dump_test.op_family OWNER TO
[14:07:08.109](0.000s) ok 1657 - defaults: should dump ALTER OPERATOR FAMILY dump_test.op_family USING btree
[14:07:08.110](0.000s) ok 1658 - defaults: should dump ALTER PROCEDURAL LANGUAGE pltestlang OWNER TO
[14:07:08.110](0.000s) ok 1659 - defaults: should dump ALTER PUBLICATION pub1 ADD TABLE test_second_table
[14:07:08.110](0.000s) ok 1660 - defaults: should dump ALTER PUBLICATION pub1 ADD TABLE test_seventh_table (col3, col2) WHERE (col1 = 1)
[14:07:08.110](0.000s) ok 1661 - defaults: should dump ALTER PUBLICATION pub1 ADD TABLE test_sixth_table (col3, col2)
[14:07:08.111](0.000s) ok 1662 - defaults: should dump ALTER PUBLICATION pub1 ADD TABLE test_table
[14:07:08.111](0.000s) ok 1663 - defaults: should dump ALTER PUBLICATION pub1 OWNER TO
[14:07:08.111](0.000s) ok 1664 - defaults: should dump ALTER PUBLICATION pub3 ADD TABLE test_table
[14:07:08.111](0.000s) ok 1665 - defaults: should dump ALTER PUBLICATION pub3 ADD TABLES IN SCHEMA dump_test
[14:07:08.112](0.000s) ok 1666 - defaults: should dump ALTER PUBLICATION pub3 ADD TABLES IN SCHEMA public
[14:07:08.112](0.000s) ok 1667 - defaults: should dump ALTER PUBLICATION pub4 ADD TABLE test_second_table WHERE (col2 = 'test');
[14:07:08.112](0.000s) ok 1668 - defaults: should dump ALTER PUBLICATION pub4 ADD TABLE test_table WHERE (col1 > 0);
[14:07:08.112](0.000s) ok 1669 - defaults: should not dump ALTER ROLE regress_dump_test_role
[14:07:08.113](0.000s) ok 1670 - defaults: should dump ALTER SCHEMA dump_test OWNER TO
[14:07:08.113](0.000s) ok 1671 - defaults: should dump ALTER SCHEMA dump_test_second_schema OWNER TO
[14:07:08.113](0.000s) ok 1672 - defaults: should dump ALTER SCHEMA public OWNER TO
[14:07:08.114](0.000s) ok 1673 - defaults: should dump ALTER SEQUENCE test_table_col1_seq
[14:07:08.114](0.000s) ok 1674 - defaults: should dump ALTER SERVER s1 OWNER TO
[14:07:08.114](0.000s) ok 1675 - defaults: should dump ALTER STATISTICS extended_stats_options
[14:07:08.115](0.000s) ok 1676 - defaults: should dump ALTER TABLE (partitioned) ADD CONSTRAINT ... FOREIGN KEY
[14:07:08.115](0.000s) ok 1677 - defaults: should dump ALTER TABLE ONLY dump_test.measurement ATTACH PARTITION measurement_y2006m2
[14:07:08.115](0.000s) ok 1678 - defaults: should dump ALTER TABLE ONLY test_table ADD CONSTRAINT ... PRIMARY KEY
[14:07:08.115](0.000s) ok 1679 - defaults: should dump ALTER TABLE ONLY test_table ALTER COLUMN col1 SET STATISTICS 90
[14:07:08.116](0.000s) ok 1680 - defaults: should dump ALTER TABLE ONLY test_table ALTER COLUMN col2 SET STORAGE
[14:07:08.116](0.000s) ok 1681 - defaults: should dump ALTER TABLE ONLY test_table ALTER COLUMN col3 SET STORAGE
[14:07:08.116](0.000s) ok 1682 - defaults: should dump ALTER TABLE ONLY test_table ALTER COLUMN col4 SET n_distinct
[14:07:08.116](0.000s) ok 1683 - defaults: should dump ALTER TABLE measurement OWNER TO
[14:07:08.117](0.001s) ok 1684 - defaults: should dump ALTER TABLE measurement PRIMARY KEY
[14:07:08.117](0.000s) ok 1685 - defaults: should dump ALTER TABLE measurement_y2006m2 OWNER TO
[14:07:08.117](0.000s) ok 1686 - defaults: should dump ALTER TABLE test_second_table OWNER TO
[14:07:08.118](0.000s) ok 1687 - defaults: should dump ALTER TABLE test_table CLUSTER ON test_table_pkey
[14:07:08.118](0.000s) ok 1688 - defaults: should not dump ALTER TABLE test_table DISABLE TRIGGER ALL
[14:07:08.119](0.000s) ok 1689 - defaults: should dump ALTER TABLE test_table ENABLE ROW LEVEL SECURITY
[14:07:08.119](0.000s) ok 1690 - defaults: should dump ALTER TABLE test_table OWNER TO
[14:07:08.119](0.000s) ok 1691 - defaults: should not dump ALTER TABLE test_table_generated_child1
[14:07:08.119](0.000s) ok 1692 - defaults: should dump ALTER TEXT SEARCH CONFIGURATION alt_ts_conf1 OWNER TO
[14:07:08.120](0.000s) ok 1693 - defaults: should dump ALTER TEXT SEARCH CONFIGURATION dump_test.alt_ts_conf1 ...
[14:07:08.120](0.000s) ok 1694 - defaults: should dump ALTER TEXT SEARCH DICTIONARY alt_ts_dict1 OWNER TO
[14:07:08.121](0.000s) ok 1695 - defaults: should dump ALTER VIEW test_view SET DEFAULT
[14:07:08.121](0.000s) ok 1696 - defaults: should dump Always trigger on partition is altered
[14:07:08.121](0.000s) ok 1697 - defaults: should dump COMMENT ON COLLATION test0
[14:07:08.122](0.000s) ok 1698 - defaults: should dump COMMENT ON COLUMN dump_test.composite.f1
[14:07:08.122](0.000s) ok 1699 - defaults: should dump COMMENT ON COLUMN dump_test.test_second_table.col1
[14:07:08.122](0.000s) ok 1700 - defaults: should dump COMMENT ON COLUMN dump_test.test_second_table.col2
[14:07:08.123](0.000s) ok 1701 - defaults: should dump COMMENT ON COLUMN dump_test.test_table.col1
[14:07:08.123](0.000s) ok 1702 - defaults: should dump COMMENT ON CONSTRAINT ON DOMAIN (1)
[14:07:08.123](0.000s) ok 1703 - defaults: should dump COMMENT ON CONSTRAINT ON DOMAIN (2)
[14:07:08.124](0.000s) ok 1704 - defaults: should dump COMMENT ON CONSTRAINT ON test_table_chld2
[14:07:08.124](0.000s) ok 1705 - defaults: should dump COMMENT ON CONSTRAINT ON test_table_nn
[14:07:08.125](0.000s) ok 1706 - defaults: should dump COMMENT ON CONVERSION dump_test.test_conversion
[14:07:08.125](0.000s) ok 1707 - defaults: should not dump COMMENT ON DATABASE postgres
[14:07:08.126](0.001s) ok 1708 - defaults: should not dump COMMENT ON EXTENSION plpgsql
[14:07:08.126](0.001s) ok 1709 - defaults: should dump COMMENT ON LARGE OBJECT ...
[14:07:08.127](0.000s) ok 1710 - defaults: should dump COMMENT ON POLICY p1
[14:07:08.127](0.000s) ok 1711 - defaults: should dump COMMENT ON PUBLICATION pub1
[14:07:08.127](0.000s) ok 1712 - defaults: should not dump COMMENT ON SCHEMA public
[14:07:08.128](0.000s) ok 1713 - defaults: should dump COMMENT ON SUBSCRIPTION sub1
[14:07:08.128](0.000s) ok 1714 - defaults: should dump COMMENT ON TABLE dump_test.test_table
[14:07:08.128](0.000s) ok 1715 - defaults: should dump COMMENT ON TEXT SEARCH CONFIGURATION dump_test.alt_ts_conf1
[14:07:08.129](0.001s) ok 1716 - defaults: should dump COMMENT ON TEXT SEARCH DICTIONARY dump_test.alt_ts_dict1
[14:07:08.129](0.000s) ok 1717 - defaults: should dump COMMENT ON TEXT SEARCH PARSER dump_test.alt_ts_prs1
[14:07:08.130](0.001s) ok 1718 - defaults: should dump COMMENT ON TEXT SEARCH TEMPLATE dump_test.alt_ts_temp1
[14:07:08.130](0.000s) ok 1719 - defaults: should dump COMMENT ON TYPE dump_test.int42 - Regular
[14:07:08.130](0.000s) ok 1720 - defaults: should dump COMMENT ON TYPE dump_test.planets - ENUM
[14:07:08.130](0.000s) ok 1721 - defaults: should dump COMMENT ON TYPE dump_test.textrange - RANGE
[14:07:08.131](0.000s) ok 1722 - defaults: should dump COMMENT ON TYPE dump_test.undefined - Undefined
[14:07:08.131](0.000s) ok 1723 - defaults: should dump CONSTRAINT NOT NULL / NO INHERIT
[14:07:08.131](0.000s) ok 1724 - defaults: should dump CONSTRAINT NOT NULL / NO INHERIT (child1)
[14:07:08.131](0.000s) ok 1725 - defaults: should dump CONSTRAINT NOT NULL / NOT VALID
[14:07:08.132](0.000s) ok 1726 - defaults: should dump CONSTRAINT NOT NULL / NOT VALID (child1)
[14:07:08.132](0.000s) ok 1727 - defaults: should dump CONSTRAINT NOT NULL / NOT VALID (child2)
[14:07:08.132](0.000s) ok 1728 - defaults: should dump CONSTRAINT NOT NULL / NOT VALID (child3)
[14:07:08.132](0.000s) ok 1729 - defaults: should dump CONSTRAINT PRIMARY KEY / WITHOUT OVERLAPS
[14:07:08.133](0.001s) ok 1730 - defaults: should dump CONSTRAINT UNIQUE / WITHOUT OVERLAPS
[14:07:08.133](0.000s) ok 1731 - defaults: should dump COPY fk_reference_test_table
[14:07:08.133](0.000s) ok 1732 - defaults: should not dump COPY fk_reference_test_table second
[14:07:08.134](0.000s) ok 1733 - defaults: should dump COPY measurement
[14:07:08.134](0.000s) ok 1734 - defaults: should dump COPY test_fifth_table
[14:07:08.134](0.000s) ok 1735 - defaults: should dump COPY test_fourth_table
[14:07:08.134](0.000s) ok 1736 - defaults: should dump COPY test_second_table
[14:07:08.135](0.000s) ok 1737 - defaults: should dump COPY test_table
[14:07:08.135](0.000s) ok 1738 - defaults: should dump COPY test_table_identity
[14:07:08.135](0.000s) ok 1739 - defaults: should dump COPY test_third_table
[14:07:08.136](0.000s) ok 1740 - defaults: should dump CREATE ACCESS METHOD gist2
[14:07:08.136](0.000s) ok 1741 - defaults: should dump CREATE ACCESS METHOD regress_test_table_am
[14:07:08.136](0.000s) ok 1742 - defaults: should dump CREATE AGGREGATE dump_test.newavg
[14:07:08.137](0.000s) ok 1743 - defaults: should dump CREATE CAST FOR timestamptz
[14:07:08.137](0.000s) ok 1744 - defaults: should dump CREATE COLLATION test0 FROM "C"
[14:07:08.137](0.000s) ok 1745 - defaults: should dump CREATE CONVERSION dump_test.test_conversion
[14:07:08.137](0.000s) ok 1746 - defaults: should not dump CREATE DATABASE dump_test
[14:07:08.138](0.000s) ok 1747 - defaults: should not dump CREATE DATABASE dump_test2 LOCALE = 'C'
[14:07:08.138](0.000s) ok 1748 - defaults: should not dump CREATE DATABASE postgres
[14:07:08.139](0.000s) ok 1749 - defaults: should not dump CREATE DATABASE regression_invalid...
[14:07:08.141](0.003s) ok 1750 - defaults: should dump CREATE DOMAIN dump_test.us_postal_code
[14:07:08.142](0.001s) ok 1751 - defaults: should dump CREATE EVENT TRIGGER test_event_trigger
[14:07:08.143](0.001s) ok 1752 - defaults: should not dump CREATE EXTENSION ... plpgsql
[14:07:08.143](0.000s) ok 1753 - defaults: should dump CREATE FOREIGN DATA WRAPPER dummy
[14:07:08.143](0.000s) ok 1754 - defaults: should dump CREATE FOREIGN TABLE dump_test.foreign_table SERVER s1
[14:07:08.144](0.000s) ok 1755 - defaults: should dump CREATE FUNCTION ... SUPPORT
[14:07:08.144](0.000s) ok 1756 - defaults: should dump CREATE FUNCTION dump_test.event_trigger_func
[14:07:08.144](0.000s) ok 1757 - defaults: should dump CREATE FUNCTION dump_test.int42_in
[14:07:08.145](0.000s) ok 1758 - defaults: should dump CREATE FUNCTION dump_test.int42_out
[14:07:08.145](0.000s) ok 1759 - defaults: should dump CREATE FUNCTION dump_test.pltestlang_call_handler
[14:07:08.146](0.000s) ok 1760 - defaults: should dump CREATE FUNCTION dump_test.trigger_func
[14:07:08.146](0.000s) ok 1761 - defaults: should dump CREATE INDEX ... ON measurement_y2006_m2
[14:07:08.147](0.001s) ok 1762 - defaults: should dump CREATE INDEX ON ONLY measurement
[14:07:08.147](0.000s) ok 1763 - defaults: should dump CREATE LANGUAGE pltestlang
[14:07:08.147](0.000s) ok 1764 - defaults: should dump CREATE MATERIALIZED VIEW matview
[14:07:08.147](0.000s) ok 1765 - defaults: should dump CREATE MATERIALIZED VIEW matview_fourth
[14:07:08.148](0.000s) ok 1766 - defaults: should dump CREATE MATERIALIZED VIEW matview_second
[14:07:08.148](0.000s) ok 1767 - defaults: should dump CREATE MATERIALIZED VIEW matview_third
[14:07:08.149](0.000s) ok 1768 - defaults: should dump CREATE MATERIALIZED VIEW regress_pg_dump_matview_am
[14:07:08.149](0.000s) ok 1769 - defaults: should dump CREATE OPERATOR CLASS dump_test.op_class
[14:07:08.151](0.002s) ok 1770 - defaults: should dump CREATE OPERATOR CLASS dump_test.op_class_custom
[14:07:08.151](0.000s) ok 1771 - defaults: should dump CREATE OPERATOR CLASS dump_test.op_class_empty
[14:07:08.151](0.000s) ok 1772 - defaults: should dump CREATE OPERATOR FAMILY dump_test.op_family
[14:07:08.152](0.000s) ok 1773 - defaults: should dump CREATE POLICY p1 ON test_table
[14:07:08.152](0.000s) ok 1774 - defaults: should dump CREATE POLICY p2 ON test_table FOR SELECT
[14:07:08.152](0.000s) ok 1775 - defaults: should dump CREATE POLICY p3 ON test_table FOR INSERT
[14:07:08.153](0.000s) ok 1776 - defaults: should dump CREATE POLICY p4 ON test_table FOR UPDATE
[14:07:08.153](0.000s) ok 1777 - defaults: should dump CREATE POLICY p5 ON test_table FOR DELETE
[14:07:08.153](0.001s) ok 1778 - defaults: should dump CREATE POLICY p6 ON test_table AS RESTRICTIVE
[14:07:08.154](0.001s) ok 1779 - defaults: should dump CREATE PROCEDURE dump_test.ptest1
[14:07:08.154](0.000s) ok 1780 - defaults: should dump CREATE PROPERTY GRAPH propgraph
[14:07:08.155](0.000s) ok 1781 - defaults: should dump CREATE PUBLICATION pub1
[14:07:08.155](0.000s) ok 1782 - defaults: should dump CREATE PUBLICATION pub10
[14:07:08.155](0.000s) ok 1783 - defaults: should dump CREATE PUBLICATION pub2
[14:07:08.156](0.001s) ok 1784 - defaults: should dump CREATE PUBLICATION pub3
[14:07:08.156](0.000s) ok 1785 - defaults: should dump CREATE PUBLICATION pub4
[14:07:08.157](0.000s) ok 1786 - defaults: should dump CREATE PUBLICATION pub5
[14:07:08.157](0.000s) ok 1787 - defaults: should dump CREATE PUBLICATION pub6
[14:07:08.157](0.000s) ok 1788 - defaults: should dump CREATE PUBLICATION pub7
[14:07:08.158](0.000s) ok 1789 - defaults: should dump CREATE PUBLICATION pub8
[14:07:08.158](0.000s) ok 1790 - defaults: should dump CREATE PUBLICATION pub9
[14:07:08.159](0.000s) ok 1791 - defaults: should not dump CREATE ROLE regress_dump_test_role
[14:07:08.159](0.000s) ok 1792 - defaults: should not dump CREATE ROLE regress_quoted...
[14:07:08.159](0.000s) ok 1793 - defaults: should dump CREATE SCHEMA dump_test
[14:07:08.159](0.000s) ok 1794 - defaults: should dump CREATE SCHEMA dump_test_second_schema
[14:07:08.160](0.000s) ok 1795 - defaults: should not dump CREATE SCHEMA public
[14:07:08.160](0.000s) ok 1796 - defaults: should dump CREATE SEQUENCE test_table_col1_seq
[14:07:08.161](0.000s) ok 1797 - defaults: should dump CREATE SERVER s1 FOREIGN DATA WRAPPER dummy
[14:07:08.161](0.000s) ok 1798 - defaults: should dump CREATE STATISTICS extended_stats_expression
[14:07:08.161](0.000s) ok 1799 - defaults: should dump CREATE STATISTICS extended_stats_no_options
[14:07:08.162](0.000s) ok 1800 - defaults: should dump CREATE STATISTICS extended_stats_options
[14:07:08.162](0.000s) ok 1801 - defaults: should dump CREATE SUBSCRIPTION sub1
[14:07:08.163](0.000s) ok 1802 - defaults: should dump CREATE SUBSCRIPTION sub2
[14:07:08.163](0.001s) ok 1803 - defaults: should dump CREATE SUBSCRIPTION sub3
[14:07:08.163](0.000s) ok 1804 - defaults: should dump CREATE TABLE fk_reference_test_table
[14:07:08.164](0.000s) ok 1805 - defaults: should dump CREATE TABLE measurement PARTITIONED BY
[14:07:08.164](0.000s) ok 1806 - defaults: should dump CREATE TABLE regress_pg_dump_table_am
[14:07:08.173](0.009s) ok 1807 - defaults: should dump CREATE TABLE regress_pg_dump_table_part
[14:07:08.174](0.000s) ok 1808 - defaults: should dump CREATE TABLE table_with_stats
[14:07:08.174](0.000s) ok 1809 - defaults: should dump CREATE TABLE test_fifth_table
[14:07:08.174](0.000s) ok 1810 - defaults: should dump CREATE TABLE test_fourth_table_zero_col
[14:07:08.175](0.000s) ok 1811 - defaults: should dump CREATE TABLE test_inheritance_child
[14:07:08.175](0.000s) ok 1812 - defaults: should dump CREATE TABLE test_inheritance_parent
[14:07:08.176](0.000s) ok 1813 - defaults: should dump CREATE TABLE test_second_table
[14:07:08.176](0.000s) ok 1814 - defaults: should dump CREATE TABLE test_seventh_table
[14:07:08.176](0.000s) ok 1815 - defaults: should dump CREATE TABLE test_sixth_table
[14:07:08.179](0.003s) ok 1816 - defaults: should dump CREATE TABLE test_table
[14:07:08.180](0.000s) ok 1817 - defaults: should dump CREATE TABLE test_table_generated
[14:07:08.180](0.000s) ok 1818 - defaults: should dump CREATE TABLE test_table_generated_child1 (without local columns)
[14:07:08.180](0.000s) ok 1819 - defaults: should dump CREATE TABLE test_table_generated_child2 (with local columns)
[14:07:08.181](0.001s) ok 1820 - defaults: should dump CREATE TABLE test_table_identity
[14:07:08.182](0.001s) ok 1821 - defaults: should dump CREATE TABLE test_third_table_generated_cols
[14:07:08.183](0.000s) ok 1822 - defaults: should not dump CREATE TABLESPACE regress_dump_tablespace
[14:07:08.183](0.000s) ok 1823 - defaults: should dump CREATE TEXT SEARCH CONFIGURATION dump_test.alt_ts_conf1
[14:07:08.183](0.000s) ok 1824 - defaults: should dump CREATE TEXT SEARCH DICTIONARY dump_test.alt_ts_dict1
[14:07:08.184](0.000s) ok 1825 - defaults: should dump CREATE TEXT SEARCH PARSER dump_test.alt_ts_prs1
[14:07:08.184](0.000s) ok 1826 - defaults: should dump CREATE TEXT SEARCH TEMPLATE dump_test.alt_ts_temp1
[14:07:08.184](0.000s) ok 1827 - defaults: should dump CREATE TRANSFORM FOR int
[14:07:08.185](0.000s) ok 1828 - defaults: should dump CREATE TRIGGER test_trigger
[14:07:08.185](0.000s) ok 1829 - defaults: should dump CREATE TYPE dump_test.composite
[14:07:08.185](0.000s) ok 1830 - defaults: should dump CREATE TYPE dump_test.int42
[14:07:08.186](0.000s) ok 1831 - defaults: should dump CREATE TYPE dump_test.int42 populated
[14:07:08.186](0.000s) ok 1832 - defaults: should dump CREATE TYPE dump_test.planets AS ENUM
[14:07:08.187](0.000s) ok 1833 - defaults: should not dump CREATE TYPE dump_test.planets AS ENUM pg_upgrade
[14:07:08.187](0.000s) ok 1834 - defaults: should dump CREATE TYPE dump_test.textrange AS RANGE
[14:07:08.187](0.000s) ok 1835 - defaults: should dump CREATE TYPE dump_test.undefined
[14:07:08.188](0.000s) ok 1836 - defaults: should dump CREATE USER MAPPING FOR regress_dump_test_role SERVER s1
[14:07:08.188](0.000s) ok 1837 - defaults: should dump CREATE VIEW test_view
[14:07:08.189](0.001s) ok 1838 - defaults: should dump Check ordering of a function that depends on a primary key
[14:07:08.190](0.001s) ok 1839 - defaults: should dump Check ordering of a matview that depends on a primary key
[14:07:08.192](0.002s) ok 1840 - defaults: should dump Creation of row-level trigger in partitioned table
[14:07:08.192](0.000s) ok 1841 - defaults: should not dump DROP EXTENSION IF EXISTS plpgsql
[14:07:08.192](0.000s) ok 1842 - defaults: should not dump DROP EXTENSION plpgsql
[14:07:08.193](0.000s) ok 1843 - defaults: should not dump DROP FUNCTION IF EXISTS dump_test.pltestlang_call_handler()
[14:07:08.193](0.000s) ok 1844 - defaults: should not dump DROP FUNCTION dump_test.pltestlang_call_handler()
[14:07:08.193](0.000s) ok 1845 - defaults: should not dump DROP LANGUAGE IF EXISTS pltestlang
[14:07:08.194](0.000s) ok 1846 - defaults: should not dump DROP LANGUAGE pltestlang
[14:07:08.194](0.001s) ok 1847 - defaults: should not dump DROP ROLE pg_
[14:07:08.195](0.000s) ok 1848 - defaults: should not dump DROP ROLE regress_dump_test_role
[14:07:08.195](0.000s) ok 1849 - defaults: should not dump DROP SCHEMA IF EXISTS dump_test
[14:07:08.196](0.000s) ok 1850 - defaults: should not dump DROP SCHEMA IF EXISTS dump_test_second_schema
[14:07:08.196](0.000s) ok 1851 - defaults: should not dump DROP SCHEMA IF EXISTS public
[14:07:08.196](0.000s) ok 1852 - defaults: should not dump DROP SCHEMA dump_test
[14:07:08.197](0.000s) ok 1853 - defaults: should not dump DROP SCHEMA dump_test_second_schema
[14:07:08.197](0.000s) ok 1854 - defaults: should not dump DROP SCHEMA public
[14:07:08.198](0.000s) ok 1855 - defaults: should not dump DROP TABLE IF EXISTS test_second_table
[14:07:08.198](0.000s) ok 1856 - defaults: should not dump DROP TABLE IF EXISTS test_table
[14:07:08.199](0.000s) ok 1857 - defaults: should not dump DROP TABLE fk_reference_test_table
[14:07:08.199](0.000s) ok 1858 - defaults: should not dump DROP TABLE test_second_table
[14:07:08.199](0.000s) ok 1859 - defaults: should not dump DROP TABLE test_table
[14:07:08.200](0.000s) ok 1860 - defaults: should dump Disabled trigger on partition is altered
[14:07:08.200](0.000s) ok 1861 - defaults: should not dump Disabled trigger on partition is not created
[14:07:08.201](0.000s) ok 1862 - defaults: should dump GRANT ALL ON LARGE OBJECT ...
[14:07:08.201](0.000s) ok 1863 - defaults: should not dump GRANT CREATE ON DATABASE dump_test
[14:07:08.201](0.000s) ok 1864 - defaults: should dump GRANT EXECUTE ON FUNCTION pg_sleep() TO regress_dump_test_role
[14:07:08.202](0.000s) ok 1865 - defaults: should dump GRANT INSERT(col1) ON TABLE test_second_table
[14:07:08.208](0.006s) ok 1866 - defaults: should dump GRANT SELECT (proname ...) ON TABLE pg_proc TO public
[14:07:08.209](0.001s) ok 1867 - defaults: should dump GRANT SELECT ON PROPERTY GRAPH propgraph
[14:07:08.210](0.001s) ok 1868 - defaults: should dump GRANT SELECT ON TABLE measurement
[14:07:08.210](0.000s) ok 1869 - defaults: should dump GRANT SELECT ON TABLE measurement_y2006m2
[14:07:08.210](0.000s) ok 1870 - defaults: should dump GRANT SELECT ON TABLE test_table
[14:07:08.211](0.000s) ok 1871 - defaults: should dump GRANT USAGE ON DOMAIN dump_test.us_postal_code
[14:07:08.211](0.000s) ok 1872 - defaults: should dump GRANT USAGE ON FOREIGN DATA WRAPPER dummy
[14:07:08.211](0.000s) ok 1873 - defaults: should dump GRANT USAGE ON FOREIGN SERVER s1
[14:07:08.212](0.000s) ok 1874 - defaults: should dump GRANT USAGE ON SCHEMA dump_test_second_schema
[14:07:08.212](0.000s) ok 1875 - defaults: should not dump GRANT USAGE ON SCHEMA public TO public
[14:07:08.212](0.000s) ok 1876 - defaults: should dump GRANT USAGE ON TYPE dump_test.int42
[14:07:08.213](0.000s) ok 1877 - defaults: should dump GRANT USAGE ON TYPE dump_test.planets - ENUM
[14:07:08.213](0.000s) ok 1878 - defaults: should dump GRANT USAGE ON TYPE dump_test.textrange - RANGE
[14:07:08.213](0.000s) ok 1879 - defaults: should not dump INSERT INTO test_fifth_table
[14:07:08.214](0.000s) ok 1880 - defaults: should not dump INSERT INTO test_fourth_table
[14:07:08.214](0.000s) ok 1881 - defaults: should not dump INSERT INTO test_second_table
[14:07:08.214](0.000s) ok 1882 - defaults: should not dump INSERT INTO test_table
[14:07:08.215](0.001s) ok 1883 - defaults: should not dump INSERT INTO test_table_identity
[14:07:08.215](0.000s) ok 1884 - defaults: should not dump INSERT INTO test_third_table
[14:07:08.215](0.000s) ok 1885 - defaults: should not dump INSERT INTO test_third_table (colnames)
[14:07:08.216](0.000s) ok 1886 - defaults: should dump LO create (using lo_from_bytea)
[14:07:08.216](0.000s) ok 1887 - defaults: should dump LO create (with no data)
[14:07:08.217](0.000s) ok 1888 - defaults: should dump LO load (using lo_from_bytea)
[14:07:08.217](0.000s) ok 1889 - defaults: should dump Partition measurement_y2006m2 creation
[14:07:08.218](0.000s) ok 1890 - defaults: should dump REFRESH MATERIALIZED VIEW matview
[14:07:08.219](0.001s) ok 1891 - defaults: should not dump REFRESH MATERIALIZED VIEW matview_fourth
[14:07:08.219](0.000s) ok 1892 - defaults: should dump REFRESH MATERIALIZED VIEW matview_second
[14:07:08.219](0.000s) ok 1893 - defaults: should not dump REFRESH MATERIALIZED VIEW matview_third
[14:07:08.220](0.000s) ok 1894 - defaults: should dump REVOKE ALL ON SCHEMA public
[14:07:08.220](0.000s) ok 1895 - defaults: should not dump REVOKE CONNECT ON DATABASE dump_test FROM public
[14:07:08.221](0.000s) ok 1896 - defaults: should dump REVOKE EXECUTE ON FUNCTION pg_sleep() FROM public
[14:07:08.259](0.039s) ok 1897 - defaults: should not dump REVOKE EXECUTE ON FUNCTION pg_stat_reset FROM regress_dump_test_role
[14:07:08.260](0.000s) ok 1898 - defaults: should dump REVOKE SELECT ON TABLE pg_proc FROM public
[14:07:08.260](0.000s) ok 1899 - defaults: should dump REVOKE USAGE ON LANGUAGE plpgsql FROM public
[14:07:08.260](0.000s) ok 1900 - defaults: should dump Replica trigger on partition is altered
[14:07:08.260](0.000s) ok 1901 - defaults: should not dump Triggers on partitions are not dropped
[14:07:08.261](0.000s) ok 1902 - defaults: should dump extended_statistics_import
[14:07:08.261](0.001s) ok 1903 - defaults: should not dump newline of table name in comment
[14:07:08.262](0.000s) ok 1904 - defaults: should dump relstats_on_unanalyzed_tables
[14:07:08.262](0.000s) ok 1905 - defaults: should dump restrict
[14:07:08.263](0.001s) ok 1906 - defaults: should dump statistics_import
[14:07:08.263](0.000s) ok 1907 - defaults: should not dump test_table with 4-row INSERTs
[14:07:08.264](0.000s) ok 1908 - defaults: should dump unrestrict
[14:07:08.264](0.001s) # skipping run defaults_complex_pipe
# Running: pg_dump --format custom --file C:\cirrus\build\testrun\pg_dump\002_pg_dump\data\tmp_test_9UIx/defaults_custom_format.dump --statistics postgres
[14:07:09.070](0.806s) ok 1909 - defaults_custom_format: pg_dump runs
# Running: pg_restore --list C:\cirrus\build\testrun\pg_dump\002_pg_dump\data\tmp_test_9UIx/defaults_custom_format.dump
[14:07:09.132](0.062s) ok 1910 - defaults_custom_format: data content is gzip-compressed by default if available: exit code 0
[14:07:09.133](0.001s) ok 1911 - defaults_custom_format: data content is gzip-compressed by default if available: no stderr
[14:07:09.134](0.001s) ok 1912 - defaults_custom_format: data content is gzip-compressed by default if available: matches
# Running: pg_restore --format custom --file C:\cirrus\build\testrun\pg_dump\002_pg_dump\data\tmp_test_9UIx/defaults_custom_format.sql --statistics C:\cirrus\build\testrun\pg_dump\002_pg_dump\data\tmp_test_9UIx/defaults_custom_format.dump
[14:07:09.196](0.062s) ok 1913 - defaults_custom_format: pg_restore runs
[14:07:09.201](0.005s) ok 1914 - defaults_custom_format: should dump ALTER COLLATION test0 OWNER TO
[14:07:09.201](0.001s) ok 1915 - defaults_custom_format: should dump ALTER DEFAULT PRIVILEGES FOR ROLE regress_dump_test_role GRANT
[14:07:09.202](0.000s) ok 1916 - defaults_custom_format: should dump ALTER DEFAULT PRIVILEGES FOR ROLE regress_dump_test_role GRANT EXECUTE ON FUNCTIONS
[14:07:09.202](0.000s) ok 1917 - defaults_custom_format: should dump ALTER DEFAULT PRIVILEGES FOR ROLE regress_dump_test_role REVOKE
[14:07:09.203](0.001s) ok 1918 - defaults_custom_format: should dump ALTER DEFAULT PRIVILEGES FOR ROLE regress_dump_test_role REVOKE SELECT
[14:07:09.203](0.000s) ok 1919 - defaults_custom_format: should dump ALTER FOREIGN DATA WRAPPER dummy OWNER TO
[14:07:09.204](0.000s) ok 1920 - defaults_custom_format: should dump ALTER FOREIGN TABLE foreign_table ALTER COLUMN c1 OPTIONS
[14:07:09.204](0.000s) ok 1921 - defaults_custom_format: should dump ALTER FOREIGN TABLE foreign_table OWNER TO
[14:07:09.205](0.000s) ok 1922 - defaults_custom_format: should dump ALTER FUNCTION dump_test.pltestlang_call_handler() OWNER TO
[14:07:09.205](0.001s) ok 1923 - defaults_custom_format: should dump ALTER INDEX ... ATTACH PARTITION
[14:07:09.205](0.000s) ok 1924 - defaults_custom_format: should dump ALTER INDEX ... ATTACH PARTITION (primary key)
[14:07:09.206](0.001s) ok 1925 - defaults_custom_format: should dump ALTER LARGE OBJECT ... OWNER TO
[14:07:09.206](0.001s) ok 1926 - defaults_custom_format: should dump ALTER OPERATOR CLASS dump_test.op_class OWNER TO
[14:07:09.207](0.000s) ok 1927 - defaults_custom_format: should dump ALTER OPERATOR FAMILY dump_test.op_family OWNER TO
[14:07:09.207](0.000s) ok 1928 - defaults_custom_format: should dump ALTER OPERATOR FAMILY dump_test.op_family USING btree
[14:07:09.208](0.000s) ok 1929 - defaults_custom_format: should dump ALTER PROCEDURAL LANGUAGE pltestlang OWNER TO
[14:07:09.208](0.000s) ok 1930 - defaults_custom_format: should dump ALTER PUBLICATION pub1 ADD TABLE test_second_table
[14:07:09.208](0.000s) ok 1931 - defaults_custom_format: should dump ALTER PUBLICATION pub1 ADD TABLE test_seventh_table (col3, col2) WHERE (col1 = 1)
[14:07:09.209](0.000s) ok 1932 - defaults_custom_format: should dump ALTER PUBLICATION pub1 ADD TABLE test_sixth_table (col3, col2)
[14:07:09.209](0.001s) ok 1933 - defaults_custom_format: should dump ALTER PUBLICATION pub1 ADD TABLE test_table
[14:07:09.210](0.001s) ok 1934 - defaults_custom_format: should dump ALTER PUBLICATION pub1 OWNER TO
[14:07:09.210](0.000s) ok 1935 - defaults_custom_format: should dump ALTER PUBLICATION pub3 ADD TABLE test_table
[14:07:09.211](0.000s) ok 1936 - defaults_custom_format: should dump ALTER PUBLICATION pub3 ADD TABLES IN SCHEMA dump_test
[14:07:09.211](0.000s) ok 1937 - defaults_custom_format: should dump ALTER PUBLICATION pub3 ADD TABLES IN SCHEMA public
[14:07:09.211](0.000s) ok 1938 - defaults_custom_format: should dump ALTER PUBLICATION pub4 ADD TABLE test_second_table WHERE (col2 = 'test');
[14:07:09.212](0.000s) ok 1939 - defaults_custom_format: should dump ALTER PUBLICATION pub4 ADD TABLE test_table WHERE (col1 > 0);
[14:07:09.212](0.000s) ok 1940 - defaults_custom_format: should not dump ALTER ROLE regress_dump_test_role
[14:07:09.212](0.000s) ok 1941 - defaults_custom_format: should dump ALTER SCHEMA dump_test OWNER TO
[14:07:09.213](0.000s) ok 1942 - defaults_custom_format: should dump ALTER SCHEMA dump_test_second_schema OWNER TO
[14:07:09.213](0.000s) ok 1943 - defaults_custom_format: should dump ALTER SCHEMA public OWNER TO
[14:07:09.213](0.000s) ok 1944 - defaults_custom_format: should dump ALTER SEQUENCE test_table_col1_seq
[14:07:09.213](0.000s) ok 1945 - defaults_custom_format: should dump ALTER SERVER s1 OWNER TO
[14:07:09.214](0.000s) ok 1946 - defaults_custom_format: should dump ALTER STATISTICS extended_stats_options
[14:07:09.214](0.000s) ok 1947 - defaults_custom_format: should dump ALTER TABLE (partitioned) ADD CONSTRAINT ... FOREIGN KEY
[14:07:09.214](0.000s) ok 1948 - defaults_custom_format: should dump ALTER TABLE ONLY dump_test.measurement ATTACH PARTITION measurement_y2006m2
[14:07:09.215](0.000s) ok 1949 - defaults_custom_format: should dump ALTER TABLE ONLY test_table ADD CONSTRAINT ... PRIMARY KEY
[14:07:09.215](0.000s) ok 1950 - defaults_custom_format: should dump ALTER TABLE ONLY test_table ALTER COLUMN col1 SET STATISTICS 90
[14:07:09.215](0.000s) ok 1951 - defaults_custom_format: should dump ALTER TABLE ONLY test_table ALTER COLUMN col2 SET STORAGE
[14:07:09.215](0.000s) ok 1952 - defaults_custom_format: should dump ALTER TABLE ONLY test_table ALTER COLUMN col3 SET STORAGE
[14:07:09.216](0.000s) ok 1953 - defaults_custom_format: should dump ALTER TABLE ONLY test_table ALTER COLUMN col4 SET n_distinct
[14:07:09.216](0.000s) ok 1954 - defaults_custom_format: should dump ALTER TABLE measurement OWNER TO
[14:07:09.216](0.000s) ok 1955 - defaults_custom_format: should dump ALTER TABLE measurement PRIMARY KEY
[14:07:09.216](0.000s) ok 1956 - defaults_custom_format: should dump ALTER TABLE measurement_y2006m2 OWNER TO
[14:07:09.217](0.000s) ok 1957 - defaults_custom_format: should dump ALTER TABLE test_second_table OWNER TO
[14:07:09.217](0.000s) ok 1958 - defaults_custom_format: should dump ALTER TABLE test_table CLUSTER ON test_table_pkey
[14:07:09.217](0.000s) ok 1959 - defaults_custom_format: should not dump ALTER TABLE test_table DISABLE TRIGGER ALL
[14:07:09.217](0.000s) ok 1960 - defaults_custom_format: should dump ALTER TABLE test_table ENABLE ROW LEVEL SECURITY
[14:07:09.217](0.000s) ok 1961 - defaults_custom_format: should dump ALTER TABLE test_table OWNER TO
[14:07:09.218](0.000s) ok 1962 - defaults_custom_format: should not dump ALTER TABLE test_table_generated_child1
[14:07:09.218](0.000s) ok 1963 - defaults_custom_format: should dump ALTER TEXT SEARCH CONFIGURATION alt_ts_conf1 OWNER TO
[14:07:09.218](0.000s) ok 1964 - defaults_custom_format: should dump ALTER TEXT SEARCH CONFIGURATION dump_test.alt_ts_conf1 ...
[14:07:09.218](0.000s) ok 1965 - defaults_custom_format: should dump ALTER TEXT SEARCH DICTIONARY alt_ts_dict1 OWNER TO
[14:07:09.219](0.000s) ok 1966 - defaults_custom_format: should dump ALTER VIEW test_view SET DEFAULT
[14:07:09.219](0.000s) ok 1967 - defaults_custom_format: should dump Always trigger on partition is altered
[14:07:09.219](0.000s) ok 1968 - defaults_custom_format: should dump COMMENT ON COLLATION test0
[14:07:09.219](0.000s) ok 1969 - defaults_custom_format: should dump COMMENT ON COLUMN dump_test.composite.f1
[14:07:09.220](0.000s) ok 1970 - defaults_custom_format: should dump COMMENT ON COLUMN dump_test.test_second_table.col1
[14:07:09.220](0.000s) ok 1971 - defaults_custom_format: should dump COMMENT ON COLUMN dump_test.test_second_table.col2
[14:07:09.221](0.000s) ok 1972 - defaults_custom_format: should dump COMMENT ON COLUMN dump_test.test_table.col1
[14:07:09.221](0.000s) ok 1973 - defaults_custom_format: should dump COMMENT ON CONSTRAINT ON DOMAIN (1)
[14:07:09.222](0.000s) ok 1974 - defaults_custom_format: should dump COMMENT ON CONSTRAINT ON DOMAIN (2)
[14:07:09.222](0.000s) ok 1975 - defaults_custom_format: should dump COMMENT ON CONSTRAINT ON test_table_chld2
[14:07:09.222](0.000s) ok 1976 - defaults_custom_format: should dump COMMENT ON CONSTRAINT ON test_table_nn
[14:07:09.222](0.000s) ok 1977 - defaults_custom_format: should dump COMMENT ON CONVERSION dump_test.test_conversion
[14:07:09.223](0.000s) ok 1978 - defaults_custom_format: should not dump COMMENT ON DATABASE postgres
[14:07:09.223](0.000s) ok 1979 - defaults_custom_format: should not dump COMMENT ON EXTENSION plpgsql
[14:07:09.223](0.000s) ok 1980 - defaults_custom_format: should dump COMMENT ON LARGE OBJECT ...
[14:07:09.224](0.000s) ok 1981 - defaults_custom_format: should dump COMMENT ON POLICY p1
[14:07:09.224](0.000s) ok 1982 - defaults_custom_format: should dump COMMENT ON PUBLICATION pub1
[14:07:09.224](0.000s) ok 1983 - defaults_custom_format: should not dump COMMENT ON SCHEMA public
[14:07:09.225](0.000s) ok 1984 - defaults_custom_format: should dump COMMENT ON SUBSCRIPTION sub1
[14:07:09.225](0.000s) ok 1985 - defaults_custom_format: should dump COMMENT ON TABLE dump_test.test_table
[14:07:09.225](0.000s) ok 1986 - defaults_custom_format: should dump COMMENT ON TEXT SEARCH CONFIGURATION dump_test.alt_ts_conf1
[14:07:09.225](0.000s) ok 1987 - defaults_custom_format: should dump COMMENT ON TEXT SEARCH DICTIONARY dump_test.alt_ts_dict1
[14:07:09.226](0.000s) ok 1988 - defaults_custom_format: should dump COMMENT ON TEXT SEARCH PARSER dump_test.alt_ts_prs1
[14:07:09.226](0.000s) ok 1989 - defaults_custom_format: should dump COMMENT ON TEXT SEARCH TEMPLATE dump_test.alt_ts_temp1
[14:07:09.226](0.000s) ok 1990 - defaults_custom_format: should dump COMMENT ON TYPE dump_test.int42 - Regular
[14:07:09.227](0.000s) ok 1991 - defaults_custom_format: should dump COMMENT ON TYPE dump_test.planets - ENUM
[14:07:09.227](0.000s) ok 1992 - defaults_custom_format: should dump COMMENT ON TYPE dump_test.textrange - RANGE
[14:07:09.227](0.000s) ok 1993 - defaults_custom_format: should dump COMMENT ON TYPE dump_test.undefined - Undefined
[14:07:09.228](0.000s) ok 1994 - defaults_custom_format: should dump CONSTRAINT NOT NULL / NO INHERIT
[14:07:09.228](0.000s) ok 1995 - defaults_custom_format: should dump CONSTRAINT NOT NULL / NO INHERIT (child1)
[14:07:09.228](0.000s) ok 1996 - defaults_custom_format: should dump CONSTRAINT NOT NULL / NOT VALID
[14:07:09.229](0.000s) ok 1997 - defaults_custom_format: should dump CONSTRAINT NOT NULL / NOT VALID (child1)
[14:07:09.229](0.000s) ok 1998 - defaults_custom_format: should dump CONSTRAINT NOT NULL / NOT VALID (child2)
[14:07:09.229](0.000s) ok 1999 - defaults_custom_format: should dump CONSTRAINT NOT NULL / NOT VALID (child3)
[14:07:09.230](0.000s) ok 2000 - defaults_custom_format: should dump CONSTRAINT PRIMARY KEY / WITHOUT OVERLAPS
[14:07:09.230](0.000s) ok 2001 - defaults_custom_format: should dump CONSTRAINT UNIQUE / WITHOUT OVERLAPS
[14:07:09.231](0.000s) ok 2002 - defaults_custom_format: should dump COPY fk_reference_test_table
[14:07:09.231](0.000s) ok 2003 - defaults_custom_format: should not dump COPY fk_reference_test_table second
[14:07:09.231](0.000s) ok 2004 - defaults_custom_format: should dump COPY measurement
[14:07:09.232](0.000s) ok 2005 - defaults_custom_format: should dump COPY test_fifth_table
[14:07:09.232](0.000s) ok 2006 - defaults_custom_format: should dump COPY test_fourth_table
[14:07:09.232](0.000s) ok 2007 - defaults_custom_format: should dump COPY test_second_table
[14:07:09.233](0.000s) ok 2008 - defaults_custom_format: should dump COPY test_table
[14:07:09.233](0.000s) ok 2009 - defaults_custom_format: should dump COPY test_table_identity
[14:07:09.233](0.000s) ok 2010 - defaults_custom_format: should dump COPY test_third_table
[14:07:09.234](0.000s) ok 2011 - defaults_custom_format: should dump CREATE ACCESS METHOD gist2
[14:07:09.234](0.000s) ok 2012 - defaults_custom_format: should dump CREATE ACCESS METHOD regress_test_table_am
[14:07:09.234](0.000s) ok 2013 - defaults_custom_format: should dump CREATE AGGREGATE dump_test.newavg
[14:07:09.235](0.000s) ok 2014 - defaults_custom_format: should dump CREATE CAST FOR timestamptz
[14:07:09.235](0.000s) ok 2015 - defaults_custom_format: should dump CREATE COLLATION test0 FROM "C"
[14:07:09.235](0.000s) ok 2016 - defaults_custom_format: should dump CREATE CONVERSION dump_test.test_conversion
[14:07:09.236](0.000s) ok 2017 - defaults_custom_format: should not dump CREATE DATABASE dump_test
[14:07:09.236](0.000s) ok 2018 - defaults_custom_format: should not dump CREATE DATABASE dump_test2 LOCALE = 'C'
[14:07:09.236](0.000s) ok 2019 - defaults_custom_format: should not dump CREATE DATABASE postgres
[14:07:09.237](0.000s) ok 2020 - defaults_custom_format: should not dump CREATE DATABASE regression_invalid...
[14:07:09.239](0.003s) ok 2021 - defaults_custom_format: should dump CREATE DOMAIN dump_test.us_postal_code
[14:07:09.240](0.000s) ok 2022 - defaults_custom_format: should dump CREATE EVENT TRIGGER test_event_trigger
[14:07:09.240](0.000s) ok 2023 - defaults_custom_format: should not dump CREATE EXTENSION ... plpgsql
[14:07:09.240](0.000s) ok 2024 - defaults_custom_format: should dump CREATE FOREIGN DATA WRAPPER dummy
[14:07:09.241](0.000s) ok 2025 - defaults_custom_format: should dump CREATE FOREIGN TABLE dump_test.foreign_table SERVER s1
[14:07:09.241](0.000s) ok 2026 - defaults_custom_format: should dump CREATE FUNCTION ... SUPPORT
[14:07:09.241](0.000s) ok 2027 - defaults_custom_format: should dump CREATE FUNCTION dump_test.event_trigger_func
[14:07:09.241](0.000s) ok 2028 - defaults_custom_format: should dump CREATE FUNCTION dump_test.int42_in
[14:07:09.242](0.000s) ok 2029 - defaults_custom_format: should dump CREATE FUNCTION dump_test.int42_out
[14:07:09.242](0.000s) ok 2030 - defaults_custom_format: should dump CREATE FUNCTION dump_test.pltestlang_call_handler
[14:07:09.242](0.000s) ok 2031 - defaults_custom_format: should dump CREATE FUNCTION dump_test.trigger_func
[14:07:09.242](0.000s) ok 2032 - defaults_custom_format: should dump CREATE INDEX ... ON measurement_y2006_m2
[14:07:09.243](0.000s) ok 2033 - defaults_custom_format: should dump CREATE INDEX ON ONLY measurement
[14:07:09.243](0.000s) ok 2034 - defaults_custom_format: should dump CREATE LANGUAGE pltestlang
[14:07:09.243](0.000s) ok 2035 - defaults_custom_format: should dump CREATE MATERIALIZED VIEW matview
[14:07:09.244](0.000s) ok 2036 - defaults_custom_format: should dump CREATE MATERIALIZED VIEW matview_fourth
[14:07:09.244](0.000s) ok 2037 - defaults_custom_format: should dump CREATE MATERIALIZED VIEW matview_second
[14:07:09.245](0.000s) ok 2038 - defaults_custom_format: should dump CREATE MATERIALIZED VIEW matview_third
[14:07:09.245](0.000s) ok 2039 - defaults_custom_format: should dump CREATE MATERIALIZED VIEW regress_pg_dump_matview_am
[14:07:09.245](0.000s) ok 2040 - defaults_custom_format: should dump CREATE OPERATOR CLASS dump_test.op_class
[14:07:09.247](0.002s) ok 2041 - defaults_custom_format: should dump CREATE OPERATOR CLASS dump_test.op_class_custom
[14:07:09.247](0.000s) ok 2042 - defaults_custom_format: should dump CREATE OPERATOR CLASS dump_test.op_class_empty
[14:07:09.248](0.000s) ok 2043 - defaults_custom_format: should dump CREATE OPERATOR FAMILY dump_test.op_family
[14:07:09.248](0.000s) ok 2044 - defaults_custom_format: should dump CREATE POLICY p1 ON test_table
[14:07:09.248](0.000s) ok 2045 - defaults_custom_format: should dump CREATE POLICY p2 ON test_table FOR SELECT
[14:07:09.249](0.000s) ok 2046 - defaults_custom_format: should dump CREATE POLICY p3 ON test_table FOR INSERT
[14:07:09.249](0.000s) ok 2047 - defaults_custom_format: should dump CREATE POLICY p4 ON test_table FOR UPDATE
[14:07:09.250](0.000s) ok 2048 - defaults_custom_format: should dump CREATE POLICY p5 ON test_table FOR DELETE
[14:07:09.250](0.001s) ok 2049 - defaults_custom_format: should dump CREATE POLICY p6 ON test_table AS RESTRICTIVE
[14:07:09.250](0.000s) ok 2050 - defaults_custom_format: should dump CREATE PROCEDURE dump_test.ptest1
[14:07:09.251](0.000s) ok 2051 - defaults_custom_format: should dump CREATE PROPERTY GRAPH propgraph
[14:07:09.251](0.000s) ok 2052 - defaults_custom_format: should dump CREATE PUBLICATION pub1
[14:07:09.252](0.000s) ok 2053 - defaults_custom_format: should dump CREATE PUBLICATION pub10
[14:07:09.252](0.000s) ok 2054 - defaults_custom_format: should dump CREATE PUBLICATION pub2
[14:07:09.252](0.000s) ok 2055 - defaults_custom_format: should dump CREATE PUBLICATION pub3
[14:07:09.253](0.000s) ok 2056 - defaults_custom_format: should dump CREATE PUBLICATION pub4
[14:07:09.253](0.000s) ok 2057 - defaults_custom_format: should dump CREATE PUBLICATION pub5
[14:07:09.253](0.000s) ok 2058 - defaults_custom_format: should dump CREATE PUBLICATION pub6
[14:07:09.253](0.000s) ok 2059 - defaults_custom_format: should dump CREATE PUBLICATION pub7
[14:07:09.254](0.000s) ok 2060 - defaults_custom_format: should dump CREATE PUBLICATION pub8
[14:07:09.254](0.000s) ok 2061 - defaults_custom_format: should dump CREATE PUBLICATION pub9
[14:07:09.254](0.000s) ok 2062 - defaults_custom_format: should not dump CREATE ROLE regress_dump_test_role
[14:07:09.255](0.001s) ok 2063 - defaults_custom_format: should not dump CREATE ROLE regress_quoted...
[14:07:09.255](0.000s) ok 2064 - defaults_custom_format: should dump CREATE SCHEMA dump_test
[14:07:09.255](0.000s) ok 2065 - defaults_custom_format: should dump CREATE SCHEMA dump_test_second_schema
[14:07:09.255](0.000s) ok 2066 - defaults_custom_format: should not dump CREATE SCHEMA public
[14:07:09.256](0.000s) ok 2067 - defaults_custom_format: should dump CREATE SEQUENCE test_table_col1_seq
[14:07:09.256](0.000s) ok 2068 - defaults_custom_format: should dump CREATE SERVER s1 FOREIGN DATA WRAPPER dummy
[14:07:09.257](0.000s) ok 2069 - defaults_custom_format: should dump CREATE STATISTICS extended_stats_expression
[14:07:09.257](0.000s) ok 2070 - defaults_custom_format: should dump CREATE STATISTICS extended_stats_no_options
[14:07:09.257](0.000s) ok 2071 - defaults_custom_format: should dump CREATE STATISTICS extended_stats_options
[14:07:09.258](0.000s) ok 2072 - defaults_custom_format: should dump CREATE SUBSCRIPTION sub1
[14:07:09.258](0.000s) ok 2073 - defaults_custom_format: should dump CREATE SUBSCRIPTION sub2
[14:07:09.258](0.000s) ok 2074 - defaults_custom_format: should dump CREATE SUBSCRIPTION sub3
[14:07:09.259](0.000s) ok 2075 - defaults_custom_format: should dump CREATE TABLE fk_reference_test_table
[14:07:09.259](0.000s) ok 2076 - defaults_custom_format: should dump CREATE TABLE measurement PARTITIONED BY
[14:07:09.260](0.000s) ok 2077 - defaults_custom_format: should dump CREATE TABLE regress_pg_dump_table_am
[14:07:09.269](0.009s) ok 2078 - defaults_custom_format: should dump CREATE TABLE regress_pg_dump_table_part
[14:07:09.269](0.000s) ok 2079 - defaults_custom_format: should dump CREATE TABLE table_with_stats
[14:07:09.270](0.000s) ok 2080 - defaults_custom_format: should dump CREATE TABLE test_fifth_table
[14:07:09.270](0.000s) ok 2081 - defaults_custom_format: should dump CREATE TABLE test_fourth_table_zero_col
[14:07:09.270](0.000s) ok 2082 - defaults_custom_format: should dump CREATE TABLE test_inheritance_child
[14:07:09.271](0.000s) ok 2083 - defaults_custom_format: should dump CREATE TABLE test_inheritance_parent
[14:07:09.271](0.000s) ok 2084 - defaults_custom_format: should dump CREATE TABLE test_second_table
[14:07:09.271](0.000s) ok 2085 - defaults_custom_format: should dump CREATE TABLE test_seventh_table
[14:07:09.271](0.000s) ok 2086 - defaults_custom_format: should dump CREATE TABLE test_sixth_table
[14:07:09.274](0.003s) ok 2087 - defaults_custom_format: should dump CREATE TABLE test_table
[14:07:09.275](0.000s) ok 2088 - defaults_custom_format: should dump CREATE TABLE test_table_generated
[14:07:09.275](0.000s) ok 2089 - defaults_custom_format: should dump CREATE TABLE test_table_generated_child1 (without local columns)
[14:07:09.275](0.000s) ok 2090 - defaults_custom_format: should dump CREATE TABLE test_table_generated_child2 (with local columns)
[14:07:09.276](0.001s) ok 2091 - defaults_custom_format: should dump CREATE TABLE test_table_identity
[14:07:09.276](0.000s) ok 2092 - defaults_custom_format: should dump CREATE TABLE test_third_table_generated_cols
[14:07:09.276](0.000s) ok 2093 - defaults_custom_format: should not dump CREATE TABLESPACE regress_dump_tablespace
[14:07:09.277](0.000s) ok 2094 - defaults_custom_format: should dump CREATE TEXT SEARCH CONFIGURATION dump_test.alt_ts_conf1
[14:07:09.277](0.000s) ok 2095 - defaults_custom_format: should dump CREATE TEXT SEARCH DICTIONARY dump_test.alt_ts_dict1
[14:07:09.277](0.000s) ok 2096 - defaults_custom_format: should dump CREATE TEXT SEARCH PARSER dump_test.alt_ts_prs1
[14:07:09.277](0.000s) ok 2097 - defaults_custom_format: should dump CREATE TEXT SEARCH TEMPLATE dump_test.alt_ts_temp1
[14:07:09.278](0.000s) ok 2098 - defaults_custom_format: should dump CREATE TRANSFORM FOR int
[14:07:09.278](0.000s) ok 2099 - defaults_custom_format: should dump CREATE TRIGGER test_trigger
[14:07:09.278](0.000s) ok 2100 - defaults_custom_format: should dump CREATE TYPE dump_test.composite
[14:07:09.278](0.000s) ok 2101 - defaults_custom_format: should dump CREATE TYPE dump_test.int42
[14:07:09.278](0.000s) ok 2102 - defaults_custom_format: should dump CREATE TYPE dump_test.int42 populated
[14:07:09.279](0.000s) ok 2103 - defaults_custom_format: should dump CREATE TYPE dump_test.planets AS ENUM
[14:07:09.279](0.000s) ok 2104 - defaults_custom_format: should not dump CREATE TYPE dump_test.planets AS ENUM pg_upgrade
[14:07:09.279](0.000s) ok 2105 - defaults_custom_format: should dump CREATE TYPE dump_test.textrange AS RANGE
[14:07:09.279](0.000s) ok 2106 - defaults_custom_format: should dump CREATE TYPE dump_test.undefined
[14:07:09.280](0.000s) ok 2107 - defaults_custom_format: should dump CREATE USER MAPPING FOR regress_dump_test_role SERVER s1
[14:07:09.280](0.000s) ok 2108 - defaults_custom_format: should dump CREATE VIEW test_view
[14:07:09.281](0.001s) ok 2109 - defaults_custom_format: should dump Check ordering of a function that depends on a primary key
[14:07:09.282](0.001s) ok 2110 - defaults_custom_format: should dump Check ordering of a matview that depends on a primary key
[14:07:09.283](0.000s) ok 2111 - defaults_custom_format: should dump Creation of row-level trigger in partitioned table
[14:07:09.283](0.000s) ok 2112 - defaults_custom_format: should not dump DROP EXTENSION IF EXISTS plpgsql
[14:07:09.283](0.000s) ok 2113 - defaults_custom_format: should not dump DROP EXTENSION plpgsql
[14:07:09.284](0.000s) ok 2114 - defaults_custom_format: should not dump DROP FUNCTION IF EXISTS dump_test.pltestlang_call_handler()
[14:07:09.284](0.000s) ok 2115 - defaults_custom_format: should not dump DROP FUNCTION dump_test.pltestlang_call_handler()
[14:07:09.284](0.000s) ok 2116 - defaults_custom_format: should not dump DROP LANGUAGE IF EXISTS pltestlang
[14:07:09.285](0.000s) ok 2117 - defaults_custom_format: should not dump DROP LANGUAGE pltestlang
[14:07:09.285](0.000s) ok 2118 - defaults_custom_format: should not dump DROP ROLE pg_
[14:07:09.286](0.000s) ok 2119 - defaults_custom_format: should not dump DROP ROLE regress_dump_test_role
[14:07:09.286](0.001s) ok 2120 - defaults_custom_format: should not dump DROP SCHEMA IF EXISTS dump_test
[14:07:09.287](0.000s) ok 2121 - defaults_custom_format: should not dump DROP SCHEMA IF EXISTS dump_test_second_schema
[14:07:09.287](0.000s) ok 2122 - defaults_custom_format: should not dump DROP SCHEMA IF EXISTS public
[14:07:09.287](0.001s) ok 2123 - defaults_custom_format: should not dump DROP SCHEMA dump_test
[14:07:09.288](0.000s) ok 2124 - defaults_custom_format: should not dump DROP SCHEMA dump_test_second_schema
[14:07:09.288](0.000s) ok 2125 - defaults_custom_format: should not dump DROP SCHEMA public
[14:07:09.288](0.000s) ok 2126 - defaults_custom_format: should not dump DROP TABLE IF EXISTS test_second_table
[14:07:09.289](0.000s) ok 2127 - defaults_custom_format: should not dump DROP TABLE IF EXISTS test_table
[14:07:09.289](0.000s) ok 2128 - defaults_custom_format: should not dump DROP TABLE fk_reference_test_table
[14:07:09.289](0.000s) ok 2129 - defaults_custom_format: should not dump DROP TABLE test_second_table
[14:07:09.289](0.000s) ok 2130 - defaults_custom_format: should not dump DROP TABLE test_table
[14:07:09.290](0.000s) ok 2131 - defaults_custom_format: should dump Disabled trigger on partition is altered
[14:07:09.290](0.000s) ok 2132 - defaults_custom_format: should not dump Disabled trigger on partition is not created
[14:07:09.290](0.000s) ok 2133 - defaults_custom_format: should dump GRANT ALL ON LARGE OBJECT ...
[14:07:09.291](0.000s) ok 2134 - defaults_custom_format: should not dump GRANT CREATE ON DATABASE dump_test
[14:07:09.291](0.000s) ok 2135 - defaults_custom_format: should dump GRANT EXECUTE ON FUNCTION pg_sleep() TO regress_dump_test_role
[14:07:09.291](0.000s) ok 2136 - defaults_custom_format: should dump GRANT INSERT(col1) ON TABLE test_second_table
[14:07:09.295](0.003s) ok 2137 - defaults_custom_format: should dump GRANT SELECT (proname ...) ON TABLE pg_proc TO public
[14:07:09.295](0.000s) ok 2138 - defaults_custom_format: should dump GRANT SELECT ON PROPERTY GRAPH propgraph
[14:07:09.296](0.001s) ok 2139 - defaults_custom_format: should dump GRANT SELECT ON TABLE measurement
[14:07:09.296](0.000s) ok 2140 - defaults_custom_format: should dump GRANT SELECT ON TABLE measurement_y2006m2
[14:07:09.296](0.000s) ok 2141 - defaults_custom_format: should dump GRANT SELECT ON TABLE test_table
[14:07:09.297](0.000s) ok 2142 - defaults_custom_format: should dump GRANT USAGE ON DOMAIN dump_test.us_postal_code
[14:07:09.297](0.000s) ok 2143 - defaults_custom_format: should dump GRANT USAGE ON FOREIGN DATA WRAPPER dummy
[14:07:09.298](0.000s) ok 2144 - defaults_custom_format: should dump GRANT USAGE ON FOREIGN SERVER s1
[14:07:09.298](0.000s) ok 2145 - defaults_custom_format: should dump GRANT USAGE ON SCHEMA dump_test_second_schema
[14:07:09.298](0.000s) ok 2146 - defaults_custom_format: should not dump GRANT USAGE ON SCHEMA public TO public
[14:07:09.298](0.000s) ok 2147 - defaults_custom_format: should dump GRANT USAGE ON TYPE dump_test.int42
[14:07:09.299](0.000s) ok 2148 - defaults_custom_format: should dump GRANT USAGE ON TYPE dump_test.planets - ENUM
[14:07:09.299](0.000s) ok 2149 - defaults_custom_format: should dump GRANT USAGE ON TYPE dump_test.textrange - RANGE
[14:07:09.299](0.000s) ok 2150 - defaults_custom_format: should not dump INSERT INTO test_fifth_table
[14:07:09.299](0.000s) ok 2151 - defaults_custom_format: should not dump INSERT INTO test_fourth_table
[14:07:09.300](0.000s) ok 2152 - defaults_custom_format: should not dump INSERT INTO test_second_table
[14:07:09.300](0.000s) ok 2153 - defaults_custom_format: should not dump INSERT INTO test_table
[14:07:09.300](0.000s) ok 2154 - defaults_custom_format: should not dump INSERT INTO test_table_identity
[14:07:09.301](0.001s) ok 2155 - defaults_custom_format: should not dump INSERT INTO test_third_table
[14:07:09.301](0.000s) ok 2156 - defaults_custom_format: should not dump INSERT INTO test_third_table (colnames)
[14:07:09.301](0.000s) ok 2157 - defaults_custom_format: should dump LO create (using lo_from_bytea)
[14:07:09.302](0.000s) ok 2158 - defaults_custom_format: should dump LO create (with no data)
[14:07:09.302](0.000s) ok 2159 - defaults_custom_format: should dump LO load (using lo_from_bytea)
[14:07:09.302](0.000s) ok 2160 - defaults_custom_format: should dump Partition measurement_y2006m2 creation
[14:07:09.303](0.000s) ok 2161 - defaults_custom_format: should dump REFRESH MATERIALIZED VIEW matview
[14:07:09.303](0.000s) ok 2162 - defaults_custom_format: should not dump REFRESH MATERIALIZED VIEW matview_fourth
[14:07:09.303](0.000s) ok 2163 - defaults_custom_format: should dump REFRESH MATERIALIZED VIEW matview_second
[14:07:09.304](0.000s) ok 2164 - defaults_custom_format: should not dump REFRESH MATERIALIZED VIEW matview_third
[14:07:09.304](0.000s) ok 2165 - defaults_custom_format: should dump REVOKE ALL ON SCHEMA public
[14:07:09.304](0.000s) ok 2166 - defaults_custom_format: should not dump REVOKE CONNECT ON DATABASE dump_test FROM public
[14:07:09.304](0.000s) ok 2167 - defaults_custom_format: should dump REVOKE EXECUTE ON FUNCTION pg_sleep() FROM public
[14:07:09.342](0.037s) ok 2168 - defaults_custom_format: should not dump REVOKE EXECUTE ON FUNCTION pg_stat_reset FROM regress_dump_test_role
[14:07:09.342](0.000s) ok 2169 - defaults_custom_format: should dump REVOKE SELECT ON TABLE pg_proc FROM public
[14:07:09.342](0.000s) ok 2170 - defaults_custom_format: should dump REVOKE USAGE ON LANGUAGE plpgsql FROM public
[14:07:09.343](0.000s) ok 2171 - defaults_custom_format: should dump Replica trigger on partition is altered
[14:07:09.343](0.000s) ok 2172 - defaults_custom_format: should not dump Triggers on partitions are not dropped
[14:07:09.343](0.000s) ok 2173 - defaults_custom_format: should dump extended_statistics_import
[14:07:09.344](0.001s) ok 2174 - defaults_custom_format: should not dump newline of table name in comment
[14:07:09.344](0.000s) ok 2175 - defaults_custom_format: should dump relstats_on_unanalyzed_tables
[14:07:09.344](0.000s) ok 2176 - defaults_custom_format: should dump restrict
[14:07:09.345](0.001s) ok 2177 - defaults_custom_format: should dump statistics_import
[14:07:09.346](0.000s) ok 2178 - defaults_custom_format: should not dump test_table with 4-row INSERTs
[14:07:09.346](0.000s) ok 2179 - defaults_custom_format: should dump unrestrict
# Running: pg_dump --format directory --file C:\cirrus\build\testrun\pg_dump\002_pg_dump\data\tmp_test_9UIx/defaults_dir_format --statistics postgres
[14:07:10.540](1.194s) ok 2180 - defaults_dir_format: pg_dump runs
[14:07:10.542](0.002s) ok 2181 - defaults_dir_format: glob check for C:\cirrus\build\testrun\pg_dump\002_pg_dump\data\tmp_test_9UIx/defaults_dir_format/toc.dat
[14:07:10.543](0.001s) ok 2182 - defaults_dir_format: glob check for C:\cirrus\build\testrun\pg_dump\002_pg_dump\data\tmp_test_9UIx/defaults_dir_format/blobs_*.toc
[14:07:10.545](0.002s) ok 2183 - defaults_dir_format: glob check for C:\cirrus\build\testrun\pg_dump\002_pg_dump\data\tmp_test_9UIx/defaults_dir_format/*.dat
# Running: pg_restore --list C:\cirrus\build\testrun\pg_dump\002_pg_dump\data\tmp_test_9UIx/defaults_dir_format
[14:07:10.656](0.110s) ok 2184 - defaults_dir_format: data content is gzip-compressed by default: exit code 0
[14:07:10.658](0.002s) ok 2185 - defaults_dir_format: data content is gzip-compressed by default: no stderr
[14:07:10.659](0.001s) ok 2186 - defaults_dir_format: data content is gzip-compressed by default: matches
# Running: pg_restore --format directory --file C:\cirrus\build\testrun\pg_dump\002_pg_dump\data\tmp_test_9UIx/defaults_dir_format.sql --statistics C:\cirrus\build\testrun\pg_dump\002_pg_dump\data\tmp_test_9UIx/defaults_dir_format
[14:07:10.730](0.071s) ok 2187 - defaults_dir_format: pg_restore runs
[14:07:10.733](0.003s) ok 2188 - defaults_dir_format: should dump ALTER COLLATION test0 OWNER TO
[14:07:10.734](0.000s) ok 2189 - defaults_dir_format: should dump ALTER DEFAULT PRIVILEGES FOR ROLE regress_dump_test_role GRANT
[14:07:10.734](0.000s) ok 2190 - defaults_dir_format: should dump ALTER DEFAULT PRIVILEGES FOR ROLE regress_dump_test_role GRANT EXECUTE ON FUNCTIONS
[14:07:10.734](0.000s) ok 2191 - defaults_dir_format: should dump ALTER DEFAULT PRIVILEGES FOR ROLE regress_dump_test_role REVOKE
[14:07:10.734](0.000s) ok 2192 - defaults_dir_format: should dump ALTER DEFAULT PRIVILEGES FOR ROLE regress_dump_test_role REVOKE SELECT
[14:07:10.734](0.000s) ok 2193 - defaults_dir_format: should dump ALTER FOREIGN DATA WRAPPER dummy OWNER TO
[14:07:10.735](0.000s) ok 2194 - defaults_dir_format: should dump ALTER FOREIGN TABLE foreign_table ALTER COLUMN c1 OPTIONS
[14:07:10.735](0.000s) ok 2195 - defaults_dir_format: should dump ALTER FOREIGN TABLE foreign_table OWNER TO
[14:07:10.735](0.000s) ok 2196 - defaults_dir_format: should dump ALTER FUNCTION dump_test.pltestlang_call_handler() OWNER TO
[14:07:10.735](0.000s) ok 2197 - defaults_dir_format: should dump ALTER INDEX ... ATTACH PARTITION
[14:07:10.735](0.000s) ok 2198 - defaults_dir_format: should dump ALTER INDEX ... ATTACH PARTITION (primary key)
[14:07:10.736](0.000s) ok 2199 - defaults_dir_format: should dump ALTER LARGE OBJECT ... OWNER TO
[14:07:10.736](0.000s) ok 2200 - defaults_dir_format: should dump ALTER OPERATOR CLASS dump_test.op_class OWNER TO
[14:07:10.736](0.000s) ok 2201 - defaults_dir_format: should dump ALTER OPERATOR FAMILY dump_test.op_family OWNER TO
[14:07:10.736](0.000s) ok 2202 - defaults_dir_format: should dump ALTER OPERATOR FAMILY dump_test.op_family USING btree
[14:07:10.736](0.000s) ok 2203 - defaults_dir_format: should dump ALTER PROCEDURAL LANGUAGE pltestlang OWNER TO
[14:07:10.737](0.000s) ok 2204 - defaults_dir_format: should dump ALTER PUBLICATION pub1 ADD TABLE test_second_table
[14:07:10.737](0.000s) ok 2205 - defaults_dir_format: should dump ALTER PUBLICATION pub1 ADD TABLE test_seventh_table (col3, col2) WHERE (col1 = 1)
[14:07:10.737](0.000s) ok 2206 - defaults_dir_format: should dump ALTER PUBLICATION pub1 ADD TABLE test_sixth_table (col3, col2)
[14:07:10.737](0.000s) ok 2207 - defaults_dir_format: should dump ALTER PUBLICATION pub1 ADD TABLE test_table
[14:07:10.738](0.000s) ok 2208 - defaults_dir_format: should dump ALTER PUBLICATION pub1 OWNER TO
[14:07:10.738](0.000s) ok 2209 - defaults_dir_format: should dump ALTER PUBLICATION pub3 ADD TABLE test_table
[14:07:10.738](0.000s) ok 2210 - defaults_dir_format: should dump ALTER PUBLICATION pub3 ADD TABLES IN SCHEMA dump_test
[14:07:10.738](0.000s) ok 2211 - defaults_dir_format: should dump ALTER PUBLICATION pub3 ADD TABLES IN SCHEMA public
[14:07:10.739](0.000s) ok 2212 - defaults_dir_format: should dump ALTER PUBLICATION pub4 ADD TABLE test_second_table WHERE (col2 = 'test');
[14:07:10.739](0.000s) ok 2213 - defaults_dir_format: should dump ALTER PUBLICATION pub4 ADD TABLE test_table WHERE (col1 > 0);
[14:07:10.739](0.000s) ok 2214 - defaults_dir_format: should not dump ALTER ROLE regress_dump_test_role
[14:07:10.739](0.000s) ok 2215 - defaults_dir_format: should dump ALTER SCHEMA dump_test OWNER TO
[14:07:10.739](0.000s) ok 2216 - defaults_dir_format: should dump ALTER SCHEMA dump_test_second_schema OWNER TO
[14:07:10.740](0.000s) ok 2217 - defaults_dir_format: should dump ALTER SCHEMA public OWNER TO
[14:07:10.740](0.000s) ok 2218 - defaults_dir_format: should dump ALTER SEQUENCE test_table_col1_seq
[14:07:10.740](0.000s) ok 2219 - defaults_dir_format: should dump ALTER SERVER s1 OWNER TO
[14:07:10.740](0.000s) ok 2220 - defaults_dir_format: should dump ALTER STATISTICS extended_stats_options
[14:07:10.740](0.000s) ok 2221 - defaults_dir_format: should dump ALTER TABLE (partitioned) ADD CONSTRAINT ... FOREIGN KEY
[14:07:10.741](0.000s) ok 2222 - defaults_dir_format: should dump ALTER TABLE ONLY dump_test.measurement ATTACH PARTITION measurement_y2006m2
[14:07:10.741](0.000s) ok 2223 - defaults_dir_format: should dump ALTER TABLE ONLY test_table ADD CONSTRAINT ... PRIMARY KEY
[14:07:10.741](0.000s) ok 2224 - defaults_dir_format: should dump ALTER TABLE ONLY test_table ALTER COLUMN col1 SET STATISTICS 90
[14:07:10.741](0.000s) ok 2225 - defaults_dir_format: should dump ALTER TABLE ONLY test_table ALTER COLUMN col2 SET STORAGE
[14:07:10.741](0.000s) ok 2226 - defaults_dir_format: should dump ALTER TABLE ONLY test_table ALTER COLUMN col3 SET STORAGE
[14:07:10.742](0.000s) ok 2227 - defaults_dir_format: should dump ALTER TABLE ONLY test_table ALTER COLUMN col4 SET n_distinct
[14:07:10.742](0.000s) ok 2228 - defaults_dir_format: should dump ALTER TABLE measurement OWNER TO
[14:07:10.742](0.000s) ok 2229 - defaults_dir_format: should dump ALTER TABLE measurement PRIMARY KEY
[14:07:10.742](0.000s) ok 2230 - defaults_dir_format: should dump ALTER TABLE measurement_y2006m2 OWNER TO
[14:07:10.742](0.000s) ok 2231 - defaults_dir_format: should dump ALTER TABLE test_second_table OWNER TO
[14:07:10.743](0.000s) ok 2232 - defaults_dir_format: should dump ALTER TABLE test_table CLUSTER ON test_table_pkey
[14:07:10.743](0.000s) ok 2233 - defaults_dir_format: should not dump ALTER TABLE test_table DISABLE TRIGGER ALL
[14:07:10.743](0.000s) ok 2234 - defaults_dir_format: should dump ALTER TABLE test_table ENABLE ROW LEVEL SECURITY
[14:07:10.743](0.000s) ok 2235 - defaults_dir_format: should dump ALTER TABLE test_table OWNER TO
[14:07:10.744](0.000s) ok 2236 - defaults_dir_format: should not dump ALTER TABLE test_table_generated_child1
[14:07:10.744](0.000s) ok 2237 - defaults_dir_format: should dump ALTER TEXT SEARCH CONFIGURATION alt_ts_conf1 OWNER TO
[14:07:10.744](0.000s) ok 2238 - defaults_dir_format: should dump ALTER TEXT SEARCH CONFIGURATION dump_test.alt_ts_conf1 ...
[14:07:10.744](0.000s) ok 2239 - defaults_dir_format: should dump ALTER TEXT SEARCH DICTIONARY alt_ts_dict1 OWNER TO
[14:07:10.744](0.000s) ok 2240 - defaults_dir_format: should dump ALTER VIEW test_view SET DEFAULT
[14:07:10.745](0.000s) ok 2241 - defaults_dir_format: should dump Always trigger on partition is altered
[14:07:10.745](0.000s) ok 2242 - defaults_dir_format: should dump COMMENT ON COLLATION test0
[14:07:10.745](0.000s) ok 2243 - defaults_dir_format: should dump COMMENT ON COLUMN dump_test.composite.f1
[14:07:10.745](0.000s) ok 2244 - defaults_dir_format: should dump COMMENT ON COLUMN dump_test.test_second_table.col1
[14:07:10.745](0.000s) ok 2245 - defaults_dir_format: should dump COMMENT ON COLUMN dump_test.test_second_table.col2
[14:07:10.745](0.000s) ok 2246 - defaults_dir_format: should dump COMMENT ON COLUMN dump_test.test_table.col1
[14:07:10.746](0.000s) ok 2247 - defaults_dir_format: should dump COMMENT ON CONSTRAINT ON DOMAIN (1)
[14:07:10.746](0.000s) ok 2248 - defaults_dir_format: should dump COMMENT ON CONSTRAINT ON DOMAIN (2)
[14:07:10.746](0.000s) ok 2249 - defaults_dir_format: should dump COMMENT ON CONSTRAINT ON test_table_chld2
[14:07:10.746](0.000s) ok 2250 - defaults_dir_format: should dump COMMENT ON CONSTRAINT ON test_table_nn
[14:07:10.746](0.000s) ok 2251 - defaults_dir_format: should dump COMMENT ON CONVERSION dump_test.test_conversion
[14:07:10.747](0.000s) ok 2252 - defaults_dir_format: should not dump COMMENT ON DATABASE postgres
[14:07:10.747](0.000s) ok 2253 - defaults_dir_format: should not dump COMMENT ON EXTENSION plpgsql
[14:07:10.747](0.000s) ok 2254 - defaults_dir_format: should dump COMMENT ON LARGE OBJECT ...
[14:07:10.747](0.000s) ok 2255 - defaults_dir_format: should dump COMMENT ON POLICY p1
[14:07:10.748](0.000s) ok 2256 - defaults_dir_format: should dump COMMENT ON PUBLICATION pub1
[14:07:10.748](0.000s) ok 2257 - defaults_dir_format: should not dump COMMENT ON SCHEMA public
[14:07:10.748](0.000s) ok 2258 - defaults_dir_format: should dump COMMENT ON SUBSCRIPTION sub1
[14:07:10.748](0.000s) ok 2259 - defaults_dir_format: should dump COMMENT ON TABLE dump_test.test_table
[14:07:10.748](0.000s) ok 2260 - defaults_dir_format: should dump COMMENT ON TEXT SEARCH CONFIGURATION dump_test.alt_ts_conf1
[14:07:10.749](0.000s) ok 2261 - defaults_dir_format: should dump COMMENT ON TEXT SEARCH DICTIONARY dump_test.alt_ts_dict1
[14:07:10.749](0.000s) ok 2262 - defaults_dir_format: should dump COMMENT ON TEXT SEARCH PARSER dump_test.alt_ts_prs1
[14:07:10.749](0.000s) ok 2263 - defaults_dir_format: should dump COMMENT ON TEXT SEARCH TEMPLATE dump_test.alt_ts_temp1
[14:07:10.749](0.000s) ok 2264 - defaults_dir_format: should dump COMMENT ON TYPE dump_test.int42 - Regular
[14:07:10.749](0.000s) ok 2265 - defaults_dir_format: should dump COMMENT ON TYPE dump_test.planets - ENUM
[14:07:10.750](0.000s) ok 2266 - defaults_dir_format: should dump COMMENT ON TYPE dump_test.textrange - RANGE
[14:07:10.750](0.000s) ok 2267 - defaults_dir_format: should dump COMMENT ON TYPE dump_test.undefined - Undefined
[14:07:10.750](0.000s) ok 2268 - defaults_dir_format: should dump CONSTRAINT NOT NULL / NO INHERIT
[14:07:10.750](0.000s) ok 2269 - defaults_dir_format: should dump CONSTRAINT NOT NULL / NO INHERIT (child1)
[14:07:10.750](0.000s) ok 2270 - defaults_dir_format: should dump CONSTRAINT NOT NULL / NOT VALID
[14:07:10.751](0.000s) ok 2271 - defaults_dir_format: should dump CONSTRAINT NOT NULL / NOT VALID (child1)
[14:07:10.751](0.000s) ok 2272 - defaults_dir_format: should dump CONSTRAINT NOT NULL / NOT VALID (child2)
[14:07:10.751](0.000s) ok 2273 - defaults_dir_format: should dump CONSTRAINT NOT NULL / NOT VALID (child3)
[14:07:10.751](0.000s) ok 2274 - defaults_dir_format: should dump CONSTRAINT PRIMARY KEY / WITHOUT OVERLAPS
[14:07:10.752](0.000s) ok 2275 - defaults_dir_format: should dump CONSTRAINT UNIQUE / WITHOUT OVERLAPS
[14:07:10.752](0.000s) ok 2276 - defaults_dir_format: should dump COPY fk_reference_test_table
[14:07:10.752](0.000s) ok 2277 - defaults_dir_format: should not dump COPY fk_reference_test_table second
[14:07:10.752](0.000s) ok 2278 - defaults_dir_format: should dump COPY measurement
[14:07:10.752](0.000s) ok 2279 - defaults_dir_format: should dump COPY test_fifth_table
[14:07:10.753](0.000s) ok 2280 - defaults_dir_format: should dump COPY test_fourth_table
[14:07:10.753](0.000s) ok 2281 - defaults_dir_format: should dump COPY test_second_table
[14:07:10.753](0.000s) ok 2282 - defaults_dir_format: should dump COPY test_table
[14:07:10.753](0.000s) ok 2283 - defaults_dir_format: should dump COPY test_table_identity
[14:07:10.753](0.000s) ok 2284 - defaults_dir_format: should dump COPY test_third_table
[14:07:10.754](0.000s) ok 2285 - defaults_dir_format: should dump CREATE ACCESS METHOD gist2
[14:07:10.754](0.000s) ok 2286 - defaults_dir_format: should dump CREATE ACCESS METHOD regress_test_table_am
[14:07:10.754](0.000s) ok 2287 - defaults_dir_format: should dump CREATE AGGREGATE dump_test.newavg
[14:07:10.754](0.000s) ok 2288 - defaults_dir_format: should dump CREATE CAST FOR timestamptz
[14:07:10.754](0.000s) ok 2289 - defaults_dir_format: should dump CREATE COLLATION test0 FROM "C"
[14:07:10.754](0.000s) ok 2290 - defaults_dir_format: should dump CREATE CONVERSION dump_test.test_conversion
[14:07:10.755](0.000s) ok 2291 - defaults_dir_format: should not dump CREATE DATABASE dump_test
[14:07:10.755](0.000s) ok 2292 - defaults_dir_format: should not dump CREATE DATABASE dump_test2 LOCALE = 'C'
[14:07:10.755](0.000s) ok 2293 - defaults_dir_format: should not dump CREATE DATABASE postgres
[14:07:10.755](0.000s) ok 2294 - defaults_dir_format: should not dump CREATE DATABASE regression_invalid...
[14:07:10.758](0.002s) ok 2295 - defaults_dir_format: should dump CREATE DOMAIN dump_test.us_postal_code
[14:07:10.758](0.000s) ok 2296 - defaults_dir_format: should dump CREATE EVENT TRIGGER test_event_trigger
[14:07:10.758](0.000s) ok 2297 - defaults_dir_format: should not dump CREATE EXTENSION ... plpgsql
[14:07:10.758](0.000s) ok 2298 - defaults_dir_format: should dump CREATE FOREIGN DATA WRAPPER dummy
[14:07:10.759](0.000s) ok 2299 - defaults_dir_format: should dump CREATE FOREIGN TABLE dump_test.foreign_table SERVER s1
[14:07:10.759](0.000s) ok 2300 - defaults_dir_format: should dump CREATE FUNCTION ... SUPPORT
[14:07:10.759](0.000s) ok 2301 - defaults_dir_format: should dump CREATE FUNCTION dump_test.event_trigger_func
[14:07:10.759](0.000s) ok 2302 - defaults_dir_format: should dump CREATE FUNCTION dump_test.int42_in
[14:07:10.759](0.000s) ok 2303 - defaults_dir_format: should dump CREATE FUNCTION dump_test.int42_out
[14:07:10.760](0.000s) ok 2304 - defaults_dir_format: should dump CREATE FUNCTION dump_test.pltestlang_call_handler
[14:07:10.760](0.000s) ok 2305 - defaults_dir_format: should dump CREATE FUNCTION dump_test.trigger_func
[14:07:10.760](0.000s) ok 2306 - defaults_dir_format: should dump CREATE INDEX ... ON measurement_y2006_m2
[14:07:10.760](0.000s) ok 2307 - defaults_dir_format: should dump CREATE INDEX ON ONLY measurement
[14:07:10.760](0.000s) ok 2308 - defaults_dir_format: should dump CREATE LANGUAGE pltestlang
[14:07:10.761](0.000s) ok 2309 - defaults_dir_format: should dump CREATE MATERIALIZED VIEW matview
[14:07:10.761](0.000s) ok 2310 - defaults_dir_format: should dump CREATE MATERIALIZED VIEW matview_fourth
[14:07:10.761](0.000s) ok 2311 - defaults_dir_format: should dump CREATE MATERIALIZED VIEW matview_second
[14:07:10.761](0.000s) ok 2312 - defaults_dir_format: should dump CREATE MATERIALIZED VIEW matview_third
[14:07:10.761](0.000s) ok 2313 - defaults_dir_format: should dump CREATE MATERIALIZED VIEW regress_pg_dump_matview_am
[14:07:10.762](0.000s) ok 2314 - defaults_dir_format: should dump CREATE OPERATOR CLASS dump_test.op_class
[14:07:10.763](0.002s) ok 2315 - defaults_dir_format: should dump CREATE OPERATOR CLASS dump_test.op_class_custom
[14:07:10.764](0.000s) ok 2316 - defaults_dir_format: should dump CREATE OPERATOR CLASS dump_test.op_class_empty
[14:07:10.764](0.000s) ok 2317 - defaults_dir_format: should dump CREATE OPERATOR FAMILY dump_test.op_family
[14:07:10.764](0.000s) ok 2318 - defaults_dir_format: should dump CREATE POLICY p1 ON test_table
[14:07:10.764](0.000s) ok 2319 - defaults_dir_format: should dump CREATE POLICY p2 ON test_table FOR SELECT
[14:07:10.764](0.000s) ok 2320 - defaults_dir_format: should dump CREATE POLICY p3 ON test_table FOR INSERT
[14:07:10.765](0.000s) ok 2321 - defaults_dir_format: should dump CREATE POLICY p4 ON test_table FOR UPDATE
[14:07:10.765](0.000s) ok 2322 - defaults_dir_format: should dump CREATE POLICY p5 ON test_table FOR DELETE
[14:07:10.765](0.000s) ok 2323 - defaults_dir_format: should dump CREATE POLICY p6 ON test_table AS RESTRICTIVE
[14:07:10.765](0.000s) ok 2324 - defaults_dir_format: should dump CREATE PROCEDURE dump_test.ptest1
[14:07:10.766](0.000s) ok 2325 - defaults_dir_format: should dump CREATE PROPERTY GRAPH propgraph
[14:07:10.766](0.000s) ok 2326 - defaults_dir_format: should dump CREATE PUBLICATION pub1
[14:07:10.766](0.000s) ok 2327 - defaults_dir_format: should dump CREATE PUBLICATION pub10
[14:07:10.766](0.000s) ok 2328 - defaults_dir_format: should dump CREATE PUBLICATION pub2
[14:07:10.766](0.000s) ok 2329 - defaults_dir_format: should dump CREATE PUBLICATION pub3
[14:07:10.767](0.000s) ok 2330 - defaults_dir_format: should dump CREATE PUBLICATION pub4
[14:07:10.767](0.000s) ok 2331 - defaults_dir_format: should dump CREATE PUBLICATION pub5
[14:07:10.767](0.000s) ok 2332 - defaults_dir_format: should dump CREATE PUBLICATION pub6
[14:07:10.767](0.000s) ok 2333 - defaults_dir_format: should dump CREATE PUBLICATION pub7
[14:07:10.768](0.000s) ok 2334 - defaults_dir_format: should dump CREATE PUBLICATION pub8
[14:07:10.768](0.000s) ok 2335 - defaults_dir_format: should dump CREATE PUBLICATION pub9
[14:07:10.768](0.000s) ok 2336 - defaults_dir_format: should not dump CREATE ROLE regress_dump_test_role
[14:07:10.768](0.000s) ok 2337 - defaults_dir_format: should not dump CREATE ROLE regress_quoted...
[14:07:10.768](0.000s) ok 2338 - defaults_dir_format: should dump CREATE SCHEMA dump_test
[14:07:10.769](0.000s) ok 2339 - defaults_dir_format: should dump CREATE SCHEMA dump_test_second_schema
[14:07:10.769](0.000s) ok 2340 - defaults_dir_format: should not dump CREATE SCHEMA public
[14:07:10.769](0.000s) ok 2341 - defaults_dir_format: should dump CREATE SEQUENCE test_table_col1_seq
[14:07:10.769](0.000s) ok 2342 - defaults_dir_format: should dump CREATE SERVER s1 FOREIGN DATA WRAPPER dummy
[14:07:10.770](0.000s) ok 2343 - defaults_dir_format: should dump CREATE STATISTICS extended_stats_expression
[14:07:10.770](0.000s) ok 2344 - defaults_dir_format: should dump CREATE STATISTICS extended_stats_no_options
[14:07:10.770](0.000s) ok 2345 - defaults_dir_format: should dump CREATE STATISTICS extended_stats_options
[14:07:10.770](0.000s) ok 2346 - defaults_dir_format: should dump CREATE SUBSCRIPTION sub1
[14:07:10.770](0.000s) ok 2347 - defaults_dir_format: should dump CREATE SUBSCRIPTION sub2
[14:07:10.771](0.000s) ok 2348 - defaults_dir_format: should dump CREATE SUBSCRIPTION sub3
[14:07:10.771](0.000s) ok 2349 - defaults_dir_format: should dump CREATE TABLE fk_reference_test_table
[14:07:10.771](0.000s) ok 2350 - defaults_dir_format: should dump CREATE TABLE measurement PARTITIONED BY
[14:07:10.771](0.000s) ok 2351 - defaults_dir_format: should dump CREATE TABLE regress_pg_dump_table_am
[14:07:10.780](0.009s) ok 2352 - defaults_dir_format: should dump CREATE TABLE regress_pg_dump_table_part
[14:07:10.780](0.000s) ok 2353 - defaults_dir_format: should dump CREATE TABLE table_with_stats
[14:07:10.781](0.000s) ok 2354 - defaults_dir_format: should dump CREATE TABLE test_fifth_table
[14:07:10.781](0.000s) ok 2355 - defaults_dir_format: should dump CREATE TABLE test_fourth_table_zero_col
[14:07:10.781](0.000s) ok 2356 - defaults_dir_format: should dump CREATE TABLE test_inheritance_child
[14:07:10.781](0.000s) ok 2357 - defaults_dir_format: should dump CREATE TABLE test_inheritance_parent
[14:07:10.781](0.000s) ok 2358 - defaults_dir_format: should dump CREATE TABLE test_second_table
[14:07:10.782](0.000s) ok 2359 - defaults_dir_format: should dump CREATE TABLE test_seventh_table
[14:07:10.782](0.000s) ok 2360 - defaults_dir_format: should dump CREATE TABLE test_sixth_table
[14:07:10.785](0.003s) ok 2361 - defaults_dir_format: should dump CREATE TABLE test_table
[14:07:10.785](0.000s) ok 2362 - defaults_dir_format: should dump CREATE TABLE test_table_generated
[14:07:10.785](0.000s) ok 2363 - defaults_dir_format: should dump CREATE TABLE test_table_generated_child1 (without local columns)
[14:07:10.785](0.000s) ok 2364 - defaults_dir_format: should dump CREATE TABLE test_table_generated_child2 (with local columns)
[14:07:10.786](0.001s) ok 2365 - defaults_dir_format: should dump CREATE TABLE test_table_identity
[14:07:10.786](0.000s) ok 2366 - defaults_dir_format: should dump CREATE TABLE test_third_table_generated_cols
[14:07:10.786](0.000s) ok 2367 - defaults_dir_format: should not dump CREATE TABLESPACE regress_dump_tablespace
[14:07:10.787](0.000s) ok 2368 - defaults_dir_format: should dump CREATE TEXT SEARCH CONFIGURATION dump_test.alt_ts_conf1
[14:07:10.787](0.000s) ok 2369 - defaults_dir_format: should dump CREATE TEXT SEARCH DICTIONARY dump_test.alt_ts_dict1
[14:07:10.787](0.000s) ok 2370 - defaults_dir_format: should dump CREATE TEXT SEARCH PARSER dump_test.alt_ts_prs1
[14:07:10.787](0.000s) ok 2371 - defaults_dir_format: should dump CREATE TEXT SEARCH TEMPLATE dump_test.alt_ts_temp1
[14:07:10.787](0.000s) ok 2372 - defaults_dir_format: should dump CREATE TRANSFORM FOR int
[14:07:10.788](0.000s) ok 2373 - defaults_dir_format: should dump CREATE TRIGGER test_trigger
[14:07:10.788](0.000s) ok 2374 - defaults_dir_format: should dump CREATE TYPE dump_test.composite
[14:07:10.788](0.000s) ok 2375 - defaults_dir_format: should dump CREATE TYPE dump_test.int42
[14:07:10.788](0.000s) ok 2376 - defaults_dir_format: should dump CREATE TYPE dump_test.int42 populated
[14:07:10.788](0.000s) ok 2377 - defaults_dir_format: should dump CREATE TYPE dump_test.planets AS ENUM
[14:07:10.789](0.000s) ok 2378 - defaults_dir_format: should not dump CREATE TYPE dump_test.planets AS ENUM pg_upgrade
[14:07:10.789](0.000s) ok 2379 - defaults_dir_format: should dump CREATE TYPE dump_test.textrange AS RANGE
[14:07:10.789](0.000s) ok 2380 - defaults_dir_format: should dump CREATE TYPE dump_test.undefined
[14:07:10.789](0.000s) ok 2381 - defaults_dir_format: should dump CREATE USER MAPPING FOR regress_dump_test_role SERVER s1
[14:07:10.789](0.000s) ok 2382 - defaults_dir_format: should dump CREATE VIEW test_view
[14:07:10.790](0.001s) ok 2383 - defaults_dir_format: should dump Check ordering of a function that depends on a primary key
[14:07:10.791](0.001s) ok 2384 - defaults_dir_format: should dump Check ordering of a matview that depends on a primary key
[14:07:10.791](0.000s) ok 2385 - defaults_dir_format: should dump Creation of row-level trigger in partitioned table
[14:07:10.791](0.000s) ok 2386 - defaults_dir_format: should not dump DROP EXTENSION IF EXISTS plpgsql
[14:07:10.792](0.000s) ok 2387 - defaults_dir_format: should not dump DROP EXTENSION plpgsql
[14:07:10.792](0.000s) ok 2388 - defaults_dir_format: should not dump DROP FUNCTION IF EXISTS dump_test.pltestlang_call_handler()
[14:07:10.792](0.000s) ok 2389 - defaults_dir_format: should not dump DROP FUNCTION dump_test.pltestlang_call_handler()
[14:07:10.792](0.000s) ok 2390 - defaults_dir_format: should not dump DROP LANGUAGE IF EXISTS pltestlang
[14:07:10.793](0.000s) ok 2391 - defaults_dir_format: should not dump DROP LANGUAGE pltestlang
[14:07:10.793](0.000s) ok 2392 - defaults_dir_format: should not dump DROP ROLE pg_
[14:07:10.793](0.000s) ok 2393 - defaults_dir_format: should not dump DROP ROLE regress_dump_test_role
[14:07:10.793](0.000s) ok 2394 - defaults_dir_format: should not dump DROP SCHEMA IF EXISTS dump_test
[14:07:10.794](0.000s) ok 2395 - defaults_dir_format: should not dump DROP SCHEMA IF EXISTS dump_test_second_schema
[14:07:10.794](0.000s) ok 2396 - defaults_dir_format: should not dump DROP SCHEMA IF EXISTS public
[14:07:10.794](0.000s) ok 2397 - defaults_dir_format: should not dump DROP SCHEMA dump_test
[14:07:10.794](0.000s) ok 2398 - defaults_dir_format: should not dump DROP SCHEMA dump_test_second_schema
[14:07:10.795](0.000s) ok 2399 - defaults_dir_format: should not dump DROP SCHEMA public
[14:07:10.795](0.000s) ok 2400 - defaults_dir_format: should not dump DROP TABLE IF EXISTS test_second_table
[14:07:10.795](0.000s) ok 2401 - defaults_dir_format: should not dump DROP TABLE IF EXISTS test_table
[14:07:10.795](0.000s) ok 2402 - defaults_dir_format: should not dump DROP TABLE fk_reference_test_table
[14:07:10.796](0.000s) ok 2403 - defaults_dir_format: should not dump DROP TABLE test_second_table
[14:07:10.796](0.000s) ok 2404 - defaults_dir_format: should not dump DROP TABLE test_table
[14:07:10.796](0.000s) ok 2405 - defaults_dir_format: should dump Disabled trigger on partition is altered
[14:07:10.796](0.000s) ok 2406 - defaults_dir_format: should not dump Disabled trigger on partition is not created
[14:07:10.797](0.000s) ok 2407 - defaults_dir_format: should dump GRANT ALL ON LARGE OBJECT ...
[14:07:10.797](0.000s) ok 2408 - defaults_dir_format: should not dump GRANT CREATE ON DATABASE dump_test
[14:07:10.797](0.000s) ok 2409 - defaults_dir_format: should dump GRANT EXECUTE ON FUNCTION pg_sleep() TO regress_dump_test_role
[14:07:10.797](0.000s) ok 2410 - defaults_dir_format: should dump GRANT INSERT(col1) ON TABLE test_second_table
[14:07:10.800](0.003s) ok 2411 - defaults_dir_format: should dump GRANT SELECT (proname ...) ON TABLE pg_proc TO public
[14:07:10.800](0.000s) ok 2412 - defaults_dir_format: should dump GRANT SELECT ON PROPERTY GRAPH propgraph
[14:07:10.801](0.001s) ok 2413 - defaults_dir_format: should dump GRANT SELECT ON TABLE measurement
[14:07:10.801](0.000s) ok 2414 - defaults_dir_format: should dump GRANT SELECT ON TABLE measurement_y2006m2
[14:07:10.801](0.000s) ok 2415 - defaults_dir_format: should dump GRANT SELECT ON TABLE test_table
[14:07:10.802](0.000s) ok 2416 - defaults_dir_format: should dump GRANT USAGE ON DOMAIN dump_test.us_postal_code
[14:07:10.802](0.000s) ok 2417 - defaults_dir_format: should dump GRANT USAGE ON FOREIGN DATA WRAPPER dummy
[14:07:10.802](0.000s) ok 2418 - defaults_dir_format: should dump GRANT USAGE ON FOREIGN SERVER s1
[14:07:10.802](0.000s) ok 2419 - defaults_dir_format: should dump GRANT USAGE ON SCHEMA dump_test_second_schema
[14:07:10.803](0.000s) ok 2420 - defaults_dir_format: should not dump GRANT USAGE ON SCHEMA public TO public
[14:07:10.803](0.000s) ok 2421 - defaults_dir_format: should dump GRANT USAGE ON TYPE dump_test.int42
[14:07:10.803](0.000s) ok 2422 - defaults_dir_format: should dump GRANT USAGE ON TYPE dump_test.planets - ENUM
[14:07:10.803](0.000s) ok 2423 - defaults_dir_format: should dump GRANT USAGE ON TYPE dump_test.textrange - RANGE
[14:07:10.803](0.000s) ok 2424 - defaults_dir_format: should not dump INSERT INTO test_fifth_table
[14:07:10.804](0.000s) ok 2425 - defaults_dir_format: should not dump INSERT INTO test_fourth_table
[14:07:10.804](0.000s) ok 2426 - defaults_dir_format: should not dump INSERT INTO test_second_table
[14:07:10.804](0.000s) ok 2427 - defaults_dir_format: should not dump INSERT INTO test_table
[14:07:10.804](0.000s) ok 2428 - defaults_dir_format: should not dump INSERT INTO test_table_identity
[14:07:10.805](0.000s) ok 2429 - defaults_dir_format: should not dump INSERT INTO test_third_table
[14:07:10.805](0.000s) ok 2430 - defaults_dir_format: should not dump INSERT INTO test_third_table (colnames)
[14:07:10.805](0.000s) ok 2431 - defaults_dir_format: should dump LO create (using lo_from_bytea)
[14:07:10.805](0.000s) ok 2432 - defaults_dir_format: should dump LO create (with no data)
[14:07:10.806](0.000s) ok 2433 - defaults_dir_format: should dump LO load (using lo_from_bytea)
[14:07:10.806](0.000s) ok 2434 - defaults_dir_format: should dump Partition measurement_y2006m2 creation
[14:07:10.806](0.000s) ok 2435 - defaults_dir_format: should dump REFRESH MATERIALIZED VIEW matview
[14:07:10.806](0.000s) ok 2436 - defaults_dir_format: should not dump REFRESH MATERIALIZED VIEW matview_fourth
[14:07:10.807](0.000s) ok 2437 - defaults_dir_format: should dump REFRESH MATERIALIZED VIEW matview_second
[14:07:10.807](0.000s) ok 2438 - defaults_dir_format: should not dump REFRESH MATERIALIZED VIEW matview_third
[14:07:10.807](0.000s) ok 2439 - defaults_dir_format: should dump REVOKE ALL ON SCHEMA public
[14:07:10.807](0.000s) ok 2440 - defaults_dir_format: should not dump REVOKE CONNECT ON DATABASE dump_test FROM public
[14:07:10.808](0.000s) ok 2441 - defaults_dir_format: should dump REVOKE EXECUTE ON FUNCTION pg_sleep() FROM public
[14:07:10.844](0.036s) ok 2442 - defaults_dir_format: should not dump REVOKE EXECUTE ON FUNCTION pg_stat_reset FROM regress_dump_test_role
[14:07:10.844](0.000s) ok 2443 - defaults_dir_format: should dump REVOKE SELECT ON TABLE pg_proc FROM public
[14:07:10.845](0.000s) ok 2444 - defaults_dir_format: should dump REVOKE USAGE ON LANGUAGE plpgsql FROM public
[14:07:10.845](0.000s) ok 2445 - defaults_dir_format: should dump Replica trigger on partition is altered
[14:07:10.845](0.000s) ok 2446 - defaults_dir_format: should not dump Triggers on partitions are not dropped
[14:07:10.845](0.000s) ok 2447 - defaults_dir_format: should dump extended_statistics_import
[14:07:10.846](0.001s) ok 2448 - defaults_dir_format: should not dump newline of table name in comment
[14:07:10.846](0.000s) ok 2449 - defaults_dir_format: should dump relstats_on_unanalyzed_tables
[14:07:10.846](0.000s) ok 2450 - defaults_dir_format: should dump restrict
[14:07:10.848](0.001s) ok 2451 - defaults_dir_format: should dump statistics_import
[14:07:10.848](0.000s) ok 2452 - defaults_dir_format: should not dump test_table with 4-row INSERTs
[14:07:10.848](0.000s) ok 2453 - defaults_dir_format: should dump unrestrict
# Running: pg_dump --format directory --pipe C:/strawberry/5.42.0.1/perl/bin/perl.EXE -pe '' > C:\cirrus\build\testrun\pg_dump\002_pg_dump\data\tmp_test_9UIx/defaults_dir_format/%f --statistics postgres
[14:07:15.783](4.935s) ok 2454 - defaults_dir_format_pipe: pg_dump runs
# Running: pg_restore --format directory --file C:\cirrus\build\testrun\pg_dump\002_pg_dump\data\tmp_test_9UIx/defaults_dir_format_pipe.sql --pipe C:/strawberry/5.42.0.1/perl/bin/perl.EXE -pe '' C:\cirrus\build\testrun\pg_dump\002_pg_dump\data\tmp_test_9UIx/defaults_dir_format/%f --statistics
[14:07:16.658](0.875s) not ok 2455 - defaults_dir_format_pipe: pg_restore runs
[14:07:16.658](0.000s) #   Failed test 'defaults_dir_format_pipe: pg_restore runs'
#   at C:/cirrus/src/bin/pg_dump/t/002_pg_dump.pl line 5423.
[14:07:16.658](0.000s) # ---------- command failed ----------
[14:07:16.658](0.000s) # pg_restore --format directory --file C:\cirrus\build\testrun\pg_dump\002_pg_dump\data\tmp_test_9UIx/defaults_dir_format_pipe.sql --pipe C:/strawberry/5.42.0.1/perl/bin/perl.EXE -pe '' C:\cirrus\build\testrun\pg_dump\002_pg_dump\data\tmp_test_9UIx/defaults_dir_format/%f --statistics
[14:07:16.659](0.000s) # -------------- stderr --------------
[14:07:16.659](0.000s) # pg_restore: warning: invalid creation date in header
# pg_restore: error: could not read from input file: end of file
[14:07:16.659](0.000s) # ------------------------------------
[14:07:16.662](0.003s) # die: could not open "C:\cirrus\build\testrun\pg_dump\002_pg_dump\data\tmp_test_9UIx/defaults_dir_format_pipe.sql": The system cannot find the file specified at C:/cirrus/src/bin/pg_dump/t/002_pg_dump.pl line 5434.
# 
[14:07:16.662](0.000s) 1..2455
could not open "C:\cirrus\build\testrun\pg_dump\002_pg_dump\data\tmp_test_9UIx/defaults_dir_format_pipe.sql": The system cannot find the file specified at C:/cirrus/src/bin/pg_dump/t/002_pg_dump.pl line 5434.
# Postmaster PID for node "main" is 6732
### Stopping node "main" using mode immediate
# Running: pg_ctl --pgdata C:\cirrus\build/testrun/pg_dump/002_pg_dump\data/t_002_pg_dump_main_data/pgdata --mode immediate stop
waiting for server to shut down.... done
server stopped
# No postmaster PID for node "main"
[14:07:16.810](0.148s) # Looks like your test exited with 1 just after 2455.