Re: Asynchronous interface help? - Mailing list pgsql-interfaces

From Tom Lane
Subject Re: Asynchronous interface help?
Date
Msg-id 14511.978480888@sss.pgh.pa.us
Whole thread Raw
In response to Asynchronous interface help?  (Adam Haberlach <adam@newsnipple.com>)
List pgsql-interfaces
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


pgsql-interfaces by date:

Previous
From: Ingo Luetkebohle
Date:
Subject: Re: DBD::Pg
Next
From: Luc Bouchard
Date:
Subject: Re: DBD::Pg