More ALTER TABLE/TYPE bugs

Started by Christopher Kings-Lynneover 21 years ago2 messageshackers
Jump to latest
#1Christopher Kings-Lynne
chriskl@familyhealth.com.au

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Christopher Kings-Lynne (#1)
Re: 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