Re: extensible enum types - Mailing list pgsql-hackers

From Robert Haas
Subject Re: extensible enum types
Date
Msg-id AANLkTikdrGIJ7wCy9qS7r_9RA0a7QTMJR3TSZ-BzPlme@mail.gmail.com
Whole thread Raw
In response to extensible enum types  (Andrew Dunstan <andrew@dunslane.net>)
Responses Re: extensible enum types  (Andrew Dunstan <andrew@dunslane.net>)
Re: extensible enum types  ("David E. Wheeler" <david@kineticode.com>)
List pgsql-hackers
On Fri, Jun 18, 2010 at 11:50 AM, Andrew Dunstan <andrew@dunslane.net> wrote:
> Then set the
> first value at  8 * p, then next at 9* p and so on. This is designed to
> allow more space to add labels at the beginning and end of the list, where
> this is more likely. Adding a label would be a matter of finding the labels
> adjacent to the position where we want to add the new label, and placing it
> half way between them, possibly with special rules for the list ends. If we
> want to add the label between two labels having values n and n+1 the
> addition would fail.

I like the idea of being able to modify enums on the fly, but I'm
skeptical of an implementation that won't always work.  Maybe it's
still better than what we have now, but it seems grotty.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company


pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: extensible enum types
Next
From: Andrew Dunstan
Date:
Subject: Re: extensible enum types