John DeSoi wrote:
On Sep 22, 2005, at 10:11 AM, Андрей wrote:
I'm sending such messages to server in native postgresql
protocol: 'Parse' -> 'Describe' -> 'Sync' (get: 'Parse Complete' and
'Ready For Query' messages back).
But when the sequence became: 'Parse' -> 'Sync' (get: 'Parse
Complete' and 'Ready For Query' messages back), little pause,
'Describe' -> 'Sync' - server is crashing (error = memory can't be
'read')!
My query is as simple as possible 'select * from table_name'.
What am I doing wrong?
I think I recall having some problems around this also. But I don't
think there is any reason to need Parse -> Sync anyway. If you just
want to prepare, use Parse -> Describe -> Sync. For executing, Parse
(if not already parsed) -> Bind -> Describe -> Execute -> Sync.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
The reason is to get parameters description (if there are any in
query) before binding them to the backend. For example 'select * from
table_name where column_name = $1'. I would like to get required type of
parameter $1 to bind later. But I can't be sure at prepare time, that
I'll need such description in future.
Thanks for your answer,
Andrei
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
