I tried a committed pg_sequences for PostgreSQL 10dev
I found that when multiple users create SEQUENCE, I cannot see the pg_sequences
catalog. I think that should work just like pg_tables.
$ psql -U user1
postgres=> CREATE SEQUENCE seq1 ;
$ psql -U user2
postgres=> CREATE SEQUENCE seq2 ;
postgres=> SELECT * FROM pg_sequences ;
ERROR: permission denied for sequence seq1
Apparently it seems that the pg_sequence_last_value function included in the
pg_sequences view definition cannot be executed.
Is this behavior supposed?
Red Hat Enterprise Linux 7 Update 2 (x86-64)
Sent via pgsql-hackers mailing list (firstname.lastname@example.org)
To make changes to your subscription: