BUG #15286: BEFORE or AFTER not working while adding values forexisting enums

Поиск
Список
Период
Сортировка
От PG Bug reporting form
Тема BUG #15286: BEFORE or AFTER not working while adding values forexisting enums
Дата
Msg-id 153206236870.1405.3502568417414309750@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #15286: BEFORE or AFTER not working while adding values for existing enums  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
Список pgsql-bugs
Дерево обсуждения 
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 по дате отправления:

Предыдущее
От: Peter Geoghegan
Дата:
Сообщение: Re: BUG #15285: Query used index over field with ICU collation insome cases wrongly return 0 rows
Следующее
От: Andrew Gierth
Дата:
Сообщение: Re: BUG #15286: BEFORE or AFTER not working while adding values for existing enums