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 <[email protected]>
Reported-by: Shinoda, Noriyoshi <[email protected]>

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(-)


-- 
Sent via pgsql-committers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers

Reply via email to