From: Tom Lane <tgl@sss.pgh.pa.us>
To: armandnortjee@gmail.com
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #18829: RAISE NOTICE appends 's' to string in PostgreSQL 17.2
Date: Sun, 02 Mar 2025 11:09:47 -0500
Message-ID: <3189041.1740931787@sss.pgh.pa.us> (raw)
In-Reply-To: <18829-2ed4d964795b3b57@postgresql.org>
References: <18829-2ed4d964795b3b57@postgresql.org>
PG Bug reporting form <noreply@postgresql.org> writes:
> 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.
The substitution marker in plpgsql RAISE strings is just "%", not
"%s" as it is in C, so this output is expected. That wasn't the best
design perhaps, but it's impossible to change it now.
> This issue does not occur when running the same code in earlier PostgreSQL
> versions (e.g., PostgreSQL 16).
You are quite mistaken about that. It's been like this since the
beginning of plpgsql.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: tgl@sss.pgh.pa.us, armandnortjee@gmail.com, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #18829: RAISE NOTICE appends 's' to string in PostgreSQL 17.2
In-Reply-To: <3189041.1740931787@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox