Search Postgresql Archives

Re: Parse message is not generating a ParseOk response

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



=?ISO-8859-1?Q?Maur=EDcio_Linhares?= <mauricio.linhares@xxxxxxxxx> writes:
> I'm writing an async driver for PosgreSQL in Scala (
> https://github.com/mauricio/postgresql-netty ) and I'm now working on
> getting the prepared statements to work. Following the protocol
> documentation for extended queries (
> http://www.postgresql.org/docs/9.1/static/protocol-flow.html#PROTOCOL-FLOW-EXT-QUERY
> ) it says I should first send a Parse message and wait for a
> ParseComplete message back, but this isn't working for me.

> I send the Parse message and nothing is sent back to me nor the server
> says anything.

You need to add a Sync message if you're going to wait for the Parse to
come back (think of it as being like fflush).  Usually, though, people
don't wait for mere ParseComplete, but send additional messages before
waiting; perhaps do a Describe, or proceed directly with execution.
The idea is that if a step fails, the server will send an error and then
skip any subsequent messages till Sync, so you can optimistically assume
the Parse succeeds and do whatever you'd have done next, thus saving
network round-trips.

			regards, tom lane

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux