pgAdmin 4 commit: Add Reverse Engineered SQL tests for Trigger Function
Dave Page <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.pgadmin.devel |
|---|---|
| Message-ID | <[email protected]> |
Add Reverse Engineered SQL tests for Trigger Functions. Fixes #4554 Fix the reverse engineered SQL for trigger functions with the WINDOW option selected. Fixes #4565 Branch ------ master Details ------- https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=9cdb3b40abdf8270696ab5d05d5352e05984b161 Author: Aditya Toshniwal <[email protected]> Modified Files -------------- docs/en_US/release_notes_4_12.rst | 4 +- .../trigger_functions/pg/sql/11_plus/create.sql | 10 +- .../pg/sql/11_plus/properties.sql | 4 +- .../trigger_functions/pg/sql/11_plus/update.sql | 2 +- .../trigger_functions/pg/sql/9.2_plus/create.sql | 9 +- .../trigger_functions/pg/sql/9.2_plus/update.sql | 4 +- .../trigger_functions/pg/sql/9.5_plus/create.sql | 10 +- .../trigger_functions/pg/sql/9.5_plus/update.sql | 2 +- .../trigger_functions/pg/sql/default/create.sql | 4 +- .../trigger_functions/pg/sql/default/update.sql | 2 +- .../ppas/sql/11_plus/properties.sql | 4 +- .../trigger_functions/ppas/sql/9.2_plus/create.sql | 10 +- .../trigger_functions/ppas/sql/9.2_plus/update.sql | 2 +- .../trigger_functions/ppas/sql/9.5_plus/create.sql | 10 +- .../trigger_functions/ppas/sql/9.5_plus/update.sql | 2 +- .../trigger_functions/ppas/sql/default/create.sql | 4 +- .../trigger_functions/ppas/sql/default/update.sql | 2 +- .../tests/pg/default/alter_ptrig_comment.sql | 18 ++ .../tests/pg/default/alter_ptrig_set_1.sql | 18 ++ .../tests/pg/default/alter_ptrig_set_2.sql | 19 +++ .../tests/pg/default/alter_ptrig_set_3.sql | 20 +++ .../tests/pg/default/create_event_trigger_full.sql | 24 +++ .../tests/pg/default/create_plain_trigger.sql | 15 ++ .../tests/pg/default/create_plain_trigger_full.sql | 24 +++ .../tests/pg/default/test_trigger_functions.json | 182 +++++++++++++++++++++ .../tests/ppas/default/alter_ptrig_comment.sql | 18 ++ .../tests/ppas/default/alter_ptrig_set_1.sql | 18 ++ .../tests/ppas/default/alter_ptrig_set_2.sql | 19 +++ .../tests/ppas/default/alter_ptrig_set_3.sql | 20 +++ .../ppas/default/create_event_trigger_full.sql | 20 +++ .../tests/ppas/default/create_plain_trigger.sql | 15 ++ .../ppas/default/create_plain_trigger_full.sql | 20 +++ .../tests/ppas/default/test_trigger_functions.json | 162 ++++++++++++++++++ 33 files changed, 657 insertions(+), 40 deletions(-)