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 <aditya.toshniwal@enterprisedb.com>
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(-)