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
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 |