Re: inheritance question - Mailing list pgsql-admin

From mike g
Subject Re: inheritance question
Date
Msg-id 1090039131.14010.45.camel@localhost.localdomain
Whole thread Raw
In response to inheritance question  (evgeny tsurkin <tsurkin@idefix.jct.ac.il>)
Responses Re: inheritance question
List pgsql-admin
According to your posting below the second table will have all the
columns of the first table plus extra columns.  If that is true then why
are you trying to add a column to your first table and not your second
table as well?

On Tue, 2004-07-13 at 06:32, evgeny tsurkin wrote:
> 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.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

pgsql-admin by date:

Previous
From: mike g
Date:
Subject: Re: Disk usage
Next
From: teknet@poczta.onet.pl
Date:
Subject: add to table which name is in table