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@xxxxxxxxxxxxxxxxx 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 //
