inheritance question

From: evgeny tsurkin <tsurkin(at)idefix(dot)jct(dot)ac(dot)il>
To: pgsql-admin(at)postgresql(dot)org
Subject: inheritance question
Date: 2004-07-13 11:32:47
Message-ID: Pine.LNX.4.44.0407131426240.23926-100000@idefix.jct.ac.il
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi All!
That probably was already asked thousand times
but i did not find an exact answer:
I want to have two tables the second one will have
all the columns from the first + some extra .The data
should be complittly separate .I was trying to use
inheritance and setted the SQL_INHERITANCE = false
to separate the data ,but when trying to add a column
to the father i have got an error:
ERROR: Attribute must be added to child tables too
what can i do ?
Thanks
Evgeny.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Simon Riggs 2004-07-13 11:38:23 Re: Point in Time Recovery
Previous Message Stef 2004-07-13 10:40:00 Re: Bad dumps...