Commit0a40f33

committed

Add pg_dump test for triggers on partitioned tables

This currently works, but add this test to ensure it continues to work.Lack of this test became evident after a recent bugfix submission thatwould have inadvertently broken it, inhttps://postgr.es/m/CA+HiwqFM2=i+uHB9o4OkLbE2S3sjPHoVe2wXuAD1GLJ4+Pk9eg@mail.gmail.com

1 parente6cf172 commit0a40f33Copy full SHA for 0a40f33

File tree

+26

-0

lines changed

+26

-0

lines changed

Lines changed: 26 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -2370,6 +2370,32 @@`
`2370`	`2370`	`},`
`2371`	`2371`	`},`
`2372`	`2372`
	`2373`	`+'Creation of row-level trigger in partitioned table' => {`
	`2374`	`+create_order => 92,`
	`2375`	`+create_sql => 'CREATE TRIGGER test_trigger`
	`2376`	`+ AFTER INSERT ON dump_test.measurement`
	`2377`	`+ FOR EACH ROW EXECUTE PROCEDURE dump_test.trigger_func()',`
	`2378`	`+regexp => qr/^`
	`2379`	`+\QCREATE TRIGGER test_trigger AFTER INSERT ON dump_test.measurement\E`
	`2380`	`+\QFOR EACH ROW\E`
	`2381`	`+\QEXECUTE PROCEDURE dump_test.trigger_func();\E`
	`2382`	`+/xm,`
	`2383`	`+like => {`
	`2384`	`+%full_runs,%dump_test_schema_runs, section_post_data => 1,`
	`2385`	`+},`
	`2386`	`+unlike => {`
	`2387`	`+exclude_dump_test_schema => 1,`
	`2388`	`+},`
	`2389`	`+},`
	`2390`	`+`
	`2391`	`+# this shouldn't ever get emitted`
	`2392`	`+'Creation of row-level trigger in partition' => {`
	`2393`	`+regexp => qr/^`
	`2394`	`+\QCREATE TRIGGER test_trigger AFTER INSERT ON dump_test_second_schema.measurement\E`
	`2395`	`+/xm,`
	`2396`	`+like => {},`
	`2397`	`+},`
	`2398`	`+`
`2373`	`2399`	`'CREATE TABLE test_fourth_table_zero_col' => {`
`2374`	`2400`	`create_order => 6,`
`2375`	`2401`	`create_sql => 'CREATE TABLE dump_test.test_fourth_table (`

Comments

(0)