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 201002180058.o1I0wDT21985@momjian.us
Whole thread Raw
In response to Re: NOTIFY/LISTEN on read-only slave?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
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.

Thanks, implemented detail removed, restriction retained.

--  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: Alvaro Herrera
Date:
Subject: Re: Need "SQLDA support for ECPG"
Next
From: Michael Clemmons
Date:
Subject: Michael Clemmons wants to stay in touch on LinkedIn