Modular application needing additional columns?

From: Leif K-Brooks <eurleif(at)ecritters(dot)biz>
To: pgsql-general(at)postgresql(dot)org
Subject: Modular application needing additional columns?
Date: 2004-02-19 20:41:22
Message-ID: 40351F72.4060707@ecritters.biz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm writing an application with PostgreSQL as the database which I would
like to be as modular as possible. It will have various modules, each of
which will have their own database schema. A module with users might
define a user table, but an RPG module would want the user table to have
a column for money. I don't want the users module to know about the RPG
module beforehand, so it can't have the money column. Should the RPG
module subclass the user table and make other modules use its subclass
from now on? Should it just add the column when it's installed? What
have others done?

Browse pgsql-general by date

  From Date Subject
Next Message Roopali Sharma 2004-02-19 20:55:56 pg_restore problem
Previous Message Joshua D. Drake 2004-02-19 20:29:56 Re: PostgreSQL on Windows