Postgres Pro
Downloads
Home   >   mailing lists

BUG #15286: BEFORE or AFTER not working while adding values forexisting enums - Mailing list pgsql-bugs

From PG Bug reporting form
Subject BUG #15286: BEFORE or AFTER not working while adding values forexisting enums
Date
Msg-id 153206236870.1405.3502568417414309750@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #15286: BEFORE or AFTER not working while adding values for existing enums  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
List pgsql-bugs
Tree view 
The following bug has been logged on the website:

Bug reference:      15286
Logged by:          Nivruth Nandigam
Email address:      nivruth_n@yahoo.com
PostgreSQL version: 10.4
Operating system:   Windows
Description:

Hi there,

I'm trying to modify an existing enum and use the BEFORE or AFTER feature to
add a value in between the existing values but I'm noticing that the values
are only being added to the enum in the end. Please look into this and fix
this as soon as possible. The query I'm using is 

alter type my_enum add value 'second' after 'one;

pgsql-bugs by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: BUG #15285: Query used index over field with ICU collation insome cases wrongly return 0 rows
Next
From: Andrew Gierth
Date:
Subject: Re: BUG #15286: BEFORE or AFTER not working while adding values for existing enums