More ALTER TABLE/TYPE bugs

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

Responses

Browse pgsql-hackers by date

  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