From: Stephan Szabo <sszabo@megazone.bigpanda.com>
To: evgeny tsurkin <tsurkin@idefix.jct.ac.il>
Cc: pgsql-admin@postgresql.org
Subject: Re: inheritance question
Date: Sun, 18 Jul 2004 21:56:33 -0700 (PDT)
Message-ID: <20040718215354.I71415@megazone.bigpanda.com> (raw)
In-Reply-To: <Pine.LNX.4.44.0407131426240.23926-100000@idefix.jct.ac.il>
References: <Pine.LNX.4.44.0407131426240.23926-100000@idefix.jct.ac.il>
On Tue, 13 Jul 2004, 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 ?
Either don't use SQL_INHERITANCE=false, or specify that you want
to act upon the entire tree using the older syntax which I think
would look like ALTER TABLE first* add column ...
(note the *)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: sszabo@megazone.bigpanda.com, tsurkin@idefix.jct.ac.il
Subject: Re: inheritance question
In-Reply-To: <20040718215354.I71415@megazone.bigpanda.com>
References: <Pine.LNX.4.44.0407131426240.23926-100000@idefix.jct.ac.il> <20040718215354.I71415@megazone.bigpanda.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox