Re: NOTIFY/LISTEN on read-only slave? - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: NOTIFY/LISTEN on read-only slave?
Date
Msg-id 201002180306.o1I36kd24077@momjian.us
Whole thread Raw
In response to Re: NOTIFY/LISTEN on read-only slave?  (Greg Smith <greg@2ndquadrant.com>)
Responses Re: NOTIFY/LISTEN on read-only slave?
List pgsql-hackers
Greg Smith wrote:
> Tom Lane wrote:
> > Bruce Momjian <bruce@momjian.us> writes:
> >   
> >> Our documentation says listen/notify will return an error if executed on
> >> the hot standby server:
> >>     
> >>     o LISTEN, UNLISTEN, NOTIFY since they currently write to system tables 
> >>     
> >> With the listen/notify system now implemented in memory, is this still
> >> true?
> >>     
> >
> > The explanation is wrong, but it's still disallowed.
> >   
> 
> What's the actual reason for the restriction then?  I did a whole 
> proofreading round on the HS documentation the other day and am working 
> on a patch to clean up everything I found, can add better notes about 
> this to it.

Oops, I did cleanup on the HS docs all day today in response to a doc
patch that was posted in December.  How extensive are your changes?

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +


pgsql-hackers by date:

Previous
From: Greg Smith
Date:
Subject: Re: NOTIFY/LISTEN on read-only slave?
Next
From: Greg Smith
Date:
Subject: Re: NOTIFY/LISTEN on read-only slave?