Re: Execute and PortalSuspended needs explicit transaction - Mailing list pgsql-hackers

From Francisco Figueiredo Jr.
Subject Re: Execute and PortalSuspended needs explicit transaction
Date
Msg-id 20050301185607.73137.qmail@web60706.mail.yahoo.com
Whole thread Raw
In response to Re: Execute and PortalSuspended needs explicit transaction  (Oliver Jowett <oliver@opencloud.com>)
List pgsql-hackers
 --- Oliver Jowett <oliver@opencloud.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


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Where to see the patch queue (was Re: [PATCHES] Patch for Postmaster
Next
From: Tom Lane
Date:
Subject: Re: bitmap AM design