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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Amaury Dumoulin <amaury(at)castordoc(dot)com>
Cc: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(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 14:42:38
Message-ID: 322345.1636036958@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Amaury Dumoulin <amaury(at)castordoc(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Maxim Boguk 2021-11-04 18:07:28 Re: BUG #17268: Possible corruption in toast index after reindex index concurrently
Previous Message Tom Lane 2021-11-04 14:22:57 Re: BUG #17271: Updating enum columns type fails when constraints exist