Skip site navigation (1) Skip section navigation (2)

Re: BUG #4638: Bug with Geometry in Array

From: "Dr(dot) Björn Weitzig" <weitzig(at)supportgis(dot)de>
To: PostgreSQL Bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #4638: Bug with Geometry in Array
Date: 2009-03-02 12:33:50
Message-ID: 49ABD22E.6050206@supportgis.de (view raw or flat)
Thread:
Lists: pgsql-bugs
Thank you for your fast reply.

I can't find any "modified JDBC driver", only the "JDBC extension"
postgis.jar (your link), which I use und which doesn't help. postgis.jar
seems to be an add-on to the default JDBC driver, not an replacement.
I use postgis_1.3.5.jar with postgresql-8.3-603.jdbc3.jar

It would be great if you can show me where to get the "modified JDBC
driver".
As PostGIS is a common extension to PostgreSQL, wouldn't it be good to
handle this case in the default JDBC driver?

Thank you,
Bjoern Weitzig

On 2009-02-03 17:43, Tom Lane wrote:
> "Bjoern Weitzig" writes:
> > I use arrays like "select array(select n from a)". This works well
except of
> > the case with geometry as datatype.
>
> The geometry type intentionally uses ':' as the array delimiter. It
> seems like a good bet that the JDBC driver you're using doesn't expect
> anything but ',' as array delimiter. I checked with the postgis-devel
> list and they recommend using the modified JDBC driver that's
> distributed with postgis.
>
http://postgis.refractions.net/documentation/manual-1.3.6SVN/ch04.html#id2726248
>
> regards, tom lane
>
>

Responses

pgsql-bugs by date

Next:From: Jonas R. PachecoDate: 2009-03-02 13:14:43
Subject: BUG #4686: There is not enough memory to complete this operation
Previous:From: Heikki LinnakangasDate: 2009-03-02 08:26:02
Subject: Re: BUG #4684: lastval in function

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group