Re: A simple extension immitating pg_notify

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Melvin Davidson <melvin6925(at)gmail(dot)com>
Cc: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, Mehran Ziadloo <mehran20(at)hotmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: A simple extension immitating pg_notify
Date: 2016-07-24 15:16:12
Message-ID: 4700.1469373372@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Melvin Davidson <melvin6925(at)gmail(dot)com> 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 commits.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter Devoy 2016-07-24 23:45:47 Return results of join with polymorphically-defined table in pl/pgsql
Previous Message Tom Lane 2016-07-24 15:13:38 Re: A simple extension immitating pg_notify