Horton

Change PROCEDURE to FUNCTION in CREATE TRIGGER syntax

Peter Eisentraut <peter_e@gmx.net>

View on postgr.es
Commit: 0a63f996e018ac508c858e87fa39cc254a5db49f
Author: Peter Eisentraut <peter_e@gmx.net>
Date: 2018-08-22T12:44:49Z
Releases: 12.0 
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>

Files

PathChange+/−
doc/src/sgml/ddl.sgml modified +1 −1
doc/src/sgml/event-trigger.sgml modified +2 −2
doc/src/sgml/func.sgml modified +3 −3
doc/src/sgml/information_schema.sgml modified +1 −1
doc/src/sgml/lo.sgml modified +1 −1
doc/src/sgml/plperl.sgml modified +2 −2
doc/src/sgml/plpgsql.sgml modified +8 −8
doc/src/sgml/pltcl.sgml modified +2 −2
doc/src/sgml/ref/create_event_trigger.sgml modified +10 −2
doc/src/sgml/ref/create_trigger.sgml modified +16 −8
doc/src/sgml/tcn.sgml modified +1 −1
doc/src/sgml/textsearch.sgml modified +2 −2
doc/src/sgml/trigger.sgml modified +2 −2
src/backend/parser/gram.y modified +7 −2
src/test/regress/expected/triggers.out modified +2 −2
src/test/regress/sql/triggers.sql modified +2 −2

Documentation touched