Size limit for NOTIFY payload

From: sulfinu(at)gmail(dot)com
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: Size limit for NOTIFY payload
Date: 2024-12-16 08:01:14
Message-ID: CAGH1kmzPqPo0BS0jpqAoem4yU9GLk2YXXkk0jRA-ej8Uwb+_PA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

Hello,

according to the documentation
<https://www.postgresql.org/docs/current/sql-notify.html>, the payload
given in a NOTIFY statement must not exceed a certain limit *in bytes*. But
the payload is a character string, therefore the limit remains unclear.

What's the character encoding of the NOTIFY payload, is it the default
database encoding?

Thanks.

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Tomas Vondra 2024-12-16 18:24:42 Re: Parallel index build for BRIN
Previous Message Peter Smith 2024-12-16 06:09:58 Re: Logical replication - initial data synchronization