[GENERAL] RE: [GENERAL] Re: [GENERAL] A simple extension immitating pg_notify‏

2016-07-25 Thread Mehran Ziadloo
Sorry if my terminology is not accurate. But by an instance, I mean a PostgreSQLinstallation. And I call it an instance (and not a database) not to confuse itwith the concept of databases (as in databases / schemas). Even when I'm tryingto clarify the terminology, it's hard due to lack of distin

[GENERAL] Re: [GENERAL] A simple extension immitating pg_notify‏

2016-07-25 Thread Mehran Ziadloo
> I understand that:> 1) you like to use postgres as a "bus" to transfer > messages between connected> clients;> 2) only one database server is > concerned (no redundancy at all);> 3) it is the client code (perl, php ...) > that send the notification (ie,> notifications are not sent by triggers

[GENERAL] Re: [GENERAL] A simple extension immitating pg_notify‏

2016-07-25 Thread Mehran Ziadloo
> I understand that:> 1) you like to use postgres as a "bus" to transfer > messages between connected> clients;> 2) only one database server is > concerned (no redundancy at all);> 3) it is the client code (perl, php ...) > that send the notification (ie,> notifications are not sent by triggers

Re: [GENERAL] A simple extension immitating pg_notify

2016-07-24 Thread Mehran Ziadloo
makes sense now. > Subject: Re: [GENERAL] A simple extension immitating pg_notify > To: pgsql-general@postgresql.org > From: pie...@hogranch.com > Date: Sun, 24 Jul 2016 00:21:35 -0700 > > On 7/23/2016 8:24 PM, Mehran Ziadloo wrote: > > I'm looking for a way to s

[GENERAL] A simple extension immitating pg_notify

2016-07-23 Thread Mehran Ziadloo
Hello everyone, I'm looking for a way to send notifications from within one database toanother. As if pg_notify accepted a database name, or even to all of thedatabases. So far I could not find a way to do so. Then someone told me that Ineed to implement this feature myself and add it Postgre