Re: How to add an INHERITS to an already populated table

Поиск
Список
Период
Сортировка
От David Pradier
Тема Re: How to add an INHERITS to an already populated table
Дата
Msg-id 20050531134522.GB4082@apartia.fr
обсуждение исходный текст
Ответ на Re: How to add an INHERITS to an already populated table  (Alvaro Herrera <alvherre@surnet.cl>)
Список 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 по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: How to add an INHERITS to an already populated table
Следующее
От: Rafa Couto
Дата:
Сообщение: Re: pg_get_serial_sequence and table inheritence