Help with asynchronous queries

From: Nicolao Renè <rene(dot)nicolao(at)ikon-corp(dot)it>
To: pgsql-general(at)postgresql(dot)org
Subject: Help with asynchronous queries
Date: 2005-10-12 19:27:50
Message-ID: 434D63B6.9070902@ikon-corp.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi, I need to execute some queries that do not return any value
for example "DELETE * FROM foo". This queries take a lot of time and I
can't put them together in a single query.
If I use the non-blocking function PQsendQuery() I have to wait until
the execution of the first query terminates before executing another
query right?
In my case (without a result for the query) is it right to check only if
PQisBusy returns 0 inside a loop before executing the next query?
Or do I have to check the connection socket with a select and then do a
PGconsumeInput when data is avaible and at the end check PQisBusy?

Browse pgsql-general by date

  From Date Subject
Next Message peter pilsl 2005-10-12 20:24:48 Re: count( only if true)
Previous Message A. Kretschmer 2005-10-12 19:20:24 Re: count( only if true)