Postgres Pro
Downloads
Home   >   mailing lists

BUG #15558: NOTIFY max channel length is undocumented - Mailing list pgsql-bugs

From PG Bug reporting form
Subject BUG #15558: NOTIFY max channel length is undocumented
Date
Msg-id 15558-996f38aafa654215@postgresql.org
Whole thread Raw
Responses Re: BUG #15558: NOTIFY max channel length is undocumented  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-bugs
Tree view 
The following bug has been logged on the website:

Bug reference:      15558
Logged by:          Andy Edwards
Email address:      jedwards@fastmail.com
PostgreSQL version: 11.1
Operating system:   (irrelevant)
Description:

After debugging why notifications weren't getting delivered, I discovered
the following:

# LISTEN "pg/tables/TagNotificationTriggers/tag/_org/1/JSON
Test/battery/1/lifetimeWh";
NOTICE:  identifier "pg/tables/TagNotificationTriggers/tag/_org/1/JSON
Test/battery/1/lifetimeWh" will be truncated to
"pg/tables/TagNotificationTriggers/tag/_org/1/JSON Test/battery/"

I haven't seen a mention of this channel length limit in any version of the
documentation for NOTIFY.  I wish it were in the documentation, because then
I would have found out about this limit before deciding to use Postgres
notifications, and chosen to use Redis notifications from the beginning.

pgsql-bugs by date:

Previous
From: Luis Carril
Date:
Subject: Re: BUG #15552: Unexpected error in COPY to a foreign table in atransaction
Next
From: Amit Langote
Date:
Subject: Re: BUG #15552: Unexpected error in COPY to a foreign table in atransaction