From: Tom Lane <tgl@sss.pgh.pa.us>
To: Amaury Dumoulin <amaury@castordoc.com>
cc: "David G. Johnston" <david.g.johnston@gmail.com>,
        PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
Subject: Re: BUG #17271: Updating enum columns type fails when constraints
 exist
In-reply-to: 
 <CAPqDOR9oskSayO-eiR1eyRpYXUqHbrA3rfBS7PSkc79WkS-HGA@mail.gmail.com>
References: <17271-8b4317357c4991e2@postgresql.org>
 <CAKFQuwbCVs4Bb4U2Hbgi-1z6uTDHUh8qoW5vr+QmKSaJkEaFZg@mail.gmail.com>
 <CAPqDOR9oskSayO-eiR1eyRpYXUqHbrA3rfBS7PSkc79WkS-HGA@mail.gmail.com>
Comments: In-reply-to Amaury Dumoulin <amaury@castordoc.com>
	message dated "Thu, 04 Nov 2021 15:18:18 +0100"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <322344.1636036958.1@sss.pgh.pa.us>
Date: Thu, 04 Nov 2021 10:42:38 -0400
Message-ID: <322345.1636036958@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/322345.1636036958%40sss.pgh.pa.us>
Precedence: bulk

Amaury Dumoulin <amaury@castordoc.com> writes:
> I believe it should fail.
> However the error message should state that the constraint is blocking the
> operation.
> The current error message makes it hard to make a connection to the culprit.

Hmm, that's a reasonable concern, though you didn't make it clear that
that was what you were on about.  We could possibly provide an addendum
like "CONTEXT: while processing constraint foo" in this situation.

			regards, tom lane