]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Change PROCEDURE to FUNCTION in CREATE TRIGGER syntax
authorPeter Eisentraut <peter_e@gmx.net>
Wed, 15 Aug 2018 21:08:34 +0000 (23:08 +0200)
committerPeter Eisentraut <peter_e@gmx.net>
Wed, 22 Aug 2018 12:45:07 +0000 (14:45 +0200)
commite0dc839e72d43e6c299deca892a8209e11dd88f6
tree47470067c9f3b31be8f28fd9c3cb370fc3572352
parentfd4417e8ac46ea4cb079ed53f849dc48199506d6
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>
16 files changed:
doc/src/sgml/ddl.sgml
doc/src/sgml/event-trigger.sgml
doc/src/sgml/func.sgml
doc/src/sgml/information_schema.sgml
doc/src/sgml/lo.sgml
doc/src/sgml/plperl.sgml
doc/src/sgml/plpgsql.sgml
doc/src/sgml/pltcl.sgml
doc/src/sgml/ref/create_event_trigger.sgml
doc/src/sgml/ref/create_trigger.sgml
doc/src/sgml/tcn.sgml
doc/src/sgml/textsearch.sgml
doc/src/sgml/trigger.sgml
src/backend/parser/gram.y
src/test/regress/expected/triggers.out
src/test/regress/sql/triggers.sql