Re: Issues with Information_schema.views

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Issues with Information_schema.views
Дата
Msg-id 2127769.1698589854@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Issues with Information_schema.views  (Erki Eessaar <erki.eessaar@taltech.ee>)
Список pgsql-hackers
Erki Eessaar <erki.eessaar@taltech.ee> writes:
> My question is - is all of this the intended behaviour by the implementers?

Yes, I'd say so.  If you are expecting that the is_updatable flag
will check to see if the behavior provided by the view's rules
corresponds to something that a human would call a corresponding
update of the view's output, you're out of luck.  There's a little
issue called the halting problem.  So the actual check just looks
to see if there's unconditional DO INSTEAD rules of the appropriate
types, and doesn't probe into what those rules do.

            regards, tom lane



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

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: run pgindent on a regular basis / scripted manner
Следующее
От: Tom Lane
Дата:
Сообщение: Re: On login trigger: take three