Re: BUG #4638: Bug with Geometry in Array

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
>
>