Andrew Dunstan wrote: > In the catalog, pg_type would > get a new column of type text[] that would hold the list of values, and > typtype would have a new possible value of 'e' for enumeration. There > might be other consequential changes too, but I think that would be most > of it.
Huh, why not have the actual values in a separate catalog like pg_enumvalues or some such? > The only functions that actually need to have any knowledge of > the enumeration strings are the input/output functions and the to/from > text casts. These would get the relevant info from fcinfo.flinfo ... and > then looking up the type cache - not sure yet if an extra cache > operation is needed. It'd be interesting to measure the difference of having the cache vs. not having it. Thinking on how to pg_dump the whole thing is important too. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster