Skip site navigation (1) Skip section navigation (2)

Re: Execute and PortalSuspended needs explicit transaction

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: "Francisco Figueiredo Jr(dot)" <fxjrlists(at)yahoo(dot)com(dot)br>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Execute and PortalSuspended needs explicit transaction
Date: 2005-03-01 02:12:21
Message-ID: 4223CF85.6040806@opencloud.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Francisco Figueiredo Jr. wrote:

> After some testing, I could send an Execute message with 2 as the manx
> number of rows. After the second execute I get the following:
> 
> portal "" does not exist
> Severity: ERROR
> Code: 34000
> 
> I noticed that I could only get it working if I explicitly create a
> transaction.
> 
> I thought it could be some Sync() messages I was sending after the first
> execute, but when I removed them, I still get the problems.

If you're sending any Sync messages at all between the two Executes, it 
will indeed cause problems as Sync causes any implicitly-opened 
transaction to be closed, which will in turn invalidate any non-holdable 
portals.

Do you have a trace of all the messages sent?

-O

In response to

Responses

pgsql-hackers by date

Next:From: Greg Sabino MullaneDate: 2005-03-01 02:47:02
Subject: Re: Development Plans
Previous:From: Francisco Figueiredo Jr.Date: 2005-03-01 02:11:05
Subject: Re: [JDBC] Where are we on stored procedures?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group