Re: DROP VIEW code question

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: DROP VIEW code question
Дата
Msg-id Pine.LNX.4.21.0010172229430.9649-100000@peter.localdomain
обсуждение исходный текст
Ответ на DROP VIEW code question  (Mark Hollomon <mhh@mindspring.com>)
Ответы Re: DROP VIEW code question
Список pgsql-hackers
Mark Hollomon writes:

> Also
> 
> "DROP TABLE x, y, z" is allowed, but
> 
> "DROP VIEW x, y, z" is not.
> 
> Any reason other than historical?

I don't know how it looks now, but the "DROP TABLE x, y, z" was pretty
broken a while ago.  For example, if there was some sort of dependency
between the tables (foreign keys?) it would abort and leave an
inconsistent state.  I'm not very fond of this extension, but keep the
issue in mind.

-- 
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/



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

Предыдущее
От: Mark Hollomon
Дата:
Сообщение: DROP VIEW code question
Следующее
От: Tom Lane
Дата:
Сообщение: Re: DROP VIEW code question