Re: [PATCH] Add schema and table names to partition error - Mailing list pgsql-hackers

From Amit Kapila
Subject Re: [PATCH] Add schema and table names to partition error
Date
Msg-id CAA4eK1+xv+ZGPkySPieKPnX+PR1Af0pADhdkhU9PgH3J+Khmgg@mail.gmail.com
Whole thread Raw
In response to Re: [PATCH] Add schema and table names to partition error  (Chris Bandy <bandy.chris@gmail.com>)
Responses Re: [PATCH] Add schema and table names to partition error  (Amit Langote <amitlangote09@gmail.com>)
Re: [PATCH] Add schema and table names to partition error  (Chris Bandy <bandy.chris@gmail.com>)
List pgsql-hackers
On Thu, Mar 19, 2020 at 3:55 AM Chris Bandy <bandy.chris@gmail.com> wrote:
>
>
> Sorry for these troubles. Attached are patches created using `git
> format-patch -n -v6` on master at 487e9861d0.
>

No problem.  I have extracted your code changes as a separate patch
(see attached) as I am not sure we want to add tests for these cases.
This doesn't apply in back-branches, but I think that is small work
and we can do that if required.  The real question is do we want to
back-patch this?  Basically, this improves the errors in certain cases
by providing additional information that otherwise the user might need
to extract from error messages.  So, there doesn't seem to be pressing
need to back-patch this but OTOH, we have mentioned in docs that we
support to display this information for all SQLSTATE class 23
(integrity constraint violation) errors which is not true as we forgot
to adhere to that in some parts of code.

What do you think?  Anybody else has an opinion on whether to
back-patch this or not?

[1] - https://www.postgresql.org/docs/devel/errcodes-appendix.html

-- 
With Regards,
Amit Kapila.
EnterpriseDB: http://www.enterprisedb.com

Attachment

pgsql-hackers by date:

Previous
From: Masahiko Sawada
Date:
Subject: Re: logical copy_replication_slot issues
Next
From: Laurenz Albe
Date:
Subject: Re: Berserk Autovacuum (let's save next Mandrill)