Re: BUG #16018: pg_sequence_last_value() doesn't give results for owners

The following bug has been logged on the website:

Bug reference:      16018
Logged by:          Robert Treat
Email address:      rob@xzilla.net
PostgreSQL version: 11.5
Operating system:   osx
Description:       

I think there is a bug of sorts with pg_sequence_last_value(), in that the
security checks prevent a superuser (or owner) from seeing the last_value of
a sequence by way of this function. That seems like a use case that should
be supported (and since it isn't, it causes problems for a lot of other use
cases). As an example:

postgres@54321:pagila=# create sequence x;
CREATE SEQUENCE

postgres@54321:pagila=# select pg_sequence_last_value('x'::regclass);
 pg_sequence_last_value
------------------------

(1 row)

postgres@54321:pagila=# select * from x;
 last_value | log_cnt | is_called
------------+---------+-----------
          1 |       0 | f
(1 row)