Re: Size limit for NOTIFY payload - Mailing list pgsql-docs

From sulfinu@gmail.com
Subject Re: Size limit for NOTIFY payload
Date
Msg-id CAGH1kmxTWqzowDiVxEJXcEvisPw8EvuVj1djfCBN2TU1c2in6A@mail.gmail.com
Whole thread Raw
In response to Re: Size limit for NOTIFY payload  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Size limit for NOTIFY payload
List 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

pgsql-docs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Size limit for NOTIFY payload
Next
From: Greg Sabino Mullane
Date:
Subject: Re: Size limit for NOTIFY payload