Commitad4b7ae

committed

Make command order in test more sensible

Through several updates, the CREATE USER command has been separatedfrom where the user is actually used in the test.

1 parentf86f46d commitad4b7aeCopy full SHA for ad4b7ae

File tree

-3

lines changed

-3

lines changed

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -599,7 +599,6 @@ DROP SEQUENCE seq2;`
`599`	`599`	`-- should fail`
`600`	`600`	`SELECT lastval();`
`601`	`601`	`ERROR: lastval is not yet defined in this session`
`602`		`-CREATE USER regress_seq_user;`
`603`	`602`	`-- Test sequences in read-only transactions`
`604`	`603`	`CREATE TEMPORARY SEQUENCE sequence_test_temp1;`
`605`	`604`	`START TRANSACTION READ ONLY;`
`@@ -623,6 +622,7 @@ SELECT setval('sequence_test2', 1); -- error`
`623`	`622`	`ERROR: cannot execute setval() in a read-only transaction`
`624`	`623`	`ROLLBACK;`
`625`	`624`	`-- privileges tests`
	`625`	`+CREATE USER regress_seq_user;`
`626`	`626`	`-- nextval`
`627`	`627`	`BEGIN;`
`628`	`628`	`SET LOCAL SESSION AUTHORIZATION regress_seq_user;`

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -272,8 +272,6 @@ DROP SEQUENCE seq2;`
`272`	`272`	`-- should fail`
`273`	`273`	`SELECT lastval();`
`274`	`274`
`275`		`-CREATEUSERregress_seq_user;`
`276`		`-`
`277`	`275`	`-- Test sequences in read-only transactions`
`278`	`276`	`CREATE TEMPORARY SEQUENCE sequence_test_temp1;`
`279`	`277`	`START TRANSACTION READ ONLY;`
`@@ -287,6 +285,8 @@ ROLLBACK;`
`287`	`285`
`288`	`286`	`-- privileges tests`
`289`	`287`
	`288`	`+CREATEUSERregress_seq_user;`
	`289`	`+`
`290`	`290`	`-- nextval`
`291`	`291`	`BEGIN;`
`292`	`292`	`SET LOCAL SESSION AUTHORIZATION regress_seq_user;`

Comments

(0)