Thread: V2 protocol -> 8.1 server

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

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
>

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

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