To: "Rodrigo Moreno" <rodrigo.miguel@terra.com.br>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: How to use PQconsumeInput and PQisBusy correctly ? 
In-reply-to: <20050313155643.687B23C00B@talara.terra.com.br> 
References: <20050313155643.687B23C00B@talara.terra.com.br>
Comments: In-reply-to "Rodrigo Moreno" <rodrigo.miguel@terra.com.br>
	message dated "Sun, 13 Mar 2005 12:56:32 -0300"
Date: Sun, 13 Mar 2005 13:54:14 -0500
Message-ID: <18233.1110740054@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>

"Rodrigo Moreno" <rodrigo.miguel@terra.com.br> writes:
> What's the right way to use pqconsumeinput and pqisbusy ?
> The below code could be used to do that ? 

It would work but it seems rather pointless; the only reason you would
use those functions is if you have something else useful to do while
waiting for the query result ... and this program structure isn't
very conducive to doing other stuff while waiting.  Usually you'd want
to have a main loop that can dispatch handling of various events, one
of them being checking for an available query result.

The whole thing is a bit of a stone-age technique anyway; if you were
thinking of starting a new program today you'd probably use threads in
preference to an event loop.

			regards, tom lane