| From: | John DeSoi <desoi(at)pgedit(dot)com> |
|---|---|
| To: | Raimon Fernandez <coder(at)montx(dot)com> |
| Cc: | pgsql-general List <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Extended Query, flush or sync ? |
| Date: | 2009-12-19 03:31:25 |
| Message-ID: | FDA5304B-13B7-4A68-B04A-97049F6D99F5@pgedit.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-interfaces |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavel Stehule | 2009-12-19 04:35:34 | Re: Selecting from table into an array var |
| Previous Message | Postgres User | 2009-12-19 01:14:00 | Selecting from table into an array var |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Raimon Fernandez | 2009-12-19 07:40:12 | Re: Extended Query, flush or sync ? |
| Previous Message | Raimon Fernandez | 2009-12-18 23:40:06 | Re: Extended Query, flush or sync ? |