Postgres Pro
Downloads
Home   >   mailing lists

Re: [COMMITTERS] pgsql: Add infrastructure to supportEphemeralNamedRelation references. - Mailing list pgsql-committers

From Euler Taveira
Subject Re: [COMMITTERS] pgsql: Add infrastructure to supportEphemeralNamedRelation references.
Date
Msg-id CAHE3wgg5D7O=vFdNU4FV0BgDiQb0c+tUVW6hFwJ+uqemz6F+BA@mail.gmail.com
Whole thread Raw
In response to Re: [COMMITTERS] pgsql: Add infrastructure to supportEphemeralNamedRelation references.  (Kevin Grittner <kgrittn@gmail.com>)
Responses Re: [COMMITTERS] pgsql: Add infrastructure to supportEphemeralNamedRelation references.  (Kevin Grittner <kgrittn@gmail.com>)
List pgsql-committers
Tree view

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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: [COMMITTERS] pgsql: Use SASLprep to normalize passwords for SCRAM authentication.
Next
From: Kevin Grittner
Date:
Subject: Re: [COMMITTERS] pgsql: Add infrastructure to supportEphemeralNamedRelation references.