Re: BUG #18829: RAISE NOTICE appends 's' to string in PostgreSQL 17.2 - Mailing list pgsql-bugs

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