diff options
| author | Nathan Bossart <nathan@postgresql.org> | 2024-07-01 11:47:40 -0500 |
|---|---|---|
| committer | Nathan Bossart <nathan@postgresql.org> | 2024-07-01 11:47:40 -0500 |
| commit | 7967d10c5b49ccb82f67a0b80678a1a932bccdee (patch) | |
| tree | 3707d09709af9ec96cacd80e6707ae3da0443d56 /src/test | |
| parent | 1afe31f03cd268a0bbb7a340d56b8eef6419bcb0 (diff) | |
| download | postgresql-7967d10c5b49ccb82f67a0b80678a1a932bccdee.tar.gz postgresql-7967d10c5b49ccb82f67a0b80678a1a932bccdee.zip | |
Remove redundant privilege check from pg_sequences system view.
This commit adjusts pg_sequence_last_value() to return NULL instead
of ERROR-ing for sequences for which the current user lacks
privileges. This allows us to remove the call to
has_sequence_privilege() in the definition of the pg_sequences
system view.
Bumps catversion.
Suggested-by: Michael Paquier
Reviewed-by: Michael Paquier, Tom Lane
Discussion: https://postgr.es/m/20240501005730.GA594666%40nathanxps13
Diffstat (limited to 'src/test')
| -rw-r--r-- | src/test/regress/expected/rules.out | 5 |
1 files changed, 1 insertions, 4 deletions
diff --git a/src/test/regress/expected/rules.out b/src/test/regress/expected/rules.out index e12ef4336a2..4c789279e5e 100644 --- a/src/test/regress/expected/rules.out +++ b/src/test/regress/expected/rules.out @@ -1700,10 +1700,7 @@ pg_sequences| SELECT n.nspname AS schemaname, s.seqincrement AS increment_by, s.seqcycle AS cycle, s.seqcache AS cache_size, - 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 + pg_sequence_last_value((c.oid)::regclass) 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))) |