pgsql: Change PROCEDURE to FUNCTION in CREATE TRIGGER syntax - Mailing list pgsql-committers

From Peter Eisentraut
Subject pgsql: Change PROCEDURE to FUNCTION in CREATE TRIGGER syntax
Date
Msg-id E1fsSwo-000621-Vc@gemulon.postgresql.org
Whole thread Raw
List 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@bowt.ie>
Reviewed-by: Jonathan S. Katz <jonathan.katz@excoventures.com>

Branch
------
REL_11_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/e0dc839e72d43e6c299deca892a8209e11dd88f6

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(-)


pgsql-committers by date:

Previous
From: Thomas Munro
Date:
Subject: pgsql: Wrap long line in postgresql.conf.sample.
Next
From: Peter Eisentraut
Date:
Subject: pgsql: doc: Clarify some wording in PL/pgSQL about transactions