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

From David Pradier
Subject How to add an INHERITS to an already populated table ?
Date
Msg-id 20050531081025.GC2179@apartia.fr
Whole thread Raw
Responses Re: How to add an INHERITS to an already populated table
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: CREATE TEMP TABLE AS SELECT/ GET DIAGNOSTICS ROW_COUNT
Next
From: Richard Huxton
Date:
Subject: Re: a way to reset the postgres password to nothing..