[Geoserver-users] Re: [Geoserver-devel] Geoserver 1.3.0 Pre Release

[Richard d. <dg...@no...>]

Hi all,

It seems that postgresql datastore (for postgresql 7.2.2, postgis 1.0) is=
=20
broken with PR1 (may be RC7 too, not in RC6 and before).

I am having the following error :

org.geotools.data.DataSourceException: Error querying relation:serie_roug=
e.=20
Possible cause:ERROR:  parser: parse error at or near "." at=20
org.geotools.data.postgis.PostgisDataStore.buildSchema(PostgisDataStore.j=
ava:591)

Looking at PostgisDataStore.java, the query launched against postgresql i=
s :

st.execute("SELECT * FROM \"" + config.getDatabaseSchemaName() +=20
"\".\""+typeName + "\" LIMIT 0;");

In the case of postgres 7.2, we don't have a dictionnary except through p=
g_*=20
tables.

Am I right or did I missed something ?

didier