PG Bug reporting form <noreply(at)postgresql(dot)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