Re: WIP: extensible enums
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Bruce Momjian <bruce@momjian.us>
Cc: Andrew Dunstan <andrew@dunslane.net>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2010-08-24T00:26:10Z
Lists: pgsql-hackers
Bruce Momjian <bruce@momjian.us> writes: > I also noticed you grab an oid for the new type using the oid counter > without trying to make it in sorted order. Seems that would be possible > for adding enums to the end of the list, and might not be worth it. A > quick hack might be to just try of an oid+1 from the last enum and see > if that causes a conflict with the pg_enum.oid index. That wouldn't be race-condition-safe. regards, tom lane