Re: WIP: extensible enums - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: WIP: extensible enums
Date
Msg-id 4CBC563F.3060106@dunslane.net
Whole thread Raw
In response to Re: WIP: extensible enums  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: WIP: extensible enums
List pgsql-hackers

On 10/17/2010 03:56 PM, Tom Lane wrote:

[clever scheme to treat even numbered enum Oids as sorted]
>   The one problem I can see with this is that it's only partially
> on-disk-compatible with existing enum types: it'll almost certainly
> think that they require slow comparison, even when they don't.
> Maybe that's acceptable.

Thinking more about this, could we do some sort of hybrid scheme that 
stashes the 'oids are sorted correctly' property of the type somewhat 
like what I proposed?

Binary upgrade would be mildly tricky but not impossible.

cheers

andrew


pgsql-hackers by date:

Previous
From: Boxuan Zhai
Date:
Subject: Re: ask for review of MERGE
Next
From: Robert Haas
Date:
Subject: Re: security hook on table creation