BUG #18829: RAISE NOTICE appends 's' to string in PostgreSQL 17.2

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: armandnortjee(at)gmail(dot)com
Subject: BUG #18829: RAISE NOTICE appends 's' to string in PostgreSQL 17.2
Date: 2025-03-02 14:18:55
Message-ID: 18829-2ed4d964795b3b57@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 18829
Logged by: Armand
Email address: armandnortjee(at)gmail(dot)com
PostgreSQL version: 17.2
Operating system: Windows 10
Description:

In PostgreSQL 17.2, when using the RAISE NOTICE command with a string
variable, the output incorrectly appends an extra 's' to the string value.
This issue does not occur when running the same code in earlier PostgreSQL
versions (e.g., PostgreSQL 16).

DO $$
DECLARE
my_var TEXT := 'garth';
BEGIN
RAISE NOTICE '%s is slim', my_var;
END
$$;

Expected Result:
The output should be:
NOTICE: garth is slim

Actual Result:
The output incorrectly shows:
NOTICE: garths is slim

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2025-03-02 16:09:47 Re: BUG #18829: RAISE NOTICE appends 's' to string in PostgreSQL 17.2
Previous Message Tom Lane 2025-03-01 20:47:12 Re: BUG #18828: Crash when pg_get_logical_snapshot_meta() passed empty string