From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: keith.fiske@crunchydata.com, pgsql-bugs@lists.postgresql.org, Tom Lane <tgl@sss.pgh.pa.us>
Subject: Re: BUG #15865: ALTER TABLE statements causing "relation already exists" errors when some indexes exist
Date: Thu, 20 Jun 2019 16:45:05 -0400
Message-ID: <20190620204505.GA22934@alvherre.pgsql> (raw)
In-Reply-To: <15865-17940eacc8f8b081@postgresql.org>
On 2019-Jun-20, PG Bug reporting form wrote:
> When testing the setup of our monitoring platform, we started running into
> an error when using PostgreSQL as a backend for Grafana. We narrowed down
> the issue to only occurring with the latest point release of PG,
> specifically 11.4, 10.9 and 9.6.14 (previous major versions were not tested
> at this time). The issue can be recreated by following the setup steps for
> Grafana with a PG backend and it will occur when the Grafana service is
> started for the first time and it tries to set up its schema in PG. We do
> not see the error occurring with the previous minor versions (11.3, 10.8,
> 9.6.13).
Confirmed. Bisection says that
commit e76de886157b7f974d4d247908b242607cfbf043
Author: Tom Lane <tgl@sss.pgh.pa.us>
AuthorDate: Wed Jun 12 12:29:24 2019 -0400
CommitDate: Wed Jun 12 12:29:39 2019 -0400
Fix ALTER COLUMN TYPE failure with a partial exclusion constraint.
is the culprit.
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: alvherre@2ndquadrant.com, tgl@sss.pgh.pa.us
Subject: Re: BUG #15865: ALTER TABLE statements causing "relation already exists" errors when some indexes exist
In-Reply-To: <20190620204505.GA22934@alvherre.pgsql>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox