Re: [GENERAL] Drop Cascade of Domains

2003-11-29 Thread Tom Lane
elein <[EMAIL PROTECTED]> writes: > 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? Yes, we agreed some time ago that that is the best thing to do. regard

Re: [GENERAL] Drop Cascade of Domains

2003-11-29 Thread Peter Eisentraut
elein writes: > 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. While not allowed according to the SQL standard, we have decided

[GENERAL] Drop Cascade of Domains

2003-11-29 Thread elein
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,