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 CAKFQuwbCVs4Bb4U2Hbgi-1z6uTDHUh8qoW5vr+QmKSaJkEaFZg@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:       


Any particular reason you didn't just use:

ALTER TYPE name ADD VALUE [ IF NOT EXISTS ] new_enum_value [ { BEFORE | AFTER } neighbor_enum_value ]

David J.

pgsql-bugs by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: BUG #17271: Updating enum columns type fails when constraints exist
Next
From: Amaury Dumoulin
Date:
Subject: Re: BUG #17271: Updating enum columns type fails when constraints exist