Re: how to find out whether a view is updatable

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: how to find out whether a view is updatable
Дата
Msg-id CAB7nPqQnkDxcn5ByjddZ-wKJCdCNDeT8rKP9gK-=nV7LpqYsgg@mail.gmail.com
обсуждение исходный текст
Ответ на how to find out whether a view is updatable  (Peter Eisentraut <peter_e@gmx.net>)
Ответы Re: how to find out whether a view is updatable  (Dean Rasheed <dean.a.rasheed@gmail.com>)
Список pgsql-hackers



On Wed, Jun 5, 2013 at 12:59 AM, Peter Eisentraut <peter_e@gmx.net> wrote:
I was looking for a way in which the average psql user could learn
whether a view is updatable.  I was expecting something in \d, \d+, \dv,
\dv+, or a NOTICE from CREATE VIEW.  So far, the only way appears to be
through the information schema or the underlying pg_view_is_updatable
function.  Not even pg_views shows anything.  Is this intentional or an
oversight?
Just by recalling the thread, an oversight. Having this information in ¥dv+ would
be indeed a nice addition.
--
Michael

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Improved error message for CREATE EXTENSION patch...
Следующее
От: amul sul
Дата:
Сообщение: Re: create a git symbolic-ref for REL9_3_STABLE