Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 6AABB633762
	for <pgsql-general-postgresql.org@mail.postgresql.org>;
	Tue, 22 Dec 2009 13:16:15 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia,
	port 10024) with ESMTP id 43181-08
	for <pgsql-general-postgresql.org@mail.postgresql.org>;
	Tue, 22 Dec 2009 17:16:08 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130])
	by mail.postgresql.org (Postfix) with ESMTP id E837D633650
	for <pgsql-general@postgresql.org>;
	Tue, 22 Dec 2009 13:16:07 -0400 (AST)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id nBMHFtNn020069;
	Tue, 22 Dec 2009 12:15:55 -0500 (EST)
To: Raimon Fernandez <coder@montx.com>
cc: John DeSoi <desoi@pgedit.com>,
	pgsql-general List <pgsql-general@postgresql.org>
Subject: Re: Extended Query, flush or sync ? 
In-reply-to: <8B2FDB4A-81E9-4307-8652-4C56EEAD2B18@montx.com> 
References: <92781008-8A70-42CE-A49B-6EE67103FACB@montx.com>
	<FC6CBC8C-A398-4835-B3A3-C16C6F4F62D9@pgedit.com>
	<E084987E-A212-4B70-8CFF-D83AA00629C5@montx.com>
	<C670629A-1E54-4F80-9497-6CCAC1A8BDC0@montx.com>
	<20091026231516.GN8812@alvh.no-ip.org>
	<4AE62E21.7040600@hogranch.com>
	<66F15D69-75E5-4D8E-84F8-2F21E09BBA98@pgedit.com>
	<9A9F2678-36B9-42A2-91B2-69076065E8EB@montx.com>
	<20091027134158.GB4876@alvh.no-ip.org>
	<4AB34FE9-CC23-48BE-B905-6478304E0E5B@montx.com>
	<20091027140657.GF4876@alvh.no-ip.org>
	<B7382F17-63B5-49D0-8E39-0F46F9243C95@montx.com>
	<B1EA5872-6E57-46A8-BF35-3192707A5C0F@montx.com>
	<A8F7FAA5-A817-4CCE-BA06-BF28B5534AC7@montx.com>
	<4B057205.6000203@gmail.com>
	<A86C9188-4DAC-4EC4-86BD-0B483287BC71@montx.com>
	<322BBEA5-A328-4197-971E-95359D8FD7F3@montx.com>
	<4B05A8D4.7020500@gmail.com>
	<6A231EA8-5255-47F3-BECB-9BFBD700044C@montx.com>
	<20879F35-6940-4272-988E-703E610C6212@montx.com>
	<57FE8BF9-5E03-4F5A-9BBA-A06118CC2E3B@pgedit.com>
	<0AADF4A5-E795-4F2D-AA2B-A4E1A4B!
	D 9D93@montx.com> <AC4D2602-8300-41E5-BF48-6{ h@ T
	<8B2FDB4A-81E9-4307-8652-4C56EEAD2B18@montx.com>
Comments: In-reply-to Raimon Fernandez <coder@montx.com>
	message dated "Tue, 22 Dec 2009 17:09:52 +0100"
Date: Tue, 22 Dec 2009 12:15:55 -0500
Message-ID: <20068.1261502155@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5
	tests=BAYES_00=-2.599
X-Spam-Level: 
X-Archive-Number: 200912/917
X-Sequence-Number: 157137

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