Extended Query, flush or sync ?

From: Raimon Fernandez <coder(at)montx(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Extended Query, flush or sync ?
Date: 2009-12-18 21:44:10
Message-ID: AC4D2602-8300-41E5-BF48-67C39CD95BBF@montx.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-interfaces

Hello,

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"

thanks,

regards,

r.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rory Campbell-Lange 2009-12-18 21:48:03 Re: Extracting SQL from logs in a usable format
Previous Message Bruce Momjian 2009-12-18 21:28:58 Re: [GENERAL] Installing PL/pgSQL by default

Browse pgsql-interfaces by date

  From Date Subject
Next Message Tom Lane 2009-12-18 21:55:08 Re: Extended Query, flush or sync ?
Previous Message Raimon Fernandez 2009-12-18 09:16:27 Re: Extended Query using the Frontend/Backend Protocol 3.0