Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Tom Lane wrote:
>> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Added to TODO:
> * Disallow DROP COLUMN on a column that is part of a multi-column index
>>
>> That's poorly phrased. What you meant to say is "require CASCADE if ..."
> Actually, no. Does CASCADE make sense in this case?
Yes, it does. The multi-key index is a dependent object, and dropping
dependent objects is exactly what CASCADE is for.
> Do we have precedent
> for CASCADE to remove something that is shared by others?
Certainly. Try dropping a function that is used in several default
expressions, for example.
regards, tom lane
