Re: How to modify ENUM datatypes? (The solution)

About LGPL - I don't know.
But the license is not a problem, this code is totally freeware (because too
simple).
LGPL is just my favorite license type for years. :-)

I'll change this if you prefer another license and explain, why (why BSD?
BSD is the PostgreSQL license?)

On Wed, Aug 13, 2008 at 4:25 AM, Merlin Moncure <mmoncure(at)gmail(dot)com> wrote:

> On Tue, Aug 12, 2008 at 5:40 PM, Dmitry Koterov <dmitry(at)koterov(dot)ru> wrote:
> > Here is the solution about "on the fly" ALTER ENUM:
> > http://en.dklab.ru/lib/dklab_postgresql_enum/
> >
> > Usage:
> >
> > -- Add a new element to the ENUM "on the fly".
> >
> > SELECT enum.enum_add('my_enum', 'third');
> >
> > -- Remove an element from the ENUM "on the fly".
> > SELECT enum.enum_del('my_enum', 'first');
> >
> > Possibly future versions of PostgreSQL will include built-in ALTER TYPE
> for
> > ENUM, all the more its implementation is not impossible, as you see
> above.
> > Hope this will be helpful.
>
> Decent user space solution...it's easy enough. IMO 'real' solution is
> through alter type as you suggest. It's worth noting there there is
> no handling for the unlikely but still possible event of oid
> wraparound. Also, there is no 'enum_insert', which is not so pleasant
> with how enums are implemented.
>
> Also, is lgpl compatible with bsd licnese? Not that it matters, but I'm
> curious.
>
> merlin
>