Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group