How to add an INHERITS to an already populated table ?

From: David Pradier <dpradier(at)apartia(dot)fr>
To: pgsql-general(at)postgresql(dot)org
Subject: How to add an INHERITS to an already populated table ?
Date: 2005-05-31 08:10:25
Message-ID: 20050531081025.GC2179@apartia.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)apartia(dot)fr - tel: 01.46.47.21.33 - fax: 01.46.47.21.37

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2005-05-31 09:17:41 Re: a way to reset the postgres password to nothing..
Previous Message Jeff Brown 2005-05-31 06:31:17 Accessing PostgreSQL from C++