Redundant errdetail prefix "The error was:" in some logical replication messages

From: Peter Smith <smithpb2250(at)gmail(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Redundant errdetail prefix "The error was:" in some logical replication messages
Date: 2021-03-30 04:29:35
Message-ID: CAHut+Ps-Qv2yQceCwobQDP0aJOkfDzRFrOaR6+2Op2K=WHGeWg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

There are a couple of error messages within the logical replication
code where the errdetail text includes a prefix of "The error was:"

I could not find any other examples in all the PG src which have a
similar errdetail prefix like this.

The text seems not only redundant, but "The error was: ERROR: " also
looks a bit peculiar.

e.g.
------
2021-03-30 14:17:37.567 AEDT [22317] ERROR: could not drop the
replication slot "tap_sub" on publisher
2021-03-30 14:17:37.567 AEDT [22317] DETAIL: The error was: ERROR:
replication slot "tap_sub" does not exist
2021-03-30 14:17:37.567 AEDT [22317] STATEMENT: DROP SUBSCRIPTION tap_sub;
------

PSA a small patch which simply removes this prefix "The error was:"

------
Kind Regards,
Peter Smith.
Fujitsu Australia

Attachment Content-Type Size
v1-0001-Remove-redundant-errdetail-The-error-was.patch application/octet-stream 2.8 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message vignesh C 2021-03-30 04:43:29 Re: Replication slot stats misgivings
Previous Message Etsuro Fujita 2021-03-30 04:10:31 Re: Obsolete comment in postgres_fdw.c