ALTER/DROP table/view assymmetry

Поиск
Список
Период
Сортировка
От George Pavlov
Тема ALTER/DROP table/view assymmetry
Дата
Msg-id 8C5B026B51B6854CBE88121DBF097A8602EF62C8@ehost010-33.exch010.intermedia.net
обсуждение исходный текст
Ответы Re: ALTER/DROP table/view assymmetry
Список pgsql-general
This is minor, but just curious about the reasons for the assymetry
between ALTER and DROP with respect to tables vs. views.

* ALTER TABLE seems to work on both tables and views (even though ALTER
VIEW exists, albeit with a limited operation support).
* DROP TABLE works only on tables, not on views (dropping those requires
DROP VIEW).

Wouldn't it be cleaner if view operations worked only on views and table
ones on tables? At the very least maybe the docs for ALTER TABLE
probably should mention that it works on views too.

George


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

Предыдущее
От: "Andrus"
Дата:
Сообщение: Re: Shopping cart
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: How to get schema name which violates fk constraint