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 46607D1B182 for ; Sat, 17 Jul 2004 01:41:16 -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 91482-08 for ; Sat, 17 Jul 2004 04:41:12 +0000 (GMT) Received: from rwcrmhc11.comcast.net (rwcrmhc11.comcast.net [204.127.198.35]) by svr1.postgresql.org (Postfix) with ESMTP id 78384D1B34A for ; Sat, 17 Jul 2004 01:41:06 -0300 (ADT) Received: from localhost.localdomain (c-67-162-89-61.client.comcast.net[67.162.89.61]) by comcast.net (rwcrmhc11) with ESMTP id <20040717044111013003j546e>; Sat, 17 Jul 2004 04:41:12 +0000 Received: from localhost.localdomain (localhost.localdomain [127.0.0.1]) by localhost.localdomain (8.12.11/8.12.11) with ESMTP id i6H4cxOl014863; Fri, 16 Jul 2004 23:38:59 -0500 Received: (from spike@localhost) by localhost.localdomain (8.12.11/8.12.11/Submit) id i6H4cqgK014860; Fri, 16 Jul 2004 23:38:52 -0500 X-Authentication-Warning: localhost.localdomain: spike set sender to mike@thegodshalls.com using -f Subject: Re: inheritance question From: mike g Reply-To: mike@thegodshalls.com To: evgeny tsurkin Cc: pgsql-admin@postgresql.org In-Reply-To: References: Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1090039131.14010.45.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.5 (1.4.5-7) Date: Fri, 16 Jul 2004 23:38:52 -0500 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.1 tagged_above=0.0 required=5.0 tests=RCVD_IN_SORBS X-Spam-Level: X-Archive-Number: 200407/194 X-Sequence-Number: 14262 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