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