Movatterモバイル変換

[0]ホーム
URL:

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

 Sign up
Appearance settings

Commitcf3dfea

Browse files
committed
Change PROCEDURE to FUNCTION in CREATE EVENT TRIGGER syntax
This was claimed to have been done in0a63f99, but that actually onlychanged the documentation and not the grammar. (That commit did fullychange it for CREATE TRIGGER.)
1 parentb04aeb0 commitcf3dfea

File tree

3 files changed

+4
-4
lines changed

3 files changed

+4
-4
lines changed

‎src/backend/parser/gram.y‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -5578,7 +5578,7 @@ ConstraintAttributeElem:
55785578

55795579
CreateEventTrigStmt:
55805580
CREATEEVENTTRIGGERnameONColLabel
5581-
EXECUTEPROCEDUREfunc_name'('')'
5581+
EXECUTEFUNCTION_or_PROCEDUREfunc_name'('')'
55825582
{
55835583
CreateEventTrigStmt *n = makeNode(CreateEventTrigStmt);
55845584
n->trigname =$4;
@@ -5589,7 +5589,7 @@ CreateEventTrigStmt:
55895589
}
55905590
|CREATEEVENTTRIGGERnameONColLabel
55915591
WHENevent_trigger_when_list
5592-
EXECUTEPROCEDUREfunc_name'('')'
5592+
EXECUTEFUNCTION_or_PROCEDUREfunc_name'('')'
55935593
{
55945594
CreateEventTrigStmt *n = makeNode(CreateEventTrigStmt);
55955595
n->trigname =$4;

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

Lines 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-
executeprocedure test_event_trigger();
30+
executefunction 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‎

Lines 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_endon ddl_command_end
31-
executeprocedure test_event_trigger();
31+
executefunction test_event_trigger();
3232

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

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp