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

On 2025-03-02 Su 9:18 AM, PG Bug reporting form wrote:
> 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
>

This is not a bug, it's working as documented.

The 's' is there because you told it to be there. The docs say: "Inside
the format string, |%| is replaced by the string representation of the
next optional argument's value."

This is not a printf style format string, as you appear to think it is.

cheers

andrew

--
Andrew Dunstan
EDB:https://www.enterprisedb.com