diff options
Diffstat (limited to 'src/test/regress/sql/event_trigger.sql')
| -rw-r--r-- | src/test/regress/sql/event_trigger.sql | 23 |
1 files changed, 17 insertions, 6 deletions
diff --git a/src/test/regress/sql/event_trigger.sql b/src/test/regress/sql/event_trigger.sql index b65bf3ec664..ef7faf0ab76 100644 --- a/src/test/regress/sql/event_trigger.sql +++ b/src/test/regress/sql/event_trigger.sql @@ -89,15 +89,26 @@ create event trigger regress_event_trigger_noperms on ddl_command_start execute procedure test_event_trigger(); reset role; --- all OK +-- test enabling and disabling +alter event trigger regress_event_trigger disable; +-- fires _trigger2 and _trigger_end should fire, but not _trigger +create table event_trigger_fire1 (a int); +alter event trigger regress_event_trigger enable; +set session_replication_role = replica; +-- fires nothing +create table event_trigger_fire2 (a int); alter event trigger regress_event_trigger enable replica; +-- fires only _trigger +create table event_trigger_fire3 (a int); alter event trigger regress_event_trigger enable always; -alter event trigger regress_event_trigger enable; +-- fires only _trigger +create table event_trigger_fire4 (a int); +reset session_replication_role; +-- fires all three +create table event_trigger_fire5 (a int); +-- clean up alter event trigger regress_event_trigger disable; - --- regress_event_trigger2 and regress_event_trigger_end should fire, but not --- regress_event_trigger -create table event_trigger_fire1 (a int); +drop table event_trigger_fire2, event_trigger_fire3, event_trigger_fire4, event_trigger_fire5; -- regress_event_trigger_end should fire on these commands grant all on table event_trigger_fire1 to public; |