diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2017-02-06 15:17:27 -0500 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2017-02-06 15:27:01 -0500 |
| commit | ab82340a43bebe57a3db0e52bb74120b3bb53ae5 (patch) | |
| tree | 66a8ace42acbc116e9d9e6fbe27f03cf31dc3b78 /src/test | |
| parent | ad6af3fc4256c0e1eecf5d93d510da4b44e0d480 (diff) | |
| download | postgresql-ab82340a43bebe57a3db0e52bb74120b3bb53ae5.tar.gz postgresql-ab82340a43bebe57a3db0e52bb74120b3bb53ae5.zip | |
Avoid permission failure in pg_sequences.last_value
Before, reading pg_sequences.last_value would fail unless the user had
appropriate sequence permissions, which would make the pg_sequences view
cumbersome to use. Instead, return null instead of the real value when
there are no permissions.
From: Michael Paquier <michael.paquier@gmail.com>
Reported-by: Shinoda, Noriyoshi <noriyoshi.shinoda@hpe.com>
Diffstat (limited to 'src/test')
| -rw-r--r-- | src/test/regress/expected/rules.out | 5 |
1 files changed, 4 insertions, 1 deletions
diff --git a/src/test/regress/expected/rules.out b/src/test/regress/expected/rules.out index 60731a99b7c..9c99a451ba0 100644 --- a/src/test/regress/expected/rules.out +++ b/src/test/regress/expected/rules.out @@ -1647,7 +1647,10 @@ pg_sequences| SELECT n.nspname AS schemaname, s.seqincrement AS increment_by, s.seqcycle AS cycle, s.seqcache AS cache_size, - pg_sequence_last_value((c.oid)::regclass) AS last_value + CASE + WHEN has_sequence_privilege(c.oid, 'SELECT,USAGE'::text) THEN pg_sequence_last_value((c.oid)::regclass) + ELSE NULL::bigint + END AS last_value FROM ((pg_sequence s JOIN pg_class c ON ((c.oid = s.seqrelid))) LEFT JOIN pg_namespace n ON ((n.oid = c.relnamespace))) |