Re: Getting blocked when receinving response from a Parse

From: "Francisco Figueiredo Jr(dot)" <fxjrlists(at)yahoo(dot)com(dot)br>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Getting blocked when receinving response from a Parse
Date: 2003-06-29 01:54:11
Message-ID: 3EFE46C3.30807@yahoo.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tom Lane wrote:
> "Francisco Figueiredo Jr." <fxjrlists(at)yahoo(dot)com(dot)br> writes:
>
>>I'm implementing the 3.0 protocol version in Npgsql, a .Net Data
>>provider for postgresql.
>
>
>>I stopped in the first message: Parse :(
>>I send the parse message but I don't receive the ParseComplete or the
>>ErrorResponse. My code simply freezes while reading the byte from
>>network stream.
>
>
> You must send either Flush or Sync after the Parse to force the backend
> to emit its response to Parse. The assumption is that in many cases
> you'll be sending Parse as part of a batch of commands, and the backend
> should batch its responses to minimize the number of network packets
> sent. So you have to tell it where the batch boundaries are --- thus,
> Flush or Sync. See the docs concerning the difference between the two.
>

Oohh, thanks, Tom Lane!
I didn't read carefully the final part of extended query where it says
about the Flush message :)

I didn't realize the idea of holding responses to minimize network
traffic. I was thinking in the send reply style :)

--
Regards,

Francisco Figueiredo Jr.

------
"My grandfather once told me that there are two
kinds of people: those
who work and those who take the credit. He told me
to try to be in the
first group; there was less competition there."
- Indira Gandhi

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Francisco Figueiredo Jr. 2003-06-29 01:56:55 Re: Getting blocked when receinving response from a Parse
Previous Message Joe Conway 2003-06-29 01:24:09 Re: CVS tip compile failure (was Re: Missing array support)