Re: Dropping column silently kills multi-coumn index (was [ODBC] Error when accessing tables with deleted columns)

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Dropping column silently kills multi-coumn index (was [ODBC] Error when accessing tables with deleted columns)
Дата
Msg-id 5299.1043883181@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Dropping column silently kills multi-coumn index (was [ODBC] Error when accessing tables with deleted columns)  ("Glen Parker" <glenebob@nwlink.com>)
Список pgsql-general
"Glen Parker" <glenebob@nwlink.com> writes:
> Note that the ALTER TABLE query succeeded *quietly* and did in fact drop
> the index.

If indexes require a CASCADE to be dropped by DROP COLUMN, then DROP
TABLE on an indexed table would also require CASCADE.  Does that seem
like a good idea?

            regards, tom lane

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

Предыдущее
От: "Patrick Bye (WFF)"
Дата:
Сообщение: Problem starting postmaster at startup
Следующее
От: "Patrick Hatcher"
Дата:
Сообщение: COPY..FROM question on 7.3