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 <[email protected]> Reviewed-by: Jonathan S. Katz <[email protected]> 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(-)
