Re: Code tables, conditional foreign keys?

From: Rodrigo E(dot) De León Plicet <rdeleonp(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Cc: Benjamin Smith <lists(at)benjamindsmith(dot)com>
Subject: Re: Code tables, conditional foreign keys?
Date: 2009-05-23 04:05:13
Message-ID: a55915760905222105t69e27227pb57f363c435489ca@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, May 22, 2009 at 10:38 PM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> wrote:
> On Fri, May 22, 2009 at 4:10 PM, Benjamin Smith
> <lists(at)benjamindsmith(dot)com> wrote:
>>
>> Is there a better way?
>
> Yeah, natural keys.

+1.

Also, what Ben described reeks of EAV.

Ben, please read:

http://joecelkothesqlapprentice.blogspot.com/2006/04/using-one-table-vs-many.html

... and avoid traveling down that (ugly) path.

Good luck.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Henry 2009-05-23 05:45:34 Excessive (?) Pg file descriptor use when partitioning
Previous Message Scott Marlowe 2009-05-23 03:38:45 Re: Code tables, conditional foreign keys?