Re: BUG #17271: Updating enum columns type fails when constraints exist

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: BUG #17271: Updating enum columns type fails when constraints exist
Дата
Msg-id CAKFQuwaY4CjKb=yHDMhSfER+y4P9p=vnC0PJ3Gdve5tewA15eA@mail.gmail.com
обсуждение исходный текст
Ответ на BUG #17271: Updating enum columns type fails when constraints exist  (PG Bug reporting form <noreply@postgresql.org>)
Ответы Re: BUG #17271: Updating enum columns type fails when constraints exist  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
Дерево обсуждения
On Thu, Nov 4, 2021 at 6:54 AM PG Bug reporting form <noreply@postgresql.org> wrote:
The following bug has been logged on the website:

Bug reference:      17271
Logged by:          Amaury Dumoulin
Email address:      amaury@castordoc.com
PostgreSQL version: 12.8
Operating system:   alpine 3.14 on docker (host macOs 11.6)
Description:       

Error message upon failure

With a sibyllin error message
ERROR:  operator does not exist: direction_state = direction_state_old
HINT:  No operator matches the given name and argument types. You might need
to add explicit type casts.

If we drop and recreate the constraint it works


This does not surprise me - why do you believe it is a bug?  What should happen?

David J.

В списке pgsql-bugs по дате отправления:

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #17271: Updating enum columns type fails when constraints exist
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: BUG #17271: Updating enum columns type fails when constraints exist