pgAdmin 4 commit: Ensure that trigger function SQL should have 'create - Mailing list pgadmin-hackers

From Akshay Joshi
Subject pgAdmin 4 commit: Ensure that trigger function SQL should have 'create
Date
Msg-id E1mIVvu-0002nr-Pf@gothos.postgresql.org
Whole thread Raw
List 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.toshniwal@enterprisedb.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(-)


pgadmin-hackers by date:

Previous
From: Aditya Toshniwal
Date:
Subject: [pgAdmin][RM5849] "create or replace" for trigger functions
Next
From: Akshay Joshi
Date:
Subject: Re: [pgAdmin][RM6495] ERD 1:M relationship - allow the referenced table to be the same as the local table.