Tom Lane <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
