Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Appearance settings

Commit cf3dfea

Browse filesBrowse files
committed
Change PROCEDURE to FUNCTION in CREATE EVENT TRIGGER syntax
This was claimed to have been done in 0a63f99, but that actually only changed the documentation and not the grammar. (That commit did fully change it for CREATE TRIGGER.)
1 parent b04aeb0 commit cf3dfea
Copy full SHA for cf3dfea

File tree

Expand file treeCollapse file tree

3 files changed

+4
-4
lines changed
Filter options
Expand file treeCollapse file tree

3 files changed

+4
-4
lines changed

‎src/backend/parser/gram.y

Copy file name to clipboardExpand all lines: src/backend/parser/gram.y
+2-2Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -5578,7 +5578,7 @@ ConstraintAttributeElem:
55785578

55795579
CreateEventTrigStmt:
55805580
CREATE EVENT TRIGGER name ON ColLabel
5581-
EXECUTE PROCEDURE func_name '(' ')'
5581+
EXECUTE FUNCTION_or_PROCEDURE func_name '(' ')'
55825582
{
55835583
CreateEventTrigStmt *n = makeNode(CreateEventTrigStmt);
55845584
n->trigname = $4;
@@ -5589,7 +5589,7 @@ CreateEventTrigStmt:
55895589
}
55905590
| CREATE EVENT TRIGGER name ON ColLabel
55915591
WHEN event_trigger_when_list
5592-
EXECUTE PROCEDURE func_name '(' ')'
5592+
EXECUTE FUNCTION_or_PROCEDURE func_name '(' ')'
55935593
{
55945594
CreateEventTrigStmt *n = makeNode(CreateEventTrigStmt);
55955595
n->trigname = $4;

‎src/test/regress/expected/event_trigger.out

Copy file name to clipboardExpand all lines: src/test/regress/expected/event_trigger.out
+1-1Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -27,7 +27,7 @@ create event trigger regress_event_trigger on ddl_command_start
2727
execute procedure test_event_trigger();
2828
-- OK
2929
create event trigger regress_event_trigger_end on ddl_command_end
30-
execute procedure test_event_trigger();
30+
execute function test_event_trigger();
3131
-- should fail, food is not a valid filter variable
3232
create event trigger regress_event_trigger2 on ddl_command_start
3333
when food in ('sandwich')

‎src/test/regress/sql/event_trigger.sql

Copy file name to clipboardExpand all lines: src/test/regress/sql/event_trigger.sql
+1-1Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -28,7 +28,7 @@ create event trigger regress_event_trigger on ddl_command_start
2828

2929
-- OK
3030
create event trigger regress_event_trigger_end on ddl_command_end
31-
execute procedure test_event_trigger();
31+
execute function test_event_trigger();
3232

3333
-- should fail, food is not a valid filter variable
3434
create event trigger regress_event_trigger2 on ddl_command_start

0 commit comments

Comments
0 (0)
Morty Proxy This is a proxified and sanitized view of the page, visit original site.