| From: | Álvaro Herrera <alvherre(at)kurilemu(dot)de> |
|---|---|
| To: | Michael Paquier <michael(at)paquier(dot)xyz> |
| Cc: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, huseyin(dot)d3r(at)gmail(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org |
| Subject: | Re: BUG #19393: pg_upgrade fails with duplicate key violation when CHECK constraint named *_not_null exists |
| Date: | 2026-02-23 16:47:46 |
| Message-ID: | 202602231541.tcrufawcdbne@alvherre.pgsql |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-hackers |
On 2026-Feb-22, Michael Paquier wrote:
> While I get the feeling of urgency, I am wondering if this particular
> fix should have been delayed and pushed for next May's release. We
> are already doing one quick release for the regressions found in the
> CVE fixes..
I debated that with myself before pushing. I thought the risk of
introducing a new bug or problem was pretty low; whereas the bug was
clearly already affecting real-world users in their attempts to migrate
to 18 from earlier versions, so the damage was real.
> Based on my read of the fix, I feel rather safe that this is OK. But
> as I have quoted upthread, the reason why I did not reply yet was to
> wait for next week's release to be out before acting. That's your
> code of course, so no objections from here, just a slight doubt about
> the timing.
Hmm, what? The only response from you that I see in this thread is
https://postgr.es/m/aYp9tTWjUqS1ffAd@paquier.xyz
which was on Feb 10th, which is before the 18.2 release, so you couldn't
have been considering the 18.3 release yet.
--
Álvaro Herrera PostgreSQL Developer — https://www.EnterpriseDB.com/
"On the other flipper, one wrong move and we're Fatal Exceptions"
(T.U.X.: Term Unit X - http://www.thelinuxreview.com/TUX/)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rafia Sabih | 2026-02-23 19:04:54 | Re: BUG #19414: Wrong rows returned by index scan on HASH-partitioned table with PRIMARY KEY (PostgreSQL 16.9) |
| Previous Message | Hayato Kuroda (Fujitsu) | 2026-02-23 08:26:14 | RE: [BUG] Assert failure in ReorderBufferReturnTXN during logical decoding due to leaked specinsert change |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jacob Champion | 2026-02-23 16:48:02 | Re: Add ssl_(supported|shared)_groups to sslinfo |
| Previous Message | Peter Eisentraut | 2026-02-23 16:44:07 | Re: some validate_relation_kind() tidying |