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

From Peter Eisentraut
Subject Re: DROP TYPE/DROP DOMAIN
Date
Msg-id Pine.LNX.4.56.0308041640570.915@krusty.credativ.de
Whole thread Raw
In response to Re: DROP TYPE/DROP DOMAIN  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: DROP TYPE/DROP DOMAIN
List pgsql-hackers
Tom Lane writes:

> Peter Eisentraut <peter_e@gmx.net> writes:
> > Tom Lane writes:
> >> Why not?  A domain *is* a type, by any reasonable test.
>
> > 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.

According to that logic, a domain is not a type.  Try putting a check
constraint on it.

-- 
Peter Eisentraut   peter_e@gmx.net


pgsql-hackers by date:

Previous
From: Rod Taylor
Date:
Subject: Re: "truncate all"?
Next
From: Robert Treat
Date:
Subject: Re: "truncate all"?