Re: preventing ALTER TABLE RENAME from changing view definitions?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: preventing ALTER TABLE RENAME from changing view definitions?
Дата
Msg-id 9628.1172543101@sss.pgh.pa.us
обсуждение исходный текст
Ответ на preventing ALTER TABLE RENAME from changing view definitions?  ("George Pavlov" <gpavlov@mynewplace.com>)
Список pgsql-general
Дерево обсуждения 
"George Pavlov" <gpavlov@mynewplace.com> writes:
> Currently "ALTER TABLE ... RENAME TO ..." results in all views that
> refer to the table to be rewritten with the new table name.

They are not "rewritten".  Views refer to tables by OID, and are
therefore entirely insensitive to RENAME operations.  This is not
something we're likely to change.

            regards, tom lane

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

Предыдущее
От: "Merlin Moncure"
Дата:
Сообщение: Re: Most efficient report of number of records in all tables?
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: dropping a master table and all of its partitions?