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

From Tom Lane
Subject Re: Extended Query, flush or sync ?
Date
Msg-id 20068.1261502155@sss.pgh.pa.us
Whole thread Raw
In response to Re: Extended Query, flush or sync ?  (Raimon Fernandez <coder@montx.com>)
Responses Re: Extended Query, flush or sync ?  (Raimon Fernandez <coder@montx.com>)
Re: Extended Query, flush or sync ?  (Raimon Fernandez <coder@montx.com>)
List pgsql-general
Raimon Fernandez <coder@montx.com> writes:
> But the portal isn't destroyed after a sync ?

Not directly by a Sync, no.

> I'm getting a "Portal 'myPortal' doesn't exist  "when sending the next Execute ...

End of transaction would destroy portals --- are you holding a
transaction open for this?  It's basically just like a cursor.

            regards, tom lane

pgsql-general by date:

Previous
From: Nathaniel Trellice
Date:
Subject: Re: libpq: do I need PQendcopy after PQgetCopyData?
Next
From: "Jacob Shucart"
Date:
Subject: Error starting backup