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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-admin by date

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