From: | "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
---|---|
To: | "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at>, "Mikko Tiihonen *EXTERN*" <mikko(dot)tiihonen(at)nitorcreations(dot)com> |
Cc: | "Jesper Pedersen *EXTERN*" <jesper(dot)pedersen(at)jboss(dot)org>, <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: [Patch] Binary Transfer v12 |
Date: | 2009-06-09 16:30:58 |
Message-ID: | D960CB61B694CF459DCFB4B0128514C202FF6641@exadv11.host.magwien.gv.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
I wrote:
> >> Did you test it with both little-endian and big-endian servers?
> >> With 32-bit and 64-bit servers?
> >
> > I have only tested with 64bit amd64 servers.
> >
> [...]
> >
> > But now you got me wondering...
> >
> > The protocol messages itself are well defined, but I cannot find any
> > documentation about the data value contents because there is no official
> > documentation. I had to just guess how the values are stored. Based on the data
> > type byte sizes in database, for example look here:
> >
> http://developer.postgresql.org/pgdocs/postgres/datatype-datetime.html
>
> Unfortunately I don't know the implementation details.
> Maybe binary values come as they are on disk, see the note in the COPY
> documentation:
> http://developer.postgresql.org/pgdocs/postgres/sql-copy.html
>
> I have a (big-endian) AIX machine where I could test it as soon as the
> patch is in. Is there a convenient test program?
I tried to select int2, int4, int8 and float8 on both 32-bit Linux and
64-bit AIX, and the binary representations for all the values were
identical. Looks good, but it is only a small test sample.
Yours,
Laurenz Albe
From | Date | Subject | |
---|---|---|---|
Next Message | devAng@libero.it | 2009-06-10 08:02:12 | Applet & SSL |
Previous Message | Gaël BOUGANNE | 2009-06-09 11:53:32 | Getting views' metadata |