Re: DROP TYPE/DROP DOMAIN - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: DROP TYPE/DROP DOMAIN
Date
Msg-id 037701c35af1$1310eb80$2800a8c0@mars
Whole thread Raw
In response to DROP TYPE/DROP DOMAIN  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
List pgsql-hackers
> > According to that logic, a view is a table, but we still require DROP
VIEW
> > to drop a view.
>
> No, a view is not a table.  Try putting an index or trigger on it.

It seems to me to be more correct that we make DROP TYPE not work on
domains.  I refer to the principle of least surprise...  People EXPECT it to
not work, therefore it shouldn't :)

There exists a perfectly good other command (drop domain) that works, and
you can't go alter type..add check(...) on a domain.  Also, we don't want to
encourage people to use commands that maybe we might remove in the future...

Chris



pgsql-hackers by date:

Previous
From: Larry Rosenman
Date:
Subject: Re: Thread-safe configuration option appears to
Next
From: "Christopher Kings-Lynne"
Date:
Subject: boolean defaults