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
In-reply-to: <18829-2ed4d964795b3b57@postgresql.org>
References: <18829-2ed4d964795b3b57@postgresql.org>
Comments: In-reply-to PG Bug reporting form <noreply@postgresql.org>
	message dated "Sun, 02 Mar 2025 14:18:55 +0000"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <3189040.1740931787.1@sss.pgh.pa.us>
Date: Sun, 02 Mar 2025 11:09:47 -0500
Message-ID: <3189041.1740931787@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/3189041.1740931787%40sss.pgh.pa.us>
Precedence: bulk

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