Avoid permission failure in pg_sequences.last_value
authorPeter Eisentraut <peter_e@gmx.net>
Mon, 6 Feb 2017 20:17:27 +0000 (15:17 -0500)
committerPeter Eisentraut <peter_e@gmx.net>
Mon, 6 Feb 2017 20:27:01 +0000 (15:27 -0500)
commitab82340a43bebe57a3db0e52bb74120b3bb53ae5
tree66a8ace42acbc116e9d9e6fbe27f03cf31dc3b78
parentad6af3fc4256c0e1eecf5d93d510da4b44e0d480
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>
doc/src/sgml/catalogs.sgml
src/backend/catalog/system_views.sql
src/test/regress/expected/rules.out