diff options
| author | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2019-12-27 18:34:30 -0300 |
|---|---|---|
| committer | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2019-12-27 18:34:30 -0300 |
| commit | 27a3b2ad836c9e7dd243bfebc760a9df9d6fd5a3 (patch) | |
| tree | 3efebf3bcbc2ce7b08e6a5349f2afdf3afa90689 /src | |
| parent | a9760d0f3cb523336b5fdd9d6c5985e39a8588a1 (diff) | |
| download | postgresql-27a3b2ad836c9e7dd243bfebc760a9df9d6fd5a3.tar.gz postgresql-27a3b2ad836c9e7dd243bfebc760a9df9d6fd5a3.zip | |
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 that
would have inadvertently broken it, in
https://postgr.es/m/CA+HiwqFM2=i+uHB9o4OkLbE2S3sjPHoVe2wXuAD1GLJ4+Pk9eg@mail.gmail.com
Diffstat (limited to 'src')
| -rw-r--r-- | src/bin/pg_dump/t/002_pg_dump.pl | 26 |
1 files changed, 26 insertions, 0 deletions
diff --git a/src/bin/pg_dump/t/002_pg_dump.pl b/src/bin/pg_dump/t/002_pg_dump.pl index 11634204913..4a9764c2d22 100644 --- a/src/bin/pg_dump/t/002_pg_dump.pl +++ b/src/bin/pg_dump/t/002_pg_dump.pl @@ -2377,6 +2377,32 @@ my %tests = ( }, }, + 'Creation of row-level trigger in partitioned table' => { + create_order => 92, + create_sql => 'CREATE TRIGGER test_trigger + AFTER INSERT ON dump_test.measurement + FOR EACH ROW EXECUTE PROCEDURE dump_test.trigger_func()', + regexp => qr/^ + \QCREATE TRIGGER test_trigger AFTER INSERT ON dump_test.measurement \E + \QFOR EACH ROW \E + \QEXECUTE FUNCTION dump_test.trigger_func();\E + /xm, + like => { + %full_runs, %dump_test_schema_runs, section_post_data => 1, + }, + unlike => { + exclude_dump_test_schema => 1, + }, + }, + + # this shouldn't ever get emitted + 'Creation of row-level trigger in partition' => { + regexp => qr/^ + \QCREATE TRIGGER test_trigger AFTER INSERT ON dump_test_second_schema.measurement\E + /xm, + like => {}, + }, + 'CREATE TABLE test_fourth_table_zero_col' => { create_order => 6, create_sql => 'CREATE TABLE dump_test.test_fourth_table ( |