Re: [Patch] Binary Transfer v12
От | Albe Laurenz |
---|---|
Тема | Re: [Patch] Binary Transfer v12 |
Дата | |
Msg-id | D960CB61B694CF459DCFB4B0128514C202FF6641@exadv11.host.magwien.gv.at обсуждение исходный текст |
Ответ на | Re: [Patch] Binary Transfer v12 ("Albe Laurenz" <laurenz.albe@wien.gv.at>) |
Список | 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
В списке pgsql-jdbc по дате отправления: