Re: Schema design question

From: Matt Miller <mattm(at)epx(dot)com>
To: Bill Moseley <moseley(at)hank(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Schema design question
Date: 2005-08-17 21:35:04
Message-ID: 1124314504.3074.67.camel@dbamm01-linux
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 2005-08-17 at 13:40 -0700, Bill Moseley wrote:
> a course
> and class share so many columns. ...and
> I worry about changing a column type on one table and forgetting to
> change it on the other table.

Postgres types might help here. You could probably create a type that
contains the common columns, and then embed that type where you need it.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2005-08-17 21:52:47 Re: [GENERAL] Cascades Failing
Previous Message Fernando Lujan 2005-08-17 21:33:18 Re: [despammed] Generating random values.