diff options
Diffstat (limited to 'src/test/regress/expected/sequence.out')
| -rw-r--r-- | src/test/regress/expected/sequence.out | 58 |
1 files changed, 29 insertions, 29 deletions
diff --git a/src/test/regress/expected/sequence.out b/src/test/regress/expected/sequence.out index 8783ca62a6f..4ffbe92ab37 100644 --- a/src/test/regress/expected/sequence.out +++ b/src/test/regress/expected/sequence.out @@ -366,22 +366,22 @@ DROP SEQUENCE seq2; -- should fail SELECT lastval(); ERROR: lastval is not yet defined in this session -CREATE USER seq_user; +CREATE USER regress_seq_user; -- privileges tests -- nextval BEGIN; -SET LOCAL SESSION AUTHORIZATION seq_user; +SET LOCAL SESSION AUTHORIZATION regress_seq_user; CREATE SEQUENCE seq3; -REVOKE ALL ON seq3 FROM seq_user; -GRANT SELECT ON seq3 TO seq_user; +REVOKE ALL ON seq3 FROM regress_seq_user; +GRANT SELECT ON seq3 TO regress_seq_user; SELECT nextval('seq3'); ERROR: permission denied for sequence seq3 ROLLBACK; BEGIN; -SET LOCAL SESSION AUTHORIZATION seq_user; +SET LOCAL SESSION AUTHORIZATION regress_seq_user; CREATE SEQUENCE seq3; -REVOKE ALL ON seq3 FROM seq_user; -GRANT UPDATE ON seq3 TO seq_user; +REVOKE ALL ON seq3 FROM regress_seq_user; +GRANT UPDATE ON seq3 TO regress_seq_user; SELECT nextval('seq3'); nextval --------- @@ -390,10 +390,10 @@ SELECT nextval('seq3'); ROLLBACK; BEGIN; -SET LOCAL SESSION AUTHORIZATION seq_user; +SET LOCAL SESSION AUTHORIZATION regress_seq_user; CREATE SEQUENCE seq3; -REVOKE ALL ON seq3 FROM seq_user; -GRANT USAGE ON seq3 TO seq_user; +REVOKE ALL ON seq3 FROM regress_seq_user; +GRANT USAGE ON seq3 TO regress_seq_user; SELECT nextval('seq3'); nextval --------- @@ -403,7 +403,7 @@ SELECT nextval('seq3'); ROLLBACK; -- currval BEGIN; -SET LOCAL SESSION AUTHORIZATION seq_user; +SET LOCAL SESSION AUTHORIZATION regress_seq_user; CREATE SEQUENCE seq3; SELECT nextval('seq3'); nextval @@ -411,8 +411,8 @@ SELECT nextval('seq3'); 1 (1 row) -REVOKE ALL ON seq3 FROM seq_user; -GRANT SELECT ON seq3 TO seq_user; +REVOKE ALL ON seq3 FROM regress_seq_user; +GRANT SELECT ON seq3 TO regress_seq_user; SELECT currval('seq3'); currval --------- @@ -421,7 +421,7 @@ SELECT currval('seq3'); ROLLBACK; BEGIN; -SET LOCAL SESSION AUTHORIZATION seq_user; +SET LOCAL SESSION AUTHORIZATION regress_seq_user; CREATE SEQUENCE seq3; SELECT nextval('seq3'); nextval @@ -429,13 +429,13 @@ SELECT nextval('seq3'); 1 (1 row) -REVOKE ALL ON seq3 FROM seq_user; -GRANT UPDATE ON seq3 TO seq_user; +REVOKE ALL ON seq3 FROM regress_seq_user; +GRANT UPDATE ON seq3 TO regress_seq_user; SELECT currval('seq3'); ERROR: permission denied for sequence seq3 ROLLBACK; BEGIN; -SET LOCAL SESSION AUTHORIZATION seq_user; +SET LOCAL SESSION AUTHORIZATION regress_seq_user; CREATE SEQUENCE seq3; SELECT nextval('seq3'); nextval @@ -443,8 +443,8 @@ SELECT nextval('seq3'); 1 (1 row) -REVOKE ALL ON seq3 FROM seq_user; -GRANT USAGE ON seq3 TO seq_user; +REVOKE ALL ON seq3 FROM regress_seq_user; +GRANT USAGE ON seq3 TO regress_seq_user; SELECT currval('seq3'); currval --------- @@ -454,7 +454,7 @@ SELECT currval('seq3'); ROLLBACK; -- lastval BEGIN; -SET LOCAL SESSION AUTHORIZATION seq_user; +SET LOCAL SESSION AUTHORIZATION regress_seq_user; CREATE SEQUENCE seq3; SELECT nextval('seq3'); nextval @@ -462,8 +462,8 @@ SELECT nextval('seq3'); 1 (1 row) -REVOKE ALL ON seq3 FROM seq_user; -GRANT SELECT ON seq3 TO seq_user; +REVOKE ALL ON seq3 FROM regress_seq_user; +GRANT SELECT ON seq3 TO regress_seq_user; SELECT lastval(); lastval --------- @@ -472,7 +472,7 @@ SELECT lastval(); ROLLBACK; BEGIN; -SET LOCAL SESSION AUTHORIZATION seq_user; +SET LOCAL SESSION AUTHORIZATION regress_seq_user; CREATE SEQUENCE seq3; SELECT nextval('seq3'); nextval @@ -480,13 +480,13 @@ SELECT nextval('seq3'); 1 (1 row) -REVOKE ALL ON seq3 FROM seq_user; -GRANT UPDATE ON seq3 TO seq_user; +REVOKE ALL ON seq3 FROM regress_seq_user; +GRANT UPDATE ON seq3 TO regress_seq_user; SELECT lastval(); ERROR: permission denied for sequence seq3 ROLLBACK; BEGIN; -SET LOCAL SESSION AUTHORIZATION seq_user; +SET LOCAL SESSION AUTHORIZATION regress_seq_user; CREATE SEQUENCE seq3; SELECT nextval('seq3'); nextval @@ -494,8 +494,8 @@ SELECT nextval('seq3'); 1 (1 row) -REVOKE ALL ON seq3 FROM seq_user; -GRANT USAGE ON seq3 TO seq_user; +REVOKE ALL ON seq3 FROM regress_seq_user; +GRANT USAGE ON seq3 TO regress_seq_user; SELECT lastval(); lastval --------- @@ -515,5 +515,5 @@ SELECT * FROM information_schema.sequences WHERE sequence_name IN regression | public | sequence_test2 | bigint | 64 | 2 | 0 | 32 | 5 | 36 | 4 | YES (1 row) -DROP USER seq_user; +DROP USER regress_seq_user; DROP SEQUENCE seq; |