Drop Cascade of Domains

Поиск
Список
Период
Сортировка
От elein
Тема Drop Cascade of Domains
Дата
Msg-id 20031129141743.C6974@cookie.varlena.com
обсуждение исходный текст
Ответы Re: Drop Cascade of Domains  (Peter Eisentraut <peter_e@gmx.net>)
Re: Drop Cascade of Domains  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
I have a table which contains three
columns of domain X.

If I drop the domain X with cascade,
the table remains with no columns.

Is this the proper behaviour?

It seems to me that any action which
results in an invalid object should be
forbidden.  On the other hand, with
alter table working well, I am loathe
to argue a table with no columns is
an invalid argument.

Is there a previous rule on this issue?

--elein

============================================================
elein@varlena.com        Varlena, LLC        www.varlena.com

          PostgreSQL Consulting, Support & Training

PostgreSQL General Bits   http://www.varlena.com/GeneralBits/
=============================================================
"Free your mind the rest will follow" -- En Vogue

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

Предыдущее
От: elein
Дата:
Сообщение: Domains and function
Следующее
От: Oliver Elphick
Дата:
Сообщение: Re: Cron-job for checking up on pg_autovacuum