Commit601e293

committed

Update comments and output for event_trigger regression test.

1 parent52906f1 commit601e293Copy full SHA for 601e293

File tree

-4

lines changed

-4

lines changed

Lines changed: 5 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -16,6 +16,7 @@ ERROR: unrecognized event name "elephant_bootstrap"`
`16`	`16`	`-- OK`
`17`	`17`	`create event trigger regress_event_trigger on ddl_command_start`
`18`	`18`	`execute procedure test_event_trigger();`
	`19`	`+-- OK`
`19`	`20`	`create event trigger regress_event_trigger_end on ddl_command_end`
`20`	`21`	`execute procedure test_event_trigger();`
`21`	`22`	`-- should fail, food is not a valid filter variable`
`@@ -65,10 +66,12 @@ alter event trigger regress_event_trigger enable replica;`
`65`	`66`	`alter event trigger regress_event_trigger enable always;`
`66`	`67`	`alter event trigger regress_event_trigger enable;`
`67`	`68`	`alter event trigger regress_event_trigger disable;`
`68`		`--- regress_event_trigger2 should fire, but not regress_event_trigger`
	`69`	`+-- regress_event_trigger2 and regress_event_trigger_end should fire, but not`
	`70`	`+-- regress_event_trigger`
`69`	`71`	`create table event_trigger_fire1 (a int);`
	`72`	`+NOTICE: test_event_trigger: ddl_command_start CREATE TABLE`
`70`	`73`	`NOTICE: test_event_trigger: ddl_command_end CREATE TABLE`
`71`		`---but nothing should fire here`
	`74`	`+--regress_event_trigger_end should fire here`
`72`	`75`	`drop table event_trigger_fire1;`
`73`	`76`	`NOTICE: test_event_trigger: ddl_command_end DROP TABLE`
`74`	`77`	`-- alter owner to non-superuser should fail`

Lines changed: 4 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -18,6 +18,7 @@ create event trigger regress_event_trigger on elephant_bootstrap`
`18`	`18`	`create event trigger regress_event_triggeron ddl_command_start`
`19`	`19`	`execute procedure test_event_trigger();`
`20`	`20`
	`21`	`+-- OK`
`21`	`22`	`create event trigger regress_event_trigger_endon ddl_command_end`
`22`	`23`	`execute procedure test_event_trigger();`
`23`	`24`
`@@ -70,10 +71,11 @@ alter event trigger regress_event_trigger enable always;`
`70`	`71`	`alter event trigger regress_event_trigger enable;`
`71`	`72`	`alter event trigger regress_event_trigger disable;`
`72`	`73`
`73`		`--- regress_event_trigger2 should fire, but not regress_event_trigger`
	`74`	`+-- regress_event_trigger2 and regress_event_trigger_end should fire, but not`
	`75`	`+-- regress_event_trigger`
`74`	`76`	`createtableevent_trigger_fire1 (aint);`
`75`	`77`
`76`		`---but nothing should fire here`
	`78`	`+--regress_event_trigger_end should fire here`
`77`	`79`	`droptable event_trigger_fire1;`
`78`	`80`
`79`	`81`	`-- alter owner to non-superuser should fail`

Comments

(0)