Changing to a domain and back doesn't do dependencies correctly:

test=# create table parent (a int4);
CREATE TABLE
test=# drop table parent;
DROP TABLE
test=# drop domain dom;
DROP DOMAIN
test=# create table parent (a int4);
CREATE TABLE
test=# create domain dom as bigint;
CREATE DOMAIN
test=# alter table parent alter a type dom;
ALTER TABLE
test=# alter table parent alter a type int4;
ERROR:  found unexpected dependency for column

Chris


Wed, 04 Aug 2004 12:27:16 +0800
Christopher Kings-Lynne <chriskl@familyhealth.com.au>
More ALTER TABLE/TYPE bugs
Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
> Changing to a domain and back doesn't do dependencies correctly:

Fixed.  Thanks.

			regards, tom lane

Wed, 04 Aug 2004 16:54:26 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: More ALTER TABLE/TYPE bugs 