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 по дате отправления: