Re: Execute and PortalSuspended needs explicit transaction

Поиск
Список
Период
Сортировка
От Francisco Figueiredo Jr.
Тема Re: Execute and PortalSuspended needs explicit transaction
Дата
Msg-id 20050301185607.73137.qmail@web60706.mail.yahoo.com
обсуждение исходный текст
Ответ на Re: Execute and PortalSuspended needs explicit transaction  (Oliver Jowett <oliver@opencloud.com>)
Список 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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Where to see the patch queue (was Re: [PATCHES] Patch for Postmaster
Следующее
От: Tom Lane
Дата:
Сообщение: Re: bitmap AM design