From: | Andy Edwards <jedwards(at)fastmail(dot)com> |
---|---|
To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, pgsql-bugs(at)lists(dot)postgresql(dot)org |
Subject: | Re: BUG #15558: NOTIFY max channel length is undocumented |
Date: | 2018-12-19 01:28:32 |
Message-ID: | 1545182912.1800865.1613067232.46581146@webmail.messagingengine.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Oh, that's a good point. Do you think a hyperlink like the following might be an improvement?
channel
Name of the notification channel to be signaled (any <a href="https://www.postgresql.org/docs/11/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS">identifier</a>)
If there had been a hyperlink I believe I might have clicked it and found this out sooner.
On Tue, Dec 18, 2018, at 6:57 PM, David G. Johnston wrote:
> On Tue, Dec 18, 2018 at 5:36 PM PG Bug reporting form
> <noreply(at)postgresql(dot)org> wrote:
> >
> > The following bug has been logged on the website:
> >
> > Bug reference: 15558
> > Logged by: Andy Edwards
> > Email address: jedwards(at)fastmail(dot)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.
>
> Since it is just another name/identifier it is the same limit and
> behavior as is present for table names, column names, type names,
> etc...
>
> The length of identifiers is covered in the general section covering syntax:
>
> https://www.postgresql.org/docs/11/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS
>
> Default length for identifiers is identified as being 63 bytes -
> though technically (but not usefully) is system dependent at compile
> time.
>
> It is intentional to not spam the documentation with such a
> wide-ranging dynamic everywhere it might come into play...I'm
> undecided whether NOTIFY is deserving of an exception...
>
> David J.
From | Date | Subject | |
---|---|---|---|
Next Message | Amit Langote | 2018-12-19 01:30:07 | Re: BUG #15552: Unexpected error in COPY to a foreign table in a transaction |
Previous Message | Amit Langote | 2018-12-19 01:24:12 | Re: BUG #15552: Unexpected error in COPY to a foreign table in a transaction |