summary | shortlog | log | commit | commitdiff | tree
raw | patch | inline | side by side (parent: 691d99d)
raw | patch | inline | side by side (parent: 691d99d)
| author | Tom Lane <tgl@sss.pgh.pa.us> | |
| Sat, 7 May 2016 20:36:50 +0000 (16:36 -0400) | ||
| committer | Tom Lane <tgl@sss.pgh.pa.us> | |
| Sat, 7 May 2016 20:36:50 +0000 (16:36 -0400) |
It emerges that some Perl versions before 5.8.9 have a bug with regexps
that use the /m flag and contain "$". This is the reason why jacana
is still failing on HEAD, and I was able to duplicate the failure on
prairiedog's host. There's no real need for "$" in these patterns,
since they are already matching through the statement-terminating
semicolons (or matching an explicit \n in some cases). So just
remove it.
Note: the reason jacana hasn't actually reported any failures in the
last little while is that the way the pg_dump TAP tests are set up, any
failure of this sort results in echoing the entire pg_dump dump output
to stderr. Since there were about a hundred such failures, that resulted
in a 30MB log file which choked the buildfarm upload script. There is
room for improvement here :-(.
Per off-list discussion with Andrew and Stephen.
that use the /m flag and contain "$". This is the reason why jacana
is still failing on HEAD, and I was able to duplicate the failure on
prairiedog's host. There's no real need for "$" in these patterns,
since they are already matching through the statement-terminating
semicolons (or matching an explicit \n in some cases). So just
remove it.
Note: the reason jacana hasn't actually reported any failures in the
last little while is that the way the pg_dump TAP tests are set up, any
failure of this sort results in echoing the entire pg_dump dump output
to stderr. Since there were about a hundred such failures, that resulted
in a 30MB log file which choked the buildfarm upload script. There is
room for improvement here :-(.
Per off-list discussion with Andrew and Stephen.
| src/bin/pg_dump/t/002_pg_dump.pl | patch | blob | blame | history |
index 96b6b573da73608a4e060fa9b6fb7a4dd7692cca..b44d71f2e0dee0f46e4a8008581f40717ae395dd 100644 (file)
\QALTER DEFAULT PRIVILEGES \E
\QFOR ROLE dump_test IN SCHEMA dump_test \E
\QGRANT SELECT ON TABLES TO dump_test;\E
- $/xm,
+ /xm,
like => {
binary_upgrade => 1,
clean => 1,
\QALTER ROLE dump_test WITH \E
\QNOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB NOLOGIN \E
\QNOREPLICATION NOBYPASSRLS;\E
- $/xm,
+ /xm,
like => {
pg_dumpall_globals => 1,
},
regexp => qr/^
\QALTER FUNCTION dump_test.pltestlang_call_handler() \E
\QOWNER TO \E
- .*;$/xm,
+ .*;/xm,
like => {
binary_upgrade => 1,
clean => 1,
},
},
'ALTER PROCEDURAL LANGUAGE pltestlang OWNER TO' => {
- regexp => qr/^ALTER PROCEDURAL LANGUAGE pltestlang OWNER TO .*;$/m,
+ regexp => qr/^ALTER PROCEDURAL LANGUAGE pltestlang OWNER TO .*;/m,
like => {
binary_upgrade => 1,
clean => 1,
},
},
'ALTER SCHEMA dump_test OWNER TO' => {
- regexp => qr/^ALTER SCHEMA dump_test OWNER TO .*;$/m,
+ regexp => qr/^ALTER SCHEMA dump_test OWNER TO .*;/m,
like => {
binary_upgrade => 1,
clean => 1,
},
},
'ALTER SCHEMA dump_test_second_schema OWNER TO' => {
- regexp => qr/^ALTER SCHEMA dump_test_second_schema OWNER TO .*;$/m,
+ regexp => qr/^ALTER SCHEMA dump_test_second_schema OWNER TO .*;/m,
like => {
binary_upgrade => 1,
clean => 1,
regexp => qr/^
\QALTER TABLE ONLY test_table\E \n^\s+
\QADD CONSTRAINT test_table_pkey PRIMARY KEY (col1);\E
- $/xm,
+ /xm,
like => {
binary_upgrade => 1,
clean => 1,
},
},
'ALTER TABLE test_table OWNER TO' => {
- regexp => qr/^ALTER TABLE test_table OWNER TO .*;$/m,
+ regexp => qr/^ALTER TABLE test_table OWNER TO .*;/m,
like => {
binary_upgrade => 1,
clean => 1,
create_order => 23,
create_sql => 'ALTER TABLE dump_test.test_table
ENABLE ROW LEVEL SECURITY;',
- regexp => qr/^ALTER TABLE test_table ENABLE ROW LEVEL SECURITY;$/m,
+ regexp => qr/^ALTER TABLE test_table ENABLE ROW LEVEL SECURITY;/m,
like => {
binary_upgrade => 1,
clean => 1,
},
},
'ALTER TABLE test_second_table OWNER TO' => {
- regexp => qr/^ALTER TABLE test_second_table OWNER TO .*;$/m,
+ regexp => qr/^ALTER TABLE test_second_table OWNER TO .*;/m,
like => {
binary_upgrade => 1,
clean => 1,
},
},
'ALTER TABLE test_third_table OWNER TO' => {
- regexp => qr/^ALTER TABLE test_third_table OWNER TO .*;$/m,
+ regexp => qr/^ALTER TABLE test_third_table OWNER TO .*;/m,
like => {
binary_upgrade => 1,
clean => 1,
},
# catch-all for ALTER ... OWNER (except LARGE OBJECTs)
'ALTER ... OWNER commands (except LARGE OBJECTs)' => {
- regexp => qr/^ALTER (?!LARGE OBJECT)(.*) OWNER TO .*;$/m,
+ regexp => qr/^ALTER (?!LARGE OBJECT)(.*) OWNER TO .*;/m,
like => { }, # use more-specific options above
unlike => {
column_inserts => 1,
},
# catch-all for ALTER ... OWNER
'ALTER ... OWNER commands' => {
- regexp => qr/^ALTER .* OWNER TO .*;$/m,
+ regexp => qr/^ALTER .* OWNER TO .*;/m,
like => { }, # use more-specific options above
unlike => {
no_owner => 1,
# \QSELECT pg_catalog.lowrite(0, \E
# \Q'\x310a320a330a340a350a360a370a380a390a');\E\n
# \QSELECT pg_catalog.lo_close(0);\E
-# $/xm,
+# /xm,
# like => {
# clean => 1,
# clean_if_exists => 1,
# },
# },
'COMMENT ON DATABASE postgres' => {
- regexp => qr/^COMMENT ON DATABASE postgres IS .*;$/m,
+ regexp => qr/^COMMENT ON DATABASE postgres IS .*;/m,
like => {
binary_upgrade => 1,
clean => 1,
},
},
'COMMENT ON EXTENSION plpgsql' => {
- regexp => qr/^COMMENT ON EXTENSION plpgsql IS .*;$/m,
+ regexp => qr/^COMMENT ON EXTENSION plpgsql IS .*;/m,
like => {
clean => 1,
clean_if_exists => 1,
create_order => 36,
create_sql => 'COMMENT ON TABLE dump_test.test_table
IS \'comment on table\';',
- regexp => qr/^COMMENT ON TABLE test_table IS 'comment on table';$/m,
+ regexp => qr/^COMMENT ON TABLE test_table IS 'comment on table';/m,
like => {
binary_upgrade => 1,
clean => 1,
IS \'comment on column\';',
regexp => qr/^
\QCOMMENT ON COLUMN test_table.col1 IS 'comment on column';\E
- $/xm,
+ /xm,
like => {
binary_upgrade => 1,
clean => 1,
IS \'comment on column of type\';',
regexp => qr/^
\QCOMMENT ON COLUMN composite.f1 IS 'comment on column of type';\E
- $/xm,
+ /xm,
like => {
binary_upgrade => 1,
clean => 1,
regexp => qr/^
\QCOPY test_table (col1) FROM stdin;\E
\n(?:\d\n){9}\\\.\n
- $/xm,
+ /xm,
like => {
clean => 1,
clean_if_exists => 1,
regexp => qr/^
\QCOPY fk_reference_test_table (col1) FROM stdin;\E
\n(?:\d\n){5}\\\.\n
- $/xm,
+ /xm,
like => {
clean => 1,
clean_if_exists => 1,
\n(?:\d\n){9}\\\.\n.*
\QCOPY fk_reference_test_table (col1) FROM stdin;\E
\n(?:\d\n){5}\\\.\n
- $/xms,
+ /xms,
like => {
data_only => 1,
},
regexp => qr/^
\QCOPY test_second_table (col1, col2) FROM stdin;\E
\n(?:\d\t\d\n){9}\\\.\n
- $/xm,
+ /xm,
like => {
clean => 1,
clean_if_exists => 1,
regexp => qr/^
\QCOPY test_third_table (col1) FROM stdin;\E
\n(?:\d\n){9}\\\.\n
- $/xm,
+ /xm,
like => {
clean => 1,
clean_if_exists => 1,
'INSERT INTO test_table' => {
regexp => qr/^
(?:INSERT\ INTO\ test_table\ \(col1\)\ VALUES\ \(\d\);\n){9}
- $/xm,
+ /xm,
like => {
column_inserts => 1,
},
'INSERT INTO test_second_table' => {
regexp => qr/^
(?:INSERT\ INTO\ test_second_table\ \(col1,\ col2\)
- \ VALUES\ \(\d,\ '\d'\);\n){9}$/xm,
+ \ VALUES\ \(\d,\ '\d'\);\n){9}/xm,
like => {
column_inserts => 1,
},
'INSERT INTO test_third_table' => {
regexp => qr/^
(?:INSERT\ INTO\ test_third_table\ \(col1\)
- \ VALUES\ \(\d\);\n){9}$/xm,
+ \ VALUES\ \(\d\);\n){9}/xm,
like => {
column_inserts => 1,
},
'CREATE ROLE dump_test' => {
create_order => 1,
create_sql => 'CREATE ROLE dump_test;',
- regexp => qr/^CREATE ROLE dump_test;$/m,
+ regexp => qr/^CREATE ROLE dump_test;/m,
like => {
pg_dumpall_globals => 1,
},
'CREATE DATABASE postgres' => {
regexp => qr/^
\QCREATE DATABASE postgres WITH TEMPLATE = template0 \E
- .*;$/xm,
+ .*;/xm,
like => {
createdb => 1,
},
'CREATE EXTENSION ... plpgsql' => {
regexp => qr/^
\QCREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;\E
- $/xm,
+ /xm,
like => {
clean => 1,
clean_if_exists => 1,
\n\s+\QSTYPE = bigint[],\E
\n\s+\QINITCOND = '{0,0}',\E
\n\s+\QFINALFUNC = int8_avg\E
- \n\);$/xm,
+ \n\);/xm,
like => {
binary_upgrade => 1,
clean => 1,
\Q(((VALUE ~ '^\d{5}\E
\$\Q'::text) OR (VALUE ~ '^\d{5}-\d{4}\E\$
\Q'::text)));\E
- $/xm,
+ /xm,
like => {
binary_upgrade => 1,
clean => 1,
\n\s+\QLANGUAGE c\E
\n\s+AS\ \'\$
\Qlibdir\/plpgsql', 'plpgsql_call_handler';\E
- $/xm,
+ /xm,
like => {
binary_upgrade => 1,
clean => 1,
\n\s+\QLANGUAGE plpgsql\E
\n\s+AS\ \$\$
\Q BEGIN RETURN NULL; END;\E
- \$\$;$/xm,
+ \$\$;/xm,
like => {
binary_upgrade => 1,
clean => 1,
\n\s+\QLANGUAGE plpgsql\E
\n\s+AS\ \$\$
\Q BEGIN RETURN; END;\E
- \$\$;$/xm,
+ \$\$;/xm,
like => {
binary_upgrade => 1,
clean => 1,
\QCREATE EVENT TRIGGER test_event_trigger \E
\QON ddl_command_start\E
\n\s+\QEXECUTE PROCEDURE dump_test.event_trigger_func();\E
- $/xm,
+ /xm,
like => {
binary_upgrade => 1,
clean => 1,
\QCREATE TRIGGER test_trigger BEFORE INSERT ON test_table \E
\QFOR EACH ROW WHEN ((new.col1 > 10)) \E
\QEXECUTE PROCEDURE trigger_func();\E
- $/xm,
+ /xm,
like => {
binary_upgrade => 1,
clean => 1,
\n\s+'venus',
\n\s+'earth',
\n\s+'mars'
- \n\);$/xm,
+ \n\);/xm,
like => {
clean => 1,
clean_if_exists => 1,
\QALTER TYPE dump_test.planets ADD VALUE 'earth';\E
\n.*^
\QALTER TYPE dump_test.planets ADD VALUE 'mars';\E
- \n$/xms,
+ \n/xms,
like => {
binary_upgrade => 1,
},
\QCREATE FUNCTION int42_in(cstring) RETURNS int42\E
\n\s+\QLANGUAGE internal IMMUTABLE STRICT\E
\n\s+AS\ \$\$int4in\$\$;
- $/xm,
+ /xm,
like => {
binary_upgrade => 1,
clean => 1,
\QCREATE FUNCTION int42_out(int42) RETURNS cstring\E
\n\s+\QLANGUAGE internal IMMUTABLE STRICT\E
\n\s+AS\ \$\$int4out\$\$;
- $/xm,
+ /xm,
like => {
binary_upgrade => 1,
clean => 1,
\n\s+\QALIGNMENT = int4,\E
\n\s+\QSTORAGE = plain,\E
\n\s+PASSEDBYVALUE\n\);
- $/xm,
+ /xm,
like => {
clean => 1,
clean_if_exists => 1,
\n\s+\Qf1 integer,\E
\n\s+\Qf2 int42\E
\n\);
- $/xm,
+ /xm,
like => {
clean => 1,
clean_if_exists => 1,
regexp => qr/^
\QCREATE PROCEDURAL LANGUAGE pltestlang \E
\QHANDLER pltestlang_call_handler;\E
- $/xm,
+ /xm,
like => {
binary_upgrade => 1,
clean => 1,
\n\s+\QSELECT test_table.col1\E
\n\s+\QFROM test_table\E
\n\s+\QWITH NO DATA;\E
- $/xm,
+ /xm,
like => {
binary_upgrade => 1,
clean => 1,
\n\s+\QSELECT matview.col1\E
\n\s+\QFROM matview\E
\n\s+\QWITH NO DATA;\E
- $/xm,
+ /xm,
like => {
binary_upgrade => 1,
clean => 1,
regexp => qr/^
\QCREATE POLICY p1 ON test_table FOR ALL TO PUBLIC \E
\QUSING (true) WITH CHECK (true);\E
- $/xm,
+ /xm,
like => {
binary_upgrade => 1,
clean => 1,
regexp => qr/^
\QCREATE POLICY p2 ON test_table FOR SELECT TO dump_test \E
\QUSING (true);\E
- $/xm,
+ /xm,
like => {
binary_upgrade => 1,
clean => 1,
regexp => qr/^
\QCREATE POLICY p3 ON test_table FOR INSERT \E
\QTO dump_test WITH CHECK (true);\E
- $/xm,
+ /xm,
like => {
binary_upgrade => 1,
clean => 1,
regexp => qr/^
\QCREATE POLICY p4 ON test_table FOR UPDATE TO dump_test \E
\QUSING (true) WITH CHECK (true);\E
- $/xm,
+ /xm,
like => {
binary_upgrade => 1,
clean => 1,
regexp => qr/^
\QCREATE POLICY p5 ON test_table FOR DELETE \E
\QTO dump_test USING (true);\E
- $/xm,
+ /xm,
like => {
binary_upgrade => 1,
clean => 1,
'CREATE SCHEMA dump_test' => {
create_order => 2,
create_sql => 'CREATE SCHEMA dump_test;',
- regexp => qr/^CREATE SCHEMA dump_test;$/m,
+ regexp => qr/^CREATE SCHEMA dump_test;/m,
like => {
binary_upgrade => 1,
clean => 1,
'CREATE SCHEMA dump_test_second_schema' => {
create_order => 9,
create_sql => 'CREATE SCHEMA dump_test_second_schema;',
- regexp => qr/^CREATE SCHEMA dump_test_second_schema;$/m,
+ regexp => qr/^CREATE SCHEMA dump_test_second_schema;/m,
like => {
binary_upgrade => 1,
clean => 1,
\n\s+\Qcol1 integer NOT NULL,\E
\n\s+\QCONSTRAINT test_table_col1_check CHECK \E
\Q((col1 <= 1000))\E
- \n\);$/xm,
+ \n\);/xm,
like => {
binary_upgrade => 1,
clean => 1,
\QCREATE TABLE fk_reference_test_table (\E
\n\s+\Qcol1 integer NOT NULL\E
\n\);
- $/xm,
+ /xm,
like => {
binary_upgrade => 1,
clean => 1,
\n\s+\Qcol1 integer,\E
\n\s+\Qcol2 text\E
\n\);
- $/xm,
+ /xm,
like => {
binary_upgrade => 1,
clean => 1,
\QCREATE TABLE test_third_table (\E
\n\s+\Qcol1 integer NOT NULL\E
\n\);
- $/xm,
+ /xm,
like => {
binary_upgrade => 1,
clean => 1,
\n\s+\QNO MINVALUE\E
\n\s+\QNO MAXVALUE\E
\n\s+\QCACHE 1;\E
- $/xm,
+ /xm,
like => {
binary_upgrade => 1,
clean => 1,
\n\s+\QNO MINVALUE\E
\n\s+\QNO MAXVALUE\E
\n\s+\QCACHE 1;\E
- $/xm,
+ /xm,
like => {
binary_upgrade => 1,
clean => 1,
regexp => qr/^
\QCREATE UNIQUE INDEX test_third_table_idx \E
\QON test_third_table USING btree (col1);\E
- $/xm,
+ /xm,
like => {
binary_upgrade => 1,
clean => 1,
},
},
'DROP EXTENSION plpgsql' => {
- regexp => qr/^DROP EXTENSION plpgsql;$/m,
+ regexp => qr/^DROP EXTENSION plpgsql;/m,
like => {
clean => 1,
},
},
},
'DROP FUNCTION dump_test.pltestlang_call_handler()' => {
- regexp => qr/^DROP FUNCTION dump_test\.pltestlang_call_handler\(\);$/m,
+ regexp => qr/^DROP FUNCTION dump_test\.pltestlang_call_handler\(\);/m,
like => {
clean => 1,
},
},
},
'DROP LANGUAGE pltestlang' => {
- regexp => qr/^DROP PROCEDURAL LANGUAGE pltestlang;$/m,
+ regexp => qr/^DROP PROCEDURAL LANGUAGE pltestlang;/m,
like => {
clean => 1,
},
},
},
'DROP SCHEMA dump_test' => {
- regexp => qr/^DROP SCHEMA dump_test;$/m,
+ regexp => qr/^DROP SCHEMA dump_test;/m,
like => {
clean => 1,
},
},
},
'DROP SCHEMA dump_test_second_schema' => {
- regexp => qr/^DROP SCHEMA dump_test_second_schema;$/m,
+ regexp => qr/^DROP SCHEMA dump_test_second_schema;/m,
like => {
clean => 1,
},
},
},
'DROP TABLE test_table' => {
- regexp => qr/^DROP TABLE dump_test\.test_table;$/m,
+ regexp => qr/^DROP TABLE dump_test\.test_table;/m,
like => {
clean => 1,
},
},
},
'DROP TABLE fk_reference_test_table' => {
- regexp => qr/^DROP TABLE dump_test\.fk_reference_test_table;$/m,
+ regexp => qr/^DROP TABLE dump_test\.fk_reference_test_table;/m,
like => {
clean => 1,
},
},
},
'DROP TABLE test_second_table' => {
- regexp => qr/^DROP TABLE dump_test\.test_second_table;$/m,
+ regexp => qr/^DROP TABLE dump_test\.test_second_table;/m,
like => {
clean => 1,
},
},
},
'DROP TABLE test_third_table' => {
- regexp => qr/^DROP TABLE dump_test_second_schema\.test_third_table;$/m,
+ regexp => qr/^DROP TABLE dump_test_second_schema\.test_third_table;/m,
like => {
clean => 1,
},
},
},
'DROP EXTENSION IF EXISTS plpgsql' => {
- regexp => qr/^DROP EXTENSION IF EXISTS plpgsql;$/m,
+ regexp => qr/^DROP EXTENSION IF EXISTS plpgsql;/m,
like => {
clean_if_exists => 1,
},
'DROP FUNCTION IF EXISTS dump_test.pltestlang_call_handler()' => {
regexp => qr/^
\QDROP FUNCTION IF EXISTS dump_test.pltestlang_call_handler();\E
- $/xm,
+ /xm,
like => {
clean_if_exists => 1,
},
},
},
'DROP LANGUAGE IF EXISTS pltestlang' => {
- regexp => qr/^DROP PROCEDURAL LANGUAGE IF EXISTS pltestlang;$/m,
+ regexp => qr/^DROP PROCEDURAL LANGUAGE IF EXISTS pltestlang;/m,
like => {
clean_if_exists => 1,
},
},
},
'DROP SCHEMA IF EXISTS dump_test' => {
- regexp => qr/^DROP SCHEMA IF EXISTS dump_test;$/m,
+ regexp => qr/^DROP SCHEMA IF EXISTS dump_test;/m,
like => {
clean_if_exists => 1,
},
},
},
'DROP SCHEMA IF EXISTS dump_test_second_schema' => {
- regexp => qr/^DROP SCHEMA IF EXISTS dump_test_second_schema;$/m,
+ regexp => qr/^DROP SCHEMA IF EXISTS dump_test_second_schema;/m,
like => {
clean_if_exists => 1,
},
},
},
'DROP TABLE IF EXISTS test_table' => {
- regexp => qr/^DROP TABLE IF EXISTS dump_test\.test_table;$/m,
+ regexp => qr/^DROP TABLE IF EXISTS dump_test\.test_table;/m,
like => {
clean_if_exists => 1,
},
},
},
'DROP TABLE IF EXISTS test_second_table' => {
- regexp => qr/^DROP TABLE IF EXISTS dump_test\.test_second_table;$/m,
+ regexp => qr/^DROP TABLE IF EXISTS dump_test\.test_second_table;/m,
like => {
clean_if_exists => 1,
},
'DROP TABLE IF EXISTS test_third_table' => {
regexp => qr/^
\QDROP TABLE IF EXISTS dump_test_second_schema.test_third_table;\E
- $/xm,
+ /xm,
like => {
clean_if_exists => 1,
},
TO dump_test;',
regexp => qr/^
\QGRANT USAGE ON SCHEMA dump_test_second_schema TO dump_test;\E
- $/xm,
+ /xm,
like => {
binary_upgrade => 1,
clean => 1,
create_order => 5,
create_sql => 'GRANT SELECT ON TABLE dump_test.test_table
TO dump_test;',
- regexp => qr/^GRANT SELECT ON TABLE test_table TO dump_test;$/m,
+ regexp => qr/^GRANT SELECT ON TABLE test_table TO dump_test;/m,
like => {
binary_upgrade => 1,
clean => 1,
create_sql => 'GRANT SELECT ON
TABLE dump_test_second_schema.test_third_table
TO dump_test;',
- regexp => qr/^GRANT SELECT ON TABLE test_third_table TO dump_test;$/m,
+ regexp => qr/^GRANT SELECT ON TABLE test_third_table TO dump_test;/m,
like => {
binary_upgrade => 1,
clean => 1,
TO dump_test;',
regexp => qr/^
\QGRANT ALL ON SEQUENCE test_third_table_col1_seq TO dump_test;\E
- $/xm,
+ /xm,
like => {
binary_upgrade => 1,
clean => 1,
TO dump_test;',
regexp => qr/^
\QGRANT INSERT(col1) ON TABLE test_second_table TO dump_test;\E
- $/xm,
+ /xm,
like => {
binary_upgrade => 1,
clean => 1,
TO dump_test;',
regexp => qr/^
\QGRANT ALL ON FUNCTION pg_sleep(double precision) TO dump_test;\E
- $/xm,
+ /xm,
like => {
binary_upgrade => 1,
clean => 1,
\QGRANT SELECT(prosrc) ON TABLE pg_proc TO PUBLIC;\E\n.*
\QGRANT SELECT(probin) ON TABLE pg_proc TO PUBLIC;\E\n.*
\QGRANT SELECT(proconfig) ON TABLE pg_proc TO PUBLIC;\E\n.*
- \QGRANT SELECT(proacl) ON TABLE pg_proc TO PUBLIC;\E$/xms,
+ \QGRANT SELECT(proacl) ON TABLE pg_proc TO PUBLIC;\E/xms,
like => {
binary_upgrade => 1,
clean => 1,
},
},
'REFRESH MATERIALIZED VIEW matview' => {
- regexp => qr/^REFRESH MATERIALIZED VIEW matview;$/m,
+ regexp => qr/^REFRESH MATERIALIZED VIEW matview;/m,
like => {
clean => 1,
clean_if_exists => 1,
\QREFRESH MATERIALIZED VIEW matview;\E
\n.*
\QREFRESH MATERIALIZED VIEW matview_second;\E
- $/xms,
+ /xms,
like => {
clean => 1,
clean_if_exists => 1,
FROM public;',
regexp => qr/^
\QREVOKE ALL ON FUNCTION pg_sleep(double precision) FROM PUBLIC;\E
- $/xm,
+ /xm,
like => {
binary_upgrade => 1,
clean => 1,
'REVOKE SELECT ON TABLE pg_proc FROM public' => {
create_order => 45,
create_sql => 'REVOKE SELECT ON TABLE pg_proc FROM public;',
- regexp => qr/^REVOKE SELECT ON TABLE pg_proc FROM PUBLIC;$/m,
+ regexp => qr/^REVOKE SELECT ON TABLE pg_proc FROM PUBLIC;/m,
like => {
binary_upgrade => 1,
clean => 1,
regexp => qr/^
\QREVOKE ALL ON SCHEMA public FROM PUBLIC;\E
\n\QGRANT USAGE ON SCHEMA public TO PUBLIC;\E
- $/xm,
+ /xm,
like => {
binary_upgrade => 1,
clean => 1,
'REVOKE USAGE ON LANGUAGE plpgsql FROM public' => {
create_order => 16,
create_sql => 'REVOKE USAGE ON LANGUAGE plpgsql FROM public;',
- regexp => qr/^REVOKE ALL ON LANGUAGE plpgsql FROM PUBLIC;$/m,
+ regexp => qr/^REVOKE ALL ON LANGUAGE plpgsql FROM PUBLIC;/m,
like => {
binary_upgrade => 1,
clean => 1,