| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Sabino Mullane | 2005-03-01 02:47:02 | Re: Development Plans |
| Previous Message | Francisco Figueiredo Jr. | 2005-03-01 02:11:05 | Re: [JDBC] Where are we on stored procedures? |