Warning about LISTEN names

From: "Greg Sabino Mullane" <greg(at)turnstep(dot)com>
To: pgsql-patches(at)postgresql(dot)org
Subject: Warning about LISTEN names
Date: 2007-02-20 18:28:43
Message-ID: 03b4733e495bdc29e3ec8576d928ee17@biglumber.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches


I'll save the full rant for my blog :), but wanted to submit this documentation
patch for this listen gotcha that's been bugging me for a while. I'd like
to see LISTEN and NOTIFY changed to use a simple text string, but until then,
I think we should probably warn about the chopping off of the left-hand part.

Index: listen.sgml
===================================================================
RCS file: /projects/cvsroot/pgsql/doc/src/sgml/ref/listen.sgml,v
retrieving revision 1.22
diff -c -r1.22 listen.sgml
*** listen.sgml 16 Sep 2006 00:30:19 -0000 1.22
--- listen.sgml 20 Feb 2007 18:18:15 -0000
***************
*** 33,38 ****
--- 33,44 ----
class="PARAMETER">name</replaceable>.
If the current session is already registered as a listener for
this notification condition, nothing is done.
+ Note that because <replaceable class="PARAMETER">name</replaceable>
+ is a relation name, all but the last section will be dropped if the
+ name has any dots in it: LISTEN employee, LISTEN newyork.employee,
+ and LISTEN unitedstates.newyork.employee all register the name
+ employee. Users needing to separate words should use an underscore
+ instead of a dot.
</para>

<para>

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2007-02-20 18:35:10 Re: Warning about LISTEN names
Previous Message Andrew Dunstan 2007-02-20 17:49:26 Re: correct format for date, time, timestamp for XML functionality