Thread: V2 protocol -> 8.1 server

V2 protocol -> 8.1 server

From
Kris Jurka
Date:
The 8.1 server doesn't work when issuing queries using the v2 protocol,
notably the isnull bitmask in the DataRow message is incorrect.  I suspect
the problem is with this commit:

http://archives.postgresql.org/pgsql-committers/2005-03/msg00224.php

I've attached the tcpdump output from establishing a connection with the
JDBC driver using the V2 protocol to a 7.4 and an 8.1 server.  In the 7.4
server after the 'D' message is c0 while 8.1 has 00 as the next byte.

Kris Jurka

Re: V2 protocol -> 8.1 server

From
Kris Jurka
Date:
With the promised files this time.

On Sat, 23 Apr 2005, Kris Jurka wrote:

>
> The 8.1 server doesn't work when issuing queries using the v2 protocol,
> notably the isnull bitmask in the DataRow message is incorrect.  I suspect
> the problem is with this commit:
>
> http://archives.postgresql.org/pgsql-committers/2005-03/msg00224.php
>
> I've attached the tcpdump output from establishing a connection with the
> JDBC driver using the V2 protocol to a 7.4 and an 8.1 server.  In the 7.4
> server after the 'D' message is c0 while 8.1 has 00 as the next byte.
>
> Kris Jurka
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>

Re: V2 protocol -> 8.1 server

From
Tom Lane
Date:
Kris Jurka <books@ejurka.com> writes:
> The 8.1 server doesn't work when issuing queries using the v2 protocol,

Yeah, looks like I broke something :-( ... will fix tomorrow.

            regards, tom lane

Re: V2 protocol -> 8.1 server

From
Tom Lane
Date:
Kris Jurka <books@ejurka.com> writes:
> The 8.1 server doesn't work when issuing queries using the v2 protocol,
> notably the isnull bitmask in the DataRow message is incorrect.  I suspect
> the problem is with this commit:

> http://archives.postgresql.org/pgsql-committers/2005-03/msg00224.php

Yup, I broke it there :-(.  Fixed --- thanks for the report!

            regards, tom lane