Re: DROP TYPE/DROP DOMAIN

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Peter Eisentraut" <peter_e(at)gmx(dot)net>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: DROP TYPE/DROP DOMAIN
Date: 2003-08-05 08:05:35
Message-ID: 073701c35b28$5af0dd20$2800a8c0@mars
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> But that's an additional feature, not a missing feature.
>
> I think the reason we are restrictive about the comparable cases for
> relations (pg_class entries) is that we use pg_class entries for a
> number of things that users see as unrelated or only weakly related.
> For example, indexes are not tables by any reasonable definition above
> the implementation level; sequences are tables only as an artifact of
> a particular implementation (which I think we'll someday have to abandon
> BTW); composite types surely aren't tables. It would be surprising for
> a composite type to be droppable by DROP TABLE. But domains *are*
> types, both to the user and to the implementation, and so I see no
> surprise factor in allowing DROP TYPE to work on them.

Will DROP TYPE automatically handle dropping constraints and dependent
columns properly? Will all its messages use the word 'domain' and not
'type'? I can't see any conceivable reason to allow this syntax to work!
We are giving zero benefit for a non-zero cost...

Chris

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andreas 2003-08-05 08:10:22 Re: "truncate all"?
Previous Message Markus Bertheau 2003-08-05 07:47:15 Re: Building beta packaging fails ...