| From: | David Pradier <dpradier(at)apartia(dot)fr> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)surnet(dot)cl> |
| Cc: | Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>, Richard Huxton <dev(at)archonet(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: How to add an INHERITS to an already populated table |
| Date: | 2005-05-31 13:45:24 |
| Message-ID: | 20050531134522.GB4082@apartia.fr |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)apartia(dot)fr - tel: 01.46.47.21.33 - fax: 01.46.47.21.37
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rafa Couto | 2005-05-31 14:36:50 | Re: pg_get_serial_sequence and table inheritence |
| Previous Message | Alvaro Herrera | 2005-05-31 13:41:59 | Re: How to add an INHERITS to an already populated table |