How to add an INHERITS to an already populated table ?

Поиск
Список
Период
Сортировка
От David Pradier
Тема How to add an INHERITS to an already populated table ?
Дата
Msg-id 20050531081025.GC2179@apartia.fr
обсуждение исходный текст
Ответы Re: How to add an INHERITS to an already populated table  (Richard Huxton <dev@archonet.com>)
Список pgsql-general
Hi everybody,

is it possible to add some inheritance lively, without doing a
dump/restore ?

Some bits of information to explain why I'd like to do that :
I've got those big tables, without correct constraints, sometimes even
without foreign keys et with sometimes some problems of data corruption,
coming from the application part.
What I'd really like to do is to add to every important table some
inheritance to a table we have which contains the following information :
(created_by, modified_by, date_of_creation, date_of_modification).
And of course, I can't stop the server.

Best regards,
David

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

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: CREATE TEMP TABLE AS SELECT/ GET DIAGNOSTICS ROW_COUNT
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: a way to reset the postgres password to nothing..