Re: referential integrity and defaults, DB design or trick

From: Richard Huxton <dev(at)archonet(dot)com>
To: Ivan Sergio Borgonovo <mail(at)webthatworks(dot)it>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: referential integrity and defaults, DB design or trick
Date: 2007-12-21 08:19:08
Message-ID: 476B76FC.8060200@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ivan Sergio Borgonovo wrote:
> The default property (that is actually made by several fields) in my
> case is not completely homogeneous with the others, because it has a
> double meaning.
> It is cleaner to split the meanings and the data.

It usually is. A lot of the design decisions you can regret a year or
two down the line are from trying to use one value for two purposes.

--
Richard Huxton
Archonet Ltd

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Cotter 2007-12-21 10:06:44 Machine spec 64-bit/32 GB RAM
Previous Message Wolfgang Keller 2007-12-21 08:12:13 Re: settings for 8.2.5 on Mac OS X 10.4.11