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

From Tom Lane
Subject Re: Dropping column silently kills multi-coumn index (was [ODBC] Error when accessing tables with deleted columns)
Date
Msg-id 5299.1043883181@sss.pgh.pa.us
Whole thread Raw
In response to Dropping column silently kills multi-coumn index (was [ODBC] Error when accessing tables with deleted columns)  ("Glen Parker" <glenebob@nwlink.com>)
List 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 by date:

Previous
From: "Patrick Bye (WFF)"
Date:
Subject: Problem starting postmaster at startup
Next
From: "Patrick Hatcher"
Date:
Subject: COPY..FROM question on 7.3