Re: [COMMITTERS] pgsql: Add infrastructure to supportEphemeralNamedRelation references.

Поиск
Список
Период
Сортировка
От Euler Taveira
Тема Re: [COMMITTERS] pgsql: Add infrastructure to supportEphemeralNamedRelation references.
Дата
Msg-id CAHE3wgg5D7O=vFdNU4FV0BgDiQb0c+tUVW6hFwJ+uqemz6F+BA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [COMMITTERS] pgsql: Add infrastructure to supportEphemeralNamedRelation references.  (Kevin Grittner <kgrittn@gmail.com>)
Ответы Re: [COMMITTERS] pgsql: Add infrastructure to supportEphemeralNamedRelation references.  (Kevin Grittner <kgrittn@gmail.com>)
Список pgsql-committers
Дерево обсуждения

2017-04-07 13:06 GMT-03:00 Kevin Grittner <kgrittn@gmail.com>:
ERROR:  cannot drop table t1 column t1id because other objects depend on it
DETAIL:  view v1 depends on table t1 column t1id
HINT:  Use DROP ... CASCADE to drop the dependent objects too.

Is that comment wrong?

Sort of. If you consider ALTER TABLE ... DROP COLUMN ... CASCADE, it is not that wrong. However, if you want to be strict, there should be a check to identify a table column and then hint a specific message (ALTER instead of DROP).


--
   Euler Taveira                                   Timbira - http://www.timbira.com.br/
   PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [COMMITTERS] pgsql: Use SASLprep to normalize passwords for SCRAM authentication.
Следующее
От: Kevin Grittner
Дата:
Сообщение: Re: [COMMITTERS] pgsql: Add infrastructure to supportEphemeralNamedRelation references.