Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: [SQL] (Ab)Using schemas and inheritance
- From: Alban Hertroys <alban(at)magproductions(dot)nl>
- To: "Jim C. Nasby" <jnasby(at)pervasive(dot)com>
- Cc: Jorge Godoy <jgodoy(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
- Subject: Re: [SQL] (Ab)Using schemas and inheritance
- Date: Wed, 24 May 2006 11:09:38 +0200
- Message-id: <447422D2(dot)4060403(at)magproductions(dot)nl>
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(at)magproductions(dot)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 //
- Follow-Ups:
- Re: [SQL] (Ab)Using schemas and inheritance
- From: Jorge Godoy
- Re: [SQL] (Ab)Using schemas and inheritance
- References:
- Re: [SQL] (Ab)Using schemas and inheritance
- From: Jim C. Nasby
- Re: [SQL] (Ab)Using schemas and inheritance
- Prev by Date: Re: challenging constraint situation - how do I make it
- Next by Date: Re: allow LIMIT in UPDATE and DELETE
- Previous by thread: Re: [SQL] (Ab)Using schemas and inheritance
- Next by thread: Re: [SQL] (Ab)Using schemas and inheritance
- Indexes: