From: | Akshay Joshi <akshay(dot)joshi(at)enterprisedb(dot)com> |
---|---|
To: | pgadmin-hackers(at)lists(dot)postgresql(dot)org |
Subject: | pgAdmin 4 commit: Ensure that trigger function SQL should have 'create |
Date: | 2021-08-24 12:53:38 |
Message-ID: | E1mIVvu-0002nr-Pf@gothos.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-hackers |
Ensure that trigger function SQL should have 'create or replace function' instead of 'create function' only. Fixes #5849
Branch
------
master
Details
-------
https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=e39838455e14d9c688a910550f0953c2b9751789
Author: Aditya Toshniwal <aditya(dot)toshniwal(at)enterprisedb(dot)com>
Modified Files
--------------
docs/en_US/release_notes_5_7.rst | 1 +
.../functions/templates/trigger_functions/pg/sql/11_plus/create.sql | 2 +-
.../functions/templates/trigger_functions/pg/sql/9.2_plus/create.sql | 2 +-
.../functions/templates/trigger_functions/pg/sql/9.5_plus/create.sql | 2 +-
.../functions/templates/trigger_functions/pg/sql/default/create.sql | 2 +-
.../functions/templates/trigger_functions/ppas/sql/9.2_plus/create.sql | 2 +-
.../functions/templates/trigger_functions/ppas/sql/9.5_plus/create.sql | 2 +-
.../functions/templates/trigger_functions/ppas/sql/default/create.sql | 2 +-
.../schemas/functions/tests/pg/11_plus/alter_ptrig_comment.sql | 2 +-
.../databases/schemas/functions/tests/pg/11_plus/alter_ptrig_set_1.sql | 2 +-
.../databases/schemas/functions/tests/pg/11_plus/alter_ptrig_set_2.sql | 2 +-
.../databases/schemas/functions/tests/pg/11_plus/alter_ptrig_set_3.sql | 2 +-
.../schemas/functions/tests/pg/11_plus/create_event_trigger_full.sql | 2 +-
.../schemas/functions/tests/pg/11_plus/create_plain_trigger.sql | 2 +-
.../schemas/functions/tests/pg/11_plus/create_plain_trigger_full.sql | 2 +-
.../schemas/functions/tests/pg/12_plus/alter_ptrig_comment.sql | 2 +-
.../databases/schemas/functions/tests/pg/12_plus/alter_ptrig_set_1.sql | 2 +-
.../databases/schemas/functions/tests/pg/12_plus/alter_ptrig_set_2.sql | 2 +-
.../databases/schemas/functions/tests/pg/12_plus/alter_ptrig_set_3.sql | 2 +-
.../schemas/functions/tests/pg/12_plus/create_event_trigger_full.sql | 2 +-
.../schemas/functions/tests/pg/12_plus/create_plain_trigger.sql | 2 +-
.../schemas/functions/tests/pg/12_plus/create_plain_trigger_full.sql | 2 +-
.../schemas/functions/tests/pg/9.5_plus/alter_ptrig_comment.sql | 2 +-
.../databases/schemas/functions/tests/pg/9.5_plus/alter_ptrig_set_1.sql | 2 +-
.../databases/schemas/functions/tests/pg/9.5_plus/alter_ptrig_set_2.sql | 2 +-
.../databases/schemas/functions/tests/pg/9.5_plus/alter_ptrig_set_3.sql | 2 +-
.../schemas/functions/tests/pg/9.5_plus/create_event_trigger_full.sql | 2 +-
.../schemas/functions/tests/pg/9.5_plus/create_plain_trigger.sql | 2 +-
.../schemas/functions/tests/pg/9.5_plus/create_plain_trigger_full.sql | 2 +-
.../schemas/functions/tests/pg/9.6_plus/alter_ptrig_comment.sql | 2 +-
.../databases/schemas/functions/tests/pg/9.6_plus/alter_ptrig_set_1.sql | 2 +-
.../databases/schemas/functions/tests/pg/9.6_plus/alter_ptrig_set_2.sql | 2 +-
.../databases/schemas/functions/tests/pg/9.6_plus/alter_ptrig_set_3.sql | 2 +-
.../schemas/functions/tests/pg/9.6_plus/create_event_trigger_full.sql | 2 +-
.../schemas/functions/tests/pg/9.6_plus/create_plain_trigger.sql | 2 +-
.../schemas/functions/tests/pg/9.6_plus/create_plain_trigger_full.sql | 2 +-
.../schemas/functions/tests/pg/default/alter_ptrig_comment.sql | 2 +-
.../databases/schemas/functions/tests/pg/default/alter_ptrig_set_1.sql | 2 +-
.../databases/schemas/functions/tests/pg/default/alter_ptrig_set_2.sql | 2 +-
.../databases/schemas/functions/tests/pg/default/alter_ptrig_set_3.sql | 2 +-
.../schemas/functions/tests/pg/default/create_event_trigger_full.sql | 2 +-
.../schemas/functions/tests/pg/default/create_plain_trigger.sql | 2 +-
.../schemas/functions/tests/pg/default/create_plain_trigger_full.sql | 2 +-
.../schemas/functions/tests/ppas/11_plus/alter_ptrig_comment.sql | 2 +-
.../schemas/functions/tests/ppas/11_plus/alter_ptrig_set_1.sql | 2 +-
.../schemas/functions/tests/ppas/11_plus/alter_ptrig_set_2.sql | 2 +-
.../schemas/functions/tests/ppas/11_plus/alter_ptrig_set_3.sql | 2 +-
.../schemas/functions/tests/ppas/11_plus/create_event_trigger_full.sql | 2 +-
.../schemas/functions/tests/ppas/11_plus/create_plain_trigger.sql | 2 +-
.../schemas/functions/tests/ppas/11_plus/create_plain_trigger_full.sql | 2 +-
.../schemas/functions/tests/ppas/12_plus/alter_ptrig_comment.sql | 2 +-
.../schemas/functions/tests/ppas/12_plus/alter_ptrig_set_1.sql | 2 +-
.../schemas/functions/tests/ppas/12_plus/alter_ptrig_set_2.sql | 2 +-
.../schemas/functions/tests/ppas/12_plus/alter_ptrig_set_3.sql | 2 +-
.../schemas/functions/tests/ppas/12_plus/create_event_trigger_full.sql | 2 +-
.../schemas/functions/tests/ppas/12_plus/create_plain_trigger.sql | 2 +-
.../schemas/functions/tests/ppas/12_plus/create_plain_trigger_full.sql | 2 +-
.../schemas/functions/tests/ppas/9.6_plus/alter_ptrig_comment.sql | 2 +-
.../schemas/functions/tests/ppas/9.6_plus/alter_ptrig_set_1.sql | 2 +-
.../schemas/functions/tests/ppas/9.6_plus/alter_ptrig_set_2.sql | 2 +-
.../schemas/functions/tests/ppas/9.6_plus/alter_ptrig_set_3.sql | 2 +-
.../schemas/functions/tests/ppas/9.6_plus/create_event_trigger_full.sql | 2 +-
.../schemas/functions/tests/ppas/9.6_plus/create_plain_trigger.sql | 2 +-
.../schemas/functions/tests/ppas/9.6_plus/create_plain_trigger_full.sql | 2 +-
.../schemas/functions/tests/ppas/default/alter_ptrig_comment.sql | 2 +-
.../schemas/functions/tests/ppas/default/alter_ptrig_set_1.sql | 2 +-
.../schemas/functions/tests/ppas/default/alter_ptrig_set_2.sql | 2 +-
.../schemas/functions/tests/ppas/default/alter_ptrig_set_3.sql | 2 +-
.../schemas/functions/tests/ppas/default/create_event_trigger_full.sql | 2 +-
.../schemas/functions/tests/ppas/default/create_plain_trigger.sql | 2 +-
.../schemas/functions/tests/ppas/default/create_plain_trigger_full.sql | 2 +-
71 files changed, 71 insertions(+), 70 deletions(-)
From | Date | Subject | |
---|---|---|---|
Next Message | Akshay Joshi | 2021-08-24 12:54:13 | Re: [pgAdmin][RM6495] ERD 1:M relationship - allow the referenced table to be the same as the local table. |
Previous Message | Aditya Toshniwal | 2021-08-24 12:00:58 | [pgAdmin][RM5849] "create or replace" for trigger functions |