Drop Cascade of Domains - Mailing list pgsql-general

From elein
Subject Drop Cascade of Domains
Date
Msg-id 20031129141743.C6974@cookie.varlena.com
Whole thread Raw
Responses Re: Drop Cascade of Domains  (Peter Eisentraut <peter_e@gmx.net>)
Re: Drop Cascade of Domains  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: elein
Date:
Subject: Domains and function
Next
From: Oliver Elphick
Date:
Subject: Re: Cron-job for checking up on pg_autovacuum