From: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
---|---|
To: | Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | More ALTER TABLE/TYPE bugs |
Date: | 2004-08-04 04:27:16 |
Message-ID: | 411065A4.3030602@familyhealth.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2004-08-04 04:30:42 | Re: Open items |
Previous Message | Tom Lane | 2004-08-04 04:22:36 | Re: Preliminary PITR documentation available |