Re: Invalidating dependent views and functions

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Invalidating dependent views and functions
Дата
Msg-id 24293.1272638299@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Invalidating dependent views and functions  (Scott Bailey <artacus@comcast.net>)
Ответы Re: Invalidating dependent views and functions
Список pgsql-hackers
Scott Bailey <artacus@comcast.net> writes:
> Proposal: Add an invalid flag to pg_class. Invalid objects would be 
> ignored when doing dependency checks for DDL statements. And an 
> exception would be thrown when an invalid object is called.

IMO, the way Oracle does this pretty much sucks, and shouldn't be
emulated.  If they know how to recompile the view, why don't they
just do it?  What you describe is about as user-unfriendly as it
gets.
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: missing file in git repo
Следующее
От: Tom Lane
Дата:
Сообщение: Re: pg_migrator to /contrib in a later 9.0 beta