Re: Abandoning PGobject - Mailing list pgsql-jdbc

From Markus Schaber
Subject Re: Abandoning PGobject
Date
Msg-id 422392BC.9030205@logi-track.com
Whole thread Raw
In response to Re: Abandoning PGobject  (Oliver Jowett <oliver@opencloud.com>)
List pgsql-jdbc
Hi, Oliver,

Oliver Jowett schrieb:

>> - How do we handle endianness? PostGIS canonical binary representation
>> includes endian information, but what about the other types?
>
> I have not looked at your code,

Well, currently, it is rather a skeleton than a code, and endianness
just does not exist :-)

> but the simplest approach seems to be to
> only support binary transfer on V3 connections. The standard V3 types
> have binary representations that use fixed endianness irregardless of
> the endianness of the server.

That sounds good. So type implementors will have four possibilities:

- use fixed endianness for canonical binary representation (as the
built-in types do, preferred solution)
- include an endianness flag in the data (as PostGIS does, following the
OpenGIS wkb spec)
- probe the endianness on connection initialization (forConnection() method)
- fall back to text only representation.


Markus
--
markus schaber | dipl. informatiker
logi-track ag | rennweg 14-16 | ch 8001 zürich
phone +41-43-888 62 52 | fax +41-43-888 62 53
mailto:schabios@logi-track.com | www.logi-track.com

pgsql-jdbc by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: Abandoning PGobject
Next
From: "Francisco Figueiredo Jr."
Date:
Subject: Re: [HACKERS] Where are we on stored procedures?