pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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 *)





view thread (6+ messages)  latest in thread

Message-ID: <20040718215354.I71415@megazone.bigpanda.com>
Permalink:  ../20040718215354.I71415@megazone.bigpanda.com/
Also on:    postgresql.org/message-id/20040718215354.I71415@megazone.bigpanda.com

 · 

reply

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