Re: Lack of information on materialized views in information_schema.table_privileges.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Lack of information on materialized views in information_schema.table_privileges.
Дата
Msg-id 15973.1511716927@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Lack of information on materialized views ininformation_schema.table_privileges.  (Jan Przemysław Wójcik <jan.przemyslaw.wojcik@gmail.com>)
Ответы Re: Lack of information on materialized views ininformation_schema.table_privileges.  (Jan Przemysław Wójcik <jan.przemyslaw.wojcik@gmail.com>)
Список pgsql-bugs
Jan Przemysław Wójcik <jan.przemyslaw.wojcik@gmail.com> writes:
> information_schema.table_privileges does not show privileges on the view:

AFAIK, no information_schema view shows anything at all about matviews.
This is intentional because matviews aren't SQL-standard objects.
It's therefore unclear how they should be represented in
information_schema (eg, do they belong in the tables view or the views
view, and if the former, what is their table_type?).  Our project policy
is that rather than inventing extensions to the information_schema
standard, we just don't show nonstandard objects in information_schema.
        regards, tom lane


В списке pgsql-bugs по дате отправления:

Предыдущее
От: radudragusi@gmail.com
Дата:
Сообщение: BUG #14926: I cannot start pgAdmin
Следующее
От: bianpan2016@163.com
Дата:
Сообщение: BUG #14927: Unchecked SearchSysCache1() return value