diff options
| author | Robert Haas <rhaas@postgresql.org> | 2013-01-23 06:46:27 -0500 |
|---|---|---|
| committer | Robert Haas <rhaas@postgresql.org> | 2013-01-23 06:49:30 -0500 |
| commit | 601e2935e28735e6bc285794fd9d558e6735bb8e (patch) | |
| tree | 3a35dfa645c6ec2c18f9537c91309e43230b3fa0 /src | |
| parent | 52906f175a05a4e7e5e4a0e6021c32b1bfb221cf (diff) | |
| download | postgresql-601e2935e28735e6bc285794fd9d558e6735bb8e.tar.gz postgresql-601e2935e28735e6bc285794fd9d558e6735bb8e.zip | |
Update comments and output for event_trigger regression test.
Diffstat (limited to 'src')
| -rw-r--r-- | src/test/regress/expected/event_trigger.out | 7 | ||||
| -rw-r--r-- | src/test/regress/sql/event_trigger.sql | 6 |
2 files changed, 9 insertions, 4 deletions
diff --git a/src/test/regress/expected/event_trigger.out b/src/test/regress/expected/event_trigger.out index 843e22c0bfb..bf020de16f6 100644 --- a/src/test/regress/expected/event_trigger.out +++ b/src/test/regress/expected/event_trigger.out @@ -16,6 +16,7 @@ ERROR: unrecognized event name "elephant_bootstrap" -- OK create event trigger regress_event_trigger on ddl_command_start execute procedure test_event_trigger(); +-- OK create event trigger regress_event_trigger_end on ddl_command_end execute procedure test_event_trigger(); -- should fail, food is not a valid filter variable @@ -65,10 +66,12 @@ alter event trigger regress_event_trigger enable replica; alter event trigger regress_event_trigger enable always; alter event trigger regress_event_trigger enable; alter event trigger regress_event_trigger disable; --- regress_event_trigger2 should fire, but not regress_event_trigger +-- regress_event_trigger2 and regress_event_trigger_end should fire, but not +-- regress_event_trigger create table event_trigger_fire1 (a int); +NOTICE: test_event_trigger: ddl_command_start CREATE TABLE NOTICE: test_event_trigger: ddl_command_end CREATE TABLE --- but nothing should fire here +-- regress_event_trigger_end should fire here drop table event_trigger_fire1; NOTICE: test_event_trigger: ddl_command_end DROP TABLE -- alter owner to non-superuser should fail diff --git a/src/test/regress/sql/event_trigger.sql b/src/test/regress/sql/event_trigger.sql index acd003254cd..a07dcd75546 100644 --- a/src/test/regress/sql/event_trigger.sql +++ b/src/test/regress/sql/event_trigger.sql @@ -18,6 +18,7 @@ create event trigger regress_event_trigger on elephant_bootstrap create event trigger regress_event_trigger on ddl_command_start execute procedure test_event_trigger(); +-- OK create event trigger regress_event_trigger_end on ddl_command_end execute procedure test_event_trigger(); @@ -70,10 +71,11 @@ alter event trigger regress_event_trigger enable always; alter event trigger regress_event_trigger enable; alter event trigger regress_event_trigger disable; --- regress_event_trigger2 should fire, but not regress_event_trigger +-- regress_event_trigger2 and regress_event_trigger_end should fire, but not +-- regress_event_trigger create table event_trigger_fire1 (a int); --- but nothing should fire here +-- regress_event_trigger_end should fire here drop table event_trigger_fire1; -- alter owner to non-superuser should fail |