Re: Frontend/Backend protocol 3.0 - Mailing list pgsql-odbc

From Bruce Momjian
Subject Re: Frontend/Backend protocol 3.0
Date
Msg-id 200506032120.j53LKwc29057@candle.pha.pa.us
Whole thread Raw
In response to Frontend/Backend protocol 3.0  (Jonathan Fuerth <fuerth@sqlpower.ca>)
Responses Re: Frontend/Backend protocol 3.0  (Jonathan Fuerth <fuerth@sqlpower.ca>)
Re: Frontend/Backend protocol 3.0  (Jonathan Fuerth <fuerth@sqlpower.ca>)
List pgsql-odbc
Are you aware someone is rewriting ODBC to use libpq for protocol
communications?

---------------------------------------------------------------------------

Jonathan Fuerth wrote:
> Hello people,
>
> I've taken a few days to hack in support for the frontend/backend
> protocol v3.0 (which first appeared in PostgreSQL 7.4).  My main
> motivator was to get at the SQLSTATE codes which backends >= 7.4 return
> with every error message.
>
> What's done now:
>   -read the new message length field from all server responses
>   -Parse new-style error/notice blocks
>   -return correct SQLSTATE from backend to ODBC callers (connection and
> result level)
>   -added #ifdef so the driver compiles against newer iODBC headers
>
> What I intend to finish this week:
>   -upgrade the function call API to new protocol
>
> What needs doing that I can't/won't finish soon:
>   -upgrade Windows configuration GUI to add new "7.4" protocol option
>   -take advantage of the new transaction status byte in 'Z' messages (my
> patch just ignores them)
>   -rework prepared statement stuff to use the new protocol features (I
> haven't looked at this stuff at all, but the old code works on the new
> protocol--it could be faster, that's all)
>
> If there is any interest in this patch, I will post it to the list, or
> email it to individuals.
>
> Regards,
>
> -Jonathan Fuerth
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
>       joining column's datatypes do not match
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-odbc by date:

Previous
From: Jonathan Fuerth
Date:
Subject: Re: Frontend/Backend protocol 3.0
Next
From: Jonathan Fuerth
Date:
Subject: Re: Frontend/Backend protocol 3.0