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 8035BD1B1BE for ; Sun, 18 Jul 2004 05:50:38 -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 61373-10 for ; Sun, 18 Jul 2004 08:50:41 +0000 (GMT) Received: from kidushin.jct.ac.il (unknown [147.161.1.19]) by svr1.postgresql.org (Postfix) with SMTP id 23EA6D1B1B3 for ; Sun, 18 Jul 2004 05:50:31 -0300 (ADT) Received: (from localhost [147.161.1.32]) by kidushin.jct.ac.il (SAVSMTP 3.1.3.37) with SMTP id M2004071811502621476 for ; Sun, 18 Jul 2004 11:50:26 +0300 Received: from evegeni.mm.huji.ac.il (evegeni.mm.huji.ac.il [132.64.52.127]) by webmail.jct.ac.il (Horde) with HTTP for ; Sun, 18 Jul 2004 11:50:38 +0300 Message-ID: <1090140638.027e45903a6f3@webmail.jct.ac.il> Date: Sun, 18 Jul 2004 11:50:38 +0300 From: tsurkin@jct.ac.il To: pgsql-admin@postgresql.org Subject: inheretence question References: In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset="UTF-8" Content-Disposition: inline Content-Transfer-Encoding: 7bit User-Agent: Internet Messaging Program (IMP) 4.0-cvs X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.4 tagged_above=0.0 required=5.0 tests=NO_REAL_NAME, RCVD_IN_RFCI X-Spam-Level: X-Archive-Number: 200407/212 X-Sequence-Number: 14280 I am but that is what actually want : to be able to add a column to the first table and have the second to be added a coulumns automatically.The target is realy simple : i want to simplify management of the schema and thus be able to manage only parantes - children should be managed aoutomagically But the data is NOT the same! Isn't it the inheretence is all about - to inherit? On Fri, 16 Jul 2004, mike g wrote: > 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 >