pgsql: Avoid permission failure in pg_sequences.last_value

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Avoid permission failure in pg_sequences.last_value
Date: 2017-02-06 20:27:25
Message-ID: [email protected]
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

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(dot)paquier(at)gmail(dot)com>
Reported-by: Shinoda, Noriyoshi <noriyoshi(dot)shinoda(at)hpe(dot)com>

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/ab82340a43bebe57a3db0e52bb74120b3bb53ae5

Modified Files
--------------
doc/src/sgml/catalogs.sgml | 5 ++++-
src/backend/catalog/system_views.sql | 6 +++++-
src/test/regress/expected/rules.out | 5 ++++-
3 files changed, 13 insertions(+), 3 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2017-02-06 20:30:53 pgsql: Release notes for 9.6.2, 9.5.6, 9.4.11, 9.3.16, 9.2.20.
Previous Message Tom Lane 2017-02-06 19:19:33 pgsql: Release note updates.