On 05/07/12 1:40 PM, Igor wrote:
2012/5/7 John R Pierce <pierce@xxxxxxxxxxxx <mailto:pierce@xxxxxxxxxxxx>>
On 05/07/12 1:13 PM, Igor wrote:
1.Is this possible in future releases ?
2. How I can organize interconnectbetween two clients
connected to different DB? I need call NOTIFY from pgsql
function in one database to another LISTEN client in another
database.
a listener isn't 'in a database', its a client application thats
polling for the notifications from the database its connected to.
I understand this. But I need "link" between two clients, connected to
different databases.
Its real situation. We use sharded cluster based on plproxy. The
calling function for DB queries is equal in all databases (see plproxy
documentation). Now we need to release some internal logic between
clients based on certain events which occurred in this functions. The
LISTEN/NOTIFY mechanism is very good feature, but event occur NOT in
connected DB - i.e. in destination DB via plproxy wrapper. I.e. wee
need subject.
then maybe you could have a process to do this work which connects to
all the databases and issues the LISTENs and initiates whatever actions
you need in the other database(s) ?
--
john r pierce N 37, W 122
santa cruz ca mid-left coast
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
