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

Re: Execute and PortalSuspended needs explicit transaction

From: "Francisco Figueiredo Jr(dot)" <fxjrlists(at)yahoo(dot)com(dot)br>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Execute and PortalSuspended needs explicit transaction
Date: 2005-03-01 18:56:06
Message-ID: (view raw or whole thread)
Lists: pgsql-hackers
 --- Oliver Jowett <oliver(at)opencloud(dot)com> escreveu: 
> 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.


The strange part to me is that even after removing the sync calls, I still got
the problem :(

> Do you have a trace of all the messages sent?

I'm not at my devel box right now, but when I get home I will send you.

Thanks in advance, Oliver.


Francisco Figueiredo Jr.

Yahoo! Acesso Grátis - Instale o discador do Yahoo! agora. - Internet rápida e grátis

In response to

pgsql-hackers by date

Next:From: Tom LaneDate: 2005-03-01 18:59:20
Subject: Re: bitmap AM design
Previous:From: Bruce MomjianDate: 2005-03-01 18:51:05
Subject: Re: Where to see the patch queue (was Re: [PATCHES] Patch for Postmaster

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