Re: extensible enum types - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: extensible enum types
Date
Msg-id 1277140293.32273.2664.camel@ebony
Whole thread Raw
In response to Re: extensible enum types  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-hackers
On Mon, 2010-06-21 at 12:04 -0500, Kevin Grittner wrote:
> Peter Geoghegan <peter.geoghegan86@gmail.com> wrote:
>  
> > In my experience, lookup tables generally have two columns, an
> > integer PK and a description/state.
>  
> Eek.  If that's what you consider a lookup table, I wouldn't
> advocate their use for anything.  Ever.  Period.

Do you mean you don't use relational modelling, or do you mean you would
never implement your physical database that way because of the
performance impact of RI on PostgreSQL? Or?

-- Simon Riggs           www.2ndQuadrant.comPostgreSQL Development, 24x7 Support, Training and Services



pgsql-hackers by date:

Previous
From: "mac_man2005@hotmail.it"
Date:
Subject: Re: About tapes
Next
From: Tom Lane
Date:
Subject: Re: deprecating =>, take two