Melvin Davidson writes:
> I am not so sure another extension is needed. Would it not make more sense
> just to use the dblink extension?
That would be a quick-n-dirty fix, but it would give up all the guarantees
NOTIFY provides about messages being sent if and only if the sending
transaction comm
Mehran Ziadloo writes:
> What I meant was that the notifications are received by the client
> connectionsas if it was generated within their corresponding database (let's
> name thedatabase with a client connection listening to it; DB_C), then a
> notification generated by a NOTIFY command with
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 for example)
M
On Sun, Jul 24, 2016 at 9:35 AM, Adrian Klaver
wrote:
> On 07/24/2016 03:31 AM, Mehran Ziadloo wrote:
>
>> I'm sorry, you are right. Let me rephrase that.
>>
>> What I meant was that the notifications are received by the client
>> connections
>> as if it was generated within their corresponding d
On 07/24/2016 03:31 AM, Mehran Ziadloo wrote:
I'm sorry, you are right. Let me rephrase that.
What I meant was that the notifications are received by the client
connections
as if it was generated within their corresponding database (let's name the
database with a client connection listening to i
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
On 7/23/2016 8:24 PM, Mehran Ziadloo wrote:
I'm looking for a way to send notifications from within one database to
another. As if pg_notify accepted a database name, or even to all of the
databases. So far I could not find a way to do so. Then someone told
me that I
need to implement this featu
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