Mark Hollomon <mhh@mindspring.com> writes:
>>>> I say let them drop it with either one.
>>
>> I kinda like the 'drop index with drop index', 'drop table with drop
>> table' and 'drop view with drop view' groupings ... at least you are
>> pretty sure you haven't 'oopsed' in the process :)
> So the vote is now tied. Any other opinions
I vote for the fascist approach (command must agree with actual type
of object). Seems safest. Please make sure the error message is
helpful though, like "Use DROP SEQUENCE to drop a sequence".
regards, tom lane