Re: extensible enum types

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Simon Riggs <simon(at)2ndQuadrant(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: extensible enum types
Date: 2010-06-20 02:16:38
Message-ID: 4C1D7A06.6060401@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Simon Riggs wrote:
> On Fri, 2010-06-18 at 11:50 -0400, Andrew Dunstan wrote:
>
>
>> Thoughts?
>>
>
> enum types exist as an optimisation-by-avoidance of referential
> integrity.
>
> We're a relational database, so IMHO we should spend time performance
> tuning RI.
>
>

I don't accept your initial assertion at all. But in any case, these are
not mutually exclusive. Your work tuning RI will not obstruct mine in
making enums more useful, nor vice versa.

cheers

andrew

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Geoghegan 2010-06-20 02:42:48 Re: extensible enum types
Previous Message Simon Riggs 2010-06-20 00:19:00 Re: beta3 & the open items list