[HACKERS] pg_sequences bug ?
От | Shinoda, Noriyoshi |
---|---|
Тема | [HACKERS] pg_sequences bug ? |
Дата | |
Msg-id | AT5PR84MB00840D351CF29234C88CA59BEE4E0@AT5PR84MB0084.NAMPRD84.PROD.OUTLOOK.COM обсуждение исходный текст |
Ответы |
Re: [HACKERS] pg_sequences bug ?
|
Список | pgsql-hackers |
Hi hackers, I tried a committed pg_sequences for PostgreSQL 10dev (https://commitfest.postgresql.org/12/771/). I found that when multiple users create SEQUENCE, I cannot see the pg_sequences catalog. I think that should work just likepg_tables. $ psql -U user1 postgres=> CREATE SEQUENCE seq1 ; CREATE SEQUENCE $ psql -U user2 postgres=> CREATE SEQUENCE seq2 ; CREATE SEQUENCE 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? Snapshot: https://ftp.postgresql.org/pub/snapshot/dev/postgresql-snapshot.tar.gz 2017-02-04 00:29:04 Operating System: Red Hat Enterprise Linux 7 Update 2 (x86-64) Regards.
В списке pgsql-hackers по дате отправления: