Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #17271: Updating enum columns type fails when constraints exist - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: BUG #17271: Updating enum columns type fails when constraints exist
Date
Msg-id CAKFQuwaY4CjKb=yHDMhSfER+y4P9p=vnC0PJ3Gdve5tewA15eA@mail.gmail.com
Whole thread Raw
In response to BUG #17271: Updating enum columns type fails when constraints exist  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #17271: Updating enum columns type fails when constraints exist
List pgsql-bugs
Tree view
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 by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #17271: Updating enum columns type fails when constraints exist
Next
From: "David G. Johnston"
Date:
Subject: Re: BUG #17271: Updating enum columns type fails when constraints exist