Re: Enum proposal / design

Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:
> If you're gonna fix it at 4 bytes, then I strongly suggest
> that the value identifiers actually be OIDs assigned
> through the standard OID-generating mechanism, and that
> the pg_enum table have the structure

...

> The advantage of doing this is that you can use the
> existing, well debugged, normally-quite-fast mechanisms
> for generating new unique value identifiers. Rather than
> consing up your own slow full-table-scan mechanism as
> envisioned in the original proposal.

Yeah, I was never all that happy with that anyway, and
figured for the unique value thingy that we could either use
oids or set up a new sequence, but oids sounded like
significantly less work.

Cheers

Tom