Re: Extended Query, flush or sync ? - Mailing list pgsql-general

From John DeSoi
Subject Re: Extended Query, flush or sync ?
Date
Msg-id FDA5304B-13B7-4A68-B04A-97049F6D99F5@pgedit.com
Whole thread Raw
In response to Extended Query, flush or sync ?  (Raimon Fernandez <coder@montx.com>)
List pgsql-general
On Dec 18, 2009, at 4:44 PM, Raimon Fernandez wrote:

> It's not clear for me if I have to issue a flush or sync after each process of an extended query.
>
> It's almost working for me only when I send a sync, but not when I send a flush. With the flush, the connection seems
freezed,or at least, I don't get any data from postgre. 
>
>
> - Send the parse command
> - sync
> - Receive the ParseComplete
> -sync
> - Send the Bind
> - sync
> - Receive the BincComplete
> - send the Execute
> - receive an error => "portal xxxxxxx does not exist"


I send:

parse
bind
describe
execute
sync

and then loop on the connection stream to receive the responses.



John DeSoi, Ph.D.





pgsql-general by date:

Previous
From: "tamanna madaan"
Date:
Subject: logtrigger/denyaccess triggers removed from master/slave
Next
From: Tom Lane
Date:
Subject: Re: Extended Query, flush or sync ?