Re: WIP: extensible enums - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: WIP: extensible enums
Date
Msg-id 4C72C9EF.6010307@enterprisedb.com
Whole thread Raw
In response to Re: WIP: extensible enums  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: WIP: extensible enums
List pgsql-hackers
On 23/08/10 22:06, Tom Lane wrote:
> Thom Brown<thom@linux.com>  writes:
>> On 23 August 2010 19:25, Joseph Adams<joeyadams3.14159@gmail.com>  wrote:
>>> But what if you want to insert an OID at the end?
>
>> ALTER TYPE colors ADD 'orange';
>
> Alternatively, if people are dead set on symmetry, what we should do
> to simplify is drop *this* syntax, and just have the BEFORE and AFTER
> variants.

Then you need to know the last existing value to add a new one to the 
end. Seems awkward.

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: [9.1] pg_stat_get_backend_server_addr
Next
From: Alvaro Herrera
Date:
Subject: Re: Return of the Solaris vacuum polling problem -- anyone remember this?