pgAdmin 4 commit: Add Reverse Engineered SQL tests for Trigger Function

From: Dave Page <dpage(at)pgadmin(dot)org>
To: pgadmin-hackers(at)lists(dot)postgresql(dot)org
Subject: pgAdmin 4 commit: Add Reverse Engineered SQL tests for Trigger Function
Date: 2019-08-06 13:26:15
Message-ID: E1huzTj-0001i1-Ov@gothos.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

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(dot)toshniwal(at)enterprisedb(dot)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(-)

Browse pgadmin-hackers by date

  From Date Subject
Next Message Dave Page 2019-08-06 13:28:22 Re: [pgAdmin][RM4554] RE-SQL for trigger functions
Previous Message Dave Page 2019-08-06 13:03:11 Re: [pgAdmin][RM4570] Tree improvement to improve speed of finding a node