From: | Mike Blackwell <mike(dot)blackwell(at)rrd(dot)com> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Altering a table with a rowtype column |
Date: | 2012-03-07 17:46:59 |
Message-ID: | CANPAkgsPC+EGUkAg7wq+og=Wm-e=N_NUTvaBMvKQUJtvM7620w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-general |
>
>
> works for me -- what version are you on?
>
> merlin
>
> ------
>
> [wcs1459(at)aclnx-cisp01 ~]$ psql --version
> psql (PostgreSQL) 9.1.1
> contains support for command-line editing
>
>
> [wcs1459(at)aclnx-cisp01 ~]$ cat x
> create table a (
> id serial,
> stuff text,
> more_stuff text
> );
>
> create table a_audit (
> id serial,
> a_old a,
> a_new a
> );
>
> alter table a add column even_more_stuff boolean not null default false;
>
>
> [wcs1459(at)aclnx-cisp01 ~]$ psql -f x
> psql:x:5: NOTICE: CREATE TABLE will create implicit sequence "a_id_seq"
> for serial column "a.id"
> CREATE TABLE
> psql:x:11: NOTICE: CREATE TABLE will create implicit sequence
> "a_audit_id_seq" for serial column "a_audit.id"
> CREATE TABLE
> psql:x:13: ERROR: cannot alter table "a" because column "a_audit.a_new"
> uses its row type
>
>
>>
From | Date | Subject | |
---|---|---|---|
Next Message | Merlin Moncure | 2012-03-07 17:51:56 | Re: [GENERAL] Altering a table with a rowtype column |
Previous Message | Merlin Moncure | 2012-03-07 17:32:09 | Re: Altering a table with a rowtype column |
From | Date | Subject | |
---|---|---|---|
Next Message | Merlin Moncure | 2012-03-07 17:51:56 | Re: [GENERAL] Altering a table with a rowtype column |
Previous Message | Merlin Moncure | 2012-03-07 17:32:09 | Re: Altering a table with a rowtype column |