Altering a table with a rowtype column

From: Mike Blackwell <mike(dot)blackwell(at)rrd(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Altering a table with a rowtype column
Date: 2012-03-07 17:22:00
Message-ID: CANPAkgsA3CrSzK_soK_FTO4S9jcwkA2T4EmQ-=tDzSq7rOhsLg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-general

Given a pair of tables:

create table a (
id serial,
stuff text,
more_stuff text
);

create table a_audit (
id serial,
old_record a,
new_record a
);

How can one alter the structure of table a? Attempting

ALTER TABLE a ADD COLUMN even_more_stuff text;

results in the message:

ERROR: cannot alter table "a" because column "a_audit.new_record" uses
its row type

A solution that doesn't lose the existing data is preferable.

Mike

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Merlin Moncure 2012-03-07 17:32:09 Re: Altering a table with a rowtype column
Previous Message Tom Lane 2012-03-07 15:59:09 Re: Extension tracking temp table and causing update failure

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2012-03-07 17:32:09 Re: Altering a table with a rowtype column
Previous Message Tom Lane 2012-03-07 17:11:01 Re: ERROR: could not find tuple for trigger 37463634