From: Tom Lane <tgl@sss.pgh.pa.us>
To: Vivek Khera <vivek@khera.org>
Cc: pgsql-sql@postgresql.org
Subject: Re: Question on triggers and plpgsql
Date: Fri, 08 Apr 2005 14:47:36 -0400
Message-ID: <16028.1112986056@sss.pgh.pa.us> (raw)
In-Reply-To: <986acdb4ff3bdac82c5e09c607bc7839@khera.org>
References: <4255AA15.8000508@mochima.com>
<BE1E8DAA-A829-11D9-9125-000A95B03262@pgedit.com>
<fef7e50cf33b53ca481ecb2554cd6403@mail.nih.gov>
<14244.1112970986@sss.pgh.pa.us>
<20050408145928.GA27718@phlogiston.dyndns.org>
<986acdb4ff3bdac82c5e09c607bc7839@khera.org>
Vivek Khera <vivek@khera.org> writes:
> I have a lot of processing that could benefit from this type of
> synchronization, except the fact that there's no Pg command to "wait
> until I get a notify message".
This is a client library deficiency, not a problem with the backend or
the protocol. In libpq it is actually possible to do it, but you have
to select() or poll() on the socket for yourself, which is a tad ugly.
OTOH, most apps that want to do that also want to wait on other sockets
at the same time, so a cleaner-looking API wouldn't necessarily be any
more useful.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, vivek@khera.org
Subject: Re: Question on triggers and plpgsql
In-Reply-To: <16028.1112986056@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox