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: 20050301185607.73137.qmail@web60706.mail.yahoo.com (view raw or flat)
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.
> 

Ok.

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.

Regards,

Francisco Figueiredo Jr.


	
	
		
_______________________________________________________ 
Yahoo! Acesso Grátis - Instale o discador do Yahoo! agora. http://br.acesso.yahoo.com/ - 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-2014 The PostgreSQL Global Development Group