X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 9880F9FA1A0 for ; Wed, 24 May 2006 06:09:53 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 42263-06 for ; Wed, 24 May 2006 06:09:47 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mx1.magproductions.nl (magfour.magproductions.nl [87.249.97.162]) by postgresql.org (Postfix) with ESMTP id 54F609FA16E for ; Wed, 24 May 2006 06:09:47 -0300 (ADT) Received: from [82.75.196.246] (helo=[172.27.1.3]) by mx1.magproductions.nl with esmtpsa (TLS-1.0:DHE_RSA_AES_256_CBC_SHA:32) (Exim 4.50) id 1FipJl-0000u6-DC; Wed, 24 May 2006 11:06:13 +0200 Message-ID: <447422D2.4060403@magproductions.nl> Date: Wed, 24 May 2006 11:09:38 +0200 From: Alban Hertroys User-Agent: Mozilla Thunderbird 1.0.8 (X11/20060502) X-Accept-Language: en-us, en MIME-Version: 1.0 To: "Jim C. Nasby" CC: Jorge Godoy , pgsql-general@postgresql.org Subject: Re: [SQL] (Ab)Using schemas and inheritance References: <200605231716.58784.jgodoy@gmail.com> <20060523232609.GP64371@pervasive.com> In-Reply-To: <20060523232609.GP64371@pervasive.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Host-Lookup-Failed: Reverse DNS lookup failed for 82.75.196.246 (failed) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/1138 X-Sequence-Number: 95930 Jim C. Nasby wrote: > Moving to -general, where it's more likely that others will have input. > Perhaps the biggest issue is: what happens when you need to do DDL? If > you have 1000 schemas that should be identical, you'll need to perform > any DDL 1000 times. What about using updatable views instead of inheritence? You'd need your company_id back, but adding new companies or modifying table definitions could be a lot easier (as long as you don't need to update all of your views...). -- Alban Hertroys alban@magproductions.nl magproductions b.v. T: ++31(0)534346874 F: ++31(0)534346876 M: I: www.magproductions.nl A: Postbus 416 7500 AK Enschede // Integrate Your World //