postgrespro.git / summary / log / commit / refs
commit eeeb1dfc87fafe1cf4332c09692779662a95511e
Author: Stephen Frost <sfrost@snowman.net>
Date: Mon Dec 10 15:13:52 2018 +0000
Add pg_dump test for empty OP class
This adds a pg_dump test for an empty operator class.
Author: Michael Paquier
Discussion: https://postgr.es/m/20181208011142.GU3415@tamriel.snowman.net
src/bin/pg_dump/t/002_pg_dump.pl | 15 +++++++++++++++
1 file changed, 15 insertions(+)
diff --git a/src/bin/pg_dump/t/002_pg_dump.pl b/src/bin/pg_dump/t/002_pg_dump.pl
index 8f4bb554df..46dbb078cf 100644
--- a/src/bin/pg_dump/t/002_pg_dump.pl
+++ b/src/bin/pg_dump/t/002_pg_dump.pl
@@ -1521,6 +1521,21 @@ my %tests = (
unlike => { exclude_dump_test_schema => 1, },
},
+ 'CREATE OPERATOR CLASS dump_test.op_class_empty' => {
+ create_order => 89,
+ create_sql => 'CREATE OPERATOR CLASS dump_test.op_class_empty
+ FOR TYPE bigint USING btree FAMILY dump_test.op_family
+ AS STORAGE bigint;',
+ regexp => qr/^
+ \QCREATE OPERATOR CLASS dump_test.op_class_empty\E\n\s+
+ \QFOR TYPE bigint USING btree FAMILY dump_test.op_family AS\E\n\s+
+ \QSTORAGE bigint;\E
+ /xm,
+ like =>
+ { %full_runs, %dump_test_schema_runs, section_pre_data => 1, },
+ unlike => { exclude_dump_test_schema => 1, },
+ },
+
'CREATE EVENT TRIGGER test_event_trigger' => {
create_order => 33,
create_sql => 'CREATE EVENT TRIGGER test_event_trigger
[parent: 2d7eeb1b1492]