Re: Altering a table with a rowtype column - Mailing list pgsql-general

From Mike Blackwell
Subject Re: Altering a table with a rowtype column
Date
Msg-id CANPAkgsPC+EGUkAg7wq+og=Wm-e=N_NUTvaBMvKQUJtvM7620w@mail.gmail.com
Whole thread Raw
In response to Altering a table with a rowtype column  (Mike Blackwell <mike.blackwell@rrd.com>)
List pgsql-general

works for me -- what version are you on?

merlin

------

[wcs1459@aclnx-cisp01 ~]$ psql --version
psql (PostgreSQL) 9.1.1
contains support for command-line editing


[wcs1459@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@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



pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: Altering a table with a rowtype column
Next
From: Merlin Moncure
Date:
Subject: Re: Altering a table with a rowtype column