Re: DROP TYPE/DROP DOMAIN

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: DROP TYPE/DROP DOMAIN
Дата
Msg-id 073701c35b28$5af0dd20$2800a8c0@mars
обсуждение исходный текст
Ответ на DROP TYPE/DROP DOMAIN  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
Ответы Re: DROP TYPE/DROP DOMAIN  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Markus Bertheau
Дата:
Сообщение: Re: Building beta packaging fails ...
Следующее
От: Andreas
Дата:
Сообщение: Re: "truncate all"?