Re: Size limit for NOTIFY payload

sulfinu@gmail.com

From: sulfinu@gmail.com
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-docs@lists.postgresql.org
Date: 2024-12-19T09:00:18Z
Lists: pgsql-docs
Well, as I said, that's a *text* value with a *byte* limit. The
documentation should definitely mention something like *"with the default
database encoding"*.

În mie., 18 dec. 2024 la 18:29, Tom Lane <tgl@sss.pgh.pa.us> a scris:

> sulfinu@gmail.com writes:
> > What's the character encoding of the NOTIFY payload, is it the default
> > database encoding?
>
> It's whatever encoding your database uses; NOTIFY doesn't do any
> transcoding.
>
> (We'd have to think harder about that if NOTIFY messages could cross
> database boundaries ... but they don't today.)
>
>                         regards, tom lane
>