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

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: amaury(at)castordoc(dot)com, PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: BUG #17271: Updating enum columns type fails when constraints exist
Date: 2021-11-04 13:59:50
Message-ID: CAKFQuwbCVs4Bb4U2Hbgi-1z6uTDHUh8qoW5vr+QmKSaJkEaFZg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Thu, Nov 4, 2021 at 6:54 AM PG Bug reporting form <noreply(at)postgresql(dot)org>
wrote:

> The following bug has been logged on the website:
>
> Bug reference: 17271
> Logged by: Amaury Dumoulin
> Email address: amaury(at)castordoc(dot)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.

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Amaury Dumoulin 2021-11-04 14:18:18 Re: BUG #17271: Updating enum columns type fails when constraints exist
Previous Message David G. Johnston 2021-11-04 13:58:04 Re: BUG #17271: Updating enum columns type fails when constraints exist