From: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
---|---|
To: | keith(dot)fiske(at)crunchydata(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Subject: | Re: BUG #15865: ALTER TABLE statements causing "relation already exists" errors when some indexes exist |
Date: | 2019-06-20 20:45:05 |
Message-ID: | 20190620204505.GA22934@alvherre.pgsql |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-hackers |
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(at)sss(dot)pgh(dot)pa(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2019-06-20 21:08:29 | Re: BUG #15865: ALTER TABLE statements causing "relation already exists" errors when some indexes exist |
Previous Message | PG Bug reporting form | 2019-06-20 20:14:29 | BUG #15865: ALTER TABLE statements causing "relation already exists" errors when some indexes exist |
From | Date | Subject | |
---|---|---|---|
Next Message | David Fetter | 2019-06-20 21:00:34 | Re: Tweaking DSM and DSA limits |
Previous Message | Andrew Gierth | 2019-06-20 20:23:25 | Re: UCT (Re: pgsql: Update time zone data files to tzdata release 2019a.) |