Re: BUG #19629: pg_restore_relation_stats reports XX000 instead of proper SQLSTATE for input validation errors

From: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
To: Michael Paquier <michael(at)paquier(dot)xyz>
Cc: Ayush Tiwari <ayushtiwari(dot)slg01(at)gmail(dot)com>, hackerzheng666(at)gmail(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #19629: pg_restore_relation_stats reports XX000 instead of proper SQLSTATE for input validation errors
Date: 2026-08-27 14:45:08
Message-ID: CAHGQGwEjyebEbZ2X_9=H_xUpgJH+4qjCOzk+2B-doJ=ZFWhO-g@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Tue, Aug 25, 2026 at 2:14 PM Fujii Masao <masao(dot)fujii(at)gmail(dot)com> wrote:
> I found a similar precedent in commit 89e80b032975. It also changed
> user-visible SQLSTATEs from XX000 to more appropriate error codes,
> but was backpatched only to v9.5, which had not been released yet
> at the time. The commit message says:
>
> Back-patch to 9.5, but no further; changing ERRCODE assignments in
> stable branches doesn't seem like a good idea.
>
> Following that, I am now inclined to backpatch this only to v19, and
> not to v18.

I've pushed the patch and backpatched it to v19. Thanks!

Regards,

--
Fujii Masao

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Pierre Forstmann 2026-08-27 15:49:50 Re: BUG #19369: Not documented that io_uring on kernel versions between 5.1 and below 5.6 does not work
Previous Message Daniel Gustafsson 2026-08-27 11:57:02 Re: autovacuum: automatically propagate updated parameters