Re: How to add an INHERITS to an already populated table - Mailing list pgsql-general

From David Pradier
Subject Re: How to add an INHERITS to an already populated table
Date
Msg-id 20050531134522.GB4082@apartia.fr
Whole thread Raw
In response to Re: How to add an INHERITS to an already populated table  (Alvaro Herrera <alvherre@surnet.cl>)
List pgsql-general
> Please note that the inheritance is not fully set -- if you discover
> strange behavior e.g. when altering any of the tables, don't be
> surprised.  In particular, you should set the attislocal and attinhcount
> attributes in pg_attribute for the child tables; also pg_depend entries
> are missing.  I don't know what else.
>
> Also you definitely shouldn't be using relfilenode, but the real Oid of
> the table (relfilenode is the filename only, not the internal identifier
> of the table).

I think I'll make a script and propose it for revision to the list
before using it on any real database.

David
--
dpradier@apartia.fr - tel: 01.46.47.21.33 - fax: 01.46.47.21.37

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: How to add an INHERITS to an already populated table
Next
From: Rafa Couto
Date:
Subject: Re: pg_get_serial_sequence and table inheritence