pgsql: Change PROCEDURE to FUNCTION in CREATE TRIGGER syntax

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Change PROCEDURE to FUNCTION in CREATE TRIGGER syntax
Date: 2018-08-22 13:13:18
Message-ID: E1fsSwo-00061w-VC@gemulon.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Change PROCEDURE to FUNCTION in CREATE TRIGGER syntax

Since procedures are now a different thing from functions, change the
CREATE TRIGGER and CREATE EVENT TRIGGER syntax to use FUNCTION in the
clause that specifies the function. PROCEDURE is still accepted for
compatibility.

pg_dump and ruleutils.c output is not changed yet, because that would
require a change in information_schema.sql and thus a catversion change.

Reported-by: Peter Geoghegan <pg(at)bowt(dot)ie>
Reviewed-by: Jonathan S. Katz <jonathan(dot)katz(at)excoventures(dot)com>

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/0a63f996e018ac508c858e87fa39cc254a5db49f

Modified Files
--------------
doc/src/sgml/ddl.sgml | 2 +-
doc/src/sgml/event-trigger.sgml | 4 ++--
doc/src/sgml/func.sgml | 6 +++---
doc/src/sgml/information_schema.sgml | 2 +-
doc/src/sgml/lo.sgml | 2 +-
doc/src/sgml/plperl.sgml | 4 ++--
doc/src/sgml/plpgsql.sgml | 16 ++++++++--------
doc/src/sgml/pltcl.sgml | 4 ++--
doc/src/sgml/ref/create_event_trigger.sgml | 12 ++++++++++--
doc/src/sgml/ref/create_trigger.sgml | 24 ++++++++++++++++--------
doc/src/sgml/tcn.sgml | 2 +-
doc/src/sgml/textsearch.sgml | 4 ++--
doc/src/sgml/trigger.sgml | 4 ++--
src/backend/parser/gram.y | 9 +++++++--
src/test/regress/expected/triggers.out | 4 ++--
src/test/regress/sql/triggers.sql | 4 ++--
16 files changed, 62 insertions(+), 41 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Peter Eisentraut 2018-08-22 13:45:45 pgsql: doc: Clarify some wording in PL/pgSQL about transactions
Previous Message Thomas Munro 2018-08-22 09:37:46 pgsql: Wrap long line in postgresql.conf.sample.