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

Re: Extended Query Protocol Question

From: Greg <grigorey(at)yahoo(dot)co(dot)uk>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Extended Query Protocol Question
Date: 2010-07-13 15:06:25
Message-ID: 114296.84665.qm@web24304.mail.ird.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-novice
Thanks for quick response. 
 
Well, portal name is the same for both bind and execute messages as for 2nd point: I tried composing Parse, Bind and Execute in the same buffer (with Sync message ending each) and then send data to the database as well as sending those messages one by one and reading their response and still getting "portal does not exists" error when Execute message sent to the database. Is there are way to check weather the portal been created for parsed query using pgAdmin III (idea is to send Parse & Bind messages and then freeze the application to see weather portal exists)?
 
Thanks.


--- On Tue, 13/7/10, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:


From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: [NOVICE] Extended Query Protocol Question
To: "Greg" <grigorey(at)yahoo(dot)co(dot)uk>
Cc: pgsql-novice(at)postgresql(dot)org
Date: Tuesday, 13 July, 2010, 15:55


Greg <grigorey(at)yahoo(dot)co(dot)uk> writes:
> Hi all. I cant get my head around Extended Query message flow in Frontend/Backend protocol v3. 
>> From documentation I understand that I have to sent Parse, Bind and Execute messages and expect responses: ParseComplete & ReadyForQuery for Prase, BindComplete & ReadyForQuery for Bind and as for Execute reponse I should get DataRow(s). 
> so far I'm getting proper reponses for Prase & Bind but when I send Execute message I get an error "ERROR C34000M portal "MyPortal" does not exist F.\src\backend\tcop\postgres.c L1810Rexec_execute_message'.

> Why this message is been displayed after I get ParseComplete & BindComplete messages?

The two most likely explanations I can think of are
(1) you didn't give the same portal name in Bind as in Execute; or
(2) you did something between those two commands that ended the
transaction and thus caused the portal to be closed.

            regards, tom lane



      

In response to

Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2010-07-13 15:18:15
Subject: Re: Extended Query Protocol Question
Previous:From: Tom LaneDate: 2010-07-13 14:55:35
Subject: Re: Extended Query Protocol Question

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