Re: Code tables, conditional foreign keys? - Mailing list pgsql-general

From Rodrigo E. De León Plicet
Subject Re: Code tables, conditional foreign keys?
Date
Msg-id a55915760905222105t69e27227pb57f363c435489ca@mail.gmail.com
Whole thread Raw
In response to Re: Code tables, conditional foreign keys?  (Scott Marlowe <scott.marlowe@gmail.com>)
Responses Re: Code tables, conditional foreign keys?
List pgsql-general
On Fri, May 22, 2009 at 10:38 PM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
> On Fri, May 22, 2009 at 4:10 PM, Benjamin Smith
> <lists@benjamindsmith.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.

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Code tables, conditional foreign keys?
Next
From: Henry
Date:
Subject: Excessive (?) Pg file descriptor use when partitioning