Re: Extended Query, flush or sync ?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Raimon Fernandez <coder(at)montx(dot)com>
Cc: John DeSoi <desoi(at)pgedit(dot)com>, pgsql-general List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Extended Query, flush or sync ?
Date: 2009-12-22 17:15:55
Message-ID: 20068.1261502155@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-interfaces

Raimon Fernandez <coder(at)montx(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2009-12-22 17:19:39 Re: libpq: do I need PQendcopy after PQgetCopyData?
Previous Message Nathaniel Trellice 2009-12-22 17:09:55 libpq: do I need PQendcopy after PQgetCopyData?

Browse pgsql-interfaces by date

  From Date Subject
Next Message Raimon Fernandez 2009-12-22 18:56:04 Re: Extended Query, flush or sync ?
Previous Message Raimon Fernandez 2009-12-22 16:09:52 Re: Extended Query, flush or sync ?