Drop Cascade of Domains

From: elein <elein(at)varlena(dot)com>
To: pgsql-general(at)postgresql(dot)org
Cc: elein <elein(at)varlena(dot)com>
Subject: Drop Cascade of Domains
Date: 2003-11-29 22:17:43
Message-ID: 20031129141743.C6974@cookie.varlena.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)varlena(dot)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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Oliver Elphick 2003-11-29 22:42:40 Re: Cron-job for checking up on pg_autovacuum
Previous Message elein 2003-11-29 22:11:20 Domains and function