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

Re: inheritance question

From: mike g <mike(at)thegodshalls(dot)com>
To: evgeny tsurkin <tsurkin(at)idefix(dot)jct(dot)ac(dot)il>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: inheritance question
Date: 2004-07-17 04:38:52
Message-ID: 1090039131.14010.45.camel@localhost.localdomain (view raw or flat)
Thread:
Lists: 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

In response to

Responses

pgsql-admin by date

Next:From: teknetDate: 2004-07-17 07:41:58
Subject: add to table which name is in table
Previous:From: mike gDate: 2004-07-17 04:26:37
Subject: Re: Disk usage

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