From: Tom Lane <tgl@sss.pgh.pa.us>
To: Adam Haberlach <adam@newsnipple.com>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: Asynchronous interface help?
Date: Tue, 02 Jan 2001 19:14:48 -0500
Message-ID: <14511.978480888@sss.pgh.pa.us> (raw)
In-Reply-To: <20010102134030.A25130@newsnipple.com>
References: <20010102134030.A25130@newsnipple.com>
Adam Haberlach <adam@newsnipple.com> writes:
> This always seems to time out. Is there some mode that I need to put
> the backend into in order to make the socket valid?
It seems like there should be a loop around the
select/consumeinput/notifies sequence, but perhaps that's provided
outside the pqwait() function? As it stands, you're assuming that
the first data delivered will be the notify you want.
Another possible problem is if you are expecting this to fire within
a transaction block. Notifications are only delivered outside of
transactions.
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-interfaces@postgresql.org
Cc: tgl@sss.pgh.pa.us, adam@newsnipple.com
Subject: Re: Asynchronous interface help?
In-Reply-To: <14511.978480888@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