X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 59337D1B16E for ; Mon, 19 Jul 2004 01:56:41 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 36517-03 for ; Mon, 19 Jul 2004 04:56:35 +0000 (GMT) Received: from megazone.bigpanda.com (megazone.bigpanda.com [64.147.171.210]) by svr1.postgresql.org (Postfix) with ESMTP id 961C9D1B16A for ; Mon, 19 Jul 2004 01:56:33 -0300 (ADT) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id 932B83576B; Sun, 18 Jul 2004 21:56:33 -0700 (PDT) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id 91CEA356A5; Sun, 18 Jul 2004 21:56:33 -0700 (PDT) Date: Sun, 18 Jul 2004 21:56:33 -0700 (PDT) From: Stephan Szabo To: evgeny tsurkin Cc: pgsql-admin@postgresql.org Subject: Re: inheritance question In-Reply-To: Message-ID: <20040718215354.I71415@megazone.bigpanda.com> References: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200407/214 X-Sequence-Number: 14282 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 *)