diff options
| author | Peter Eisentraut | 2019-10-22 08:35:54 +0000 |
|---|---|---|
| committer | Peter Eisentraut | 2019-10-22 08:35:54 +0000 |
| commit | ad4b7aeb84434c958e2df76fa69b68493a889e4a (patch) | |
| tree | 2e00a1ce2fbcd8f895df1cedc79946d293041e2e /src/test | |
| parent | f86f46d091a6876fbf28e0a4a87ca72b560cf77f (diff) | |
Make command order in test more sensible
Through several updates, the CREATE USER command has been separated
from where the user is actually used in the test.
Diffstat (limited to 'src/test')
| -rw-r--r-- | src/test/regress/expected/sequence.out | 2 | ||||
| -rw-r--r-- | src/test/regress/sql/sequence.sql | 4 |
2 files changed, 3 insertions, 3 deletions
diff --git a/src/test/regress/expected/sequence.out b/src/test/regress/expected/sequence.out index a0d2b22d3c..75eb5015cf 100644 --- a/src/test/regress/expected/sequence.out +++ b/src/test/regress/expected/sequence.out @@ -599,7 +599,6 @@ DROP SEQUENCE seq2; -- should fail SELECT lastval(); ERROR: lastval is not yet defined in this session -CREATE USER regress_seq_user; -- Test sequences in read-only transactions CREATE TEMPORARY SEQUENCE sequence_test_temp1; START TRANSACTION READ ONLY; @@ -623,6 +622,7 @@ SELECT setval('sequence_test2', 1); -- error ERROR: cannot execute setval() in a read-only transaction ROLLBACK; -- privileges tests +CREATE USER regress_seq_user; -- nextval BEGIN; SET LOCAL SESSION AUTHORIZATION regress_seq_user; diff --git a/src/test/regress/sql/sequence.sql b/src/test/regress/sql/sequence.sql index a7b9e63372..7928ee23ee 100644 --- a/src/test/regress/sql/sequence.sql +++ b/src/test/regress/sql/sequence.sql @@ -272,8 +272,6 @@ DROP SEQUENCE seq2; -- should fail SELECT lastval(); -CREATE USER regress_seq_user; - -- Test sequences in read-only transactions CREATE TEMPORARY SEQUENCE sequence_test_temp1; START TRANSACTION READ ONLY; @@ -287,6 +285,8 @@ ROLLBACK; -- privileges tests +CREATE USER regress_seq_user; + -- nextval BEGIN; SET LOCAL SESSION AUTHORIZATION regress_seq_user; |