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 > > -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
