Hello,
I have some data stored in a PostgreSQL schema called "client". As part of creating the new feature type based on the "community" table, I use the "Generate" button to populate the Lat/Long bounding box but am getting the following error....
The following exception was thrown:
* class org.geotools.data.DataSourceException: Could not count Request All Features
* class org.postgresql.util.PSQLException: ERROR: relation "community" does not exist
This occurs with any table in this schema. If I include the same "community" table in the public schema and then trying to building the feature type (using the table from the "client" schema) it works.
For some reason it is not picking up the schema. Does anyone have any suggestions or do I have a setting wrong?
thanks,
Dustin
Hi Dustin,
It could just be a bug... but did you explicitly specify the "client" schema when you created the datastore?
Also it would be helpful to know which version of GeoServer and postgres you are using. Thanks.
-Justin
Dustin Sampson wrote:
Hello,
I have some data stored in a PostgreSQL schema called "client". As part of creating the new feature type based on the "community" table, I use the "Generate" button to populate the Lat/Long bounding box but am getting the following error....
The following exception was thrown:
* class org.geotools.data.DataSourceException: Could not count Request All Features
* class org.postgresql.util.PSQLException: ERROR: relation "community" does not exist
This occurs with any table in this schema. If I include the same "community" table in the public schema and then trying to building the feature type (using the table from the "client" schema) it works.
For some reason it is not picking up the schema. Does anyone have any suggestions or do I have a setting wrong?
thanks,
Dustin
------------------------------------------------------------------------------
Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM)
software. With Adobe AIR, Ajax developers can use existing skills and code to
build responsive, highly engaging applications that combine the power of local
resources and data with the reach of the web. Download the Adobe AIR SDK and
Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
--
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.
GeoServer: 1.7.1 PostgreSQL: 8.2.11 PostGIS: 1.3.2 Ubuntu: 7.10 Here is my datastore settings and the postgres account has full privileges… 
Justin Deoliveira-6 wrote:
Hi Dustin, It could just be a bug… but did you explicitly specify the “client” schema when you created the datastore? Also it would be helpful to know which version of GeoServer and postgres you are using. Thanks. -Justin Dustin Sampson wrote: > Hello, > > I have some data stored in a PostgreSQL schema called “client”. As > part of creating the new feature type based on the “community” table, I > use the “Generate” button to populate the Lat/Long bounding box but am > getting the following error… > > The following exception was thrown: > > * class org.geotools.data.DataSourceException: Could not count > Request All Features > * class org.postgresql.util.PSQLException: ERROR: relation > “community” does not exist > > This occurs with any table in this schema. If I include the same > “community” table in the public schema and then trying to building the > feature type (using the table from the “client” schema) it works. > > For some reason it is not picking up the schema. Does anyone have any > suggestions or do I have a setting wrong? > > thanks, > Dustin > > ------------------------------------------------------------------------------ > Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR™ > software. With Adobe AIR, Ajax developers can use existing skills and code to > build responsive, highly engaging applications that combine the power of local > resources and data with the reach of the web. Download the Adobe AIR SDK and > Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com > _______________________________________________ > Geoserver-users mailing list > Geoserver-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/geoserver-users – Justin Deoliveira OpenGeo - http://opengeo.org Enterprise support for open source geospatial. ------------------------------------------------------------------------------ Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR™ software. With Adobe AIR, Ajax developers can use existing skills and code to build responsive, highly engaging applications that combine the power of local resources and data with the reach of the web. Download the Adobe AIR SDK and Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com _______________________________________________ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
View this message in context: Re: PostgreSQL Schemas
Sent from the GeoServer - User mailing list archive at Nabble.com.
gridcell ha scritto:
GeoServer: 1.7.1 PostgreSQL: 8.2.11 PostGIS: 1.3.2 Ubuntu: 7.10 Here is my datastore settings and the postgres account has full privileges....
Can you also show us the geometry_columns table contents?
Cheers
Andrea
--
Andrea Aime
OpenGeo - http://opengeo.org
Expert service straight from the developers.
This is the entry in the geometry_columns...
http://www.nabble.com/file/p21833547/Screenshot.png
Andrea Aime-4 wrote:
gridcell ha scritto:
GeoServer: 1.7.1 PostgreSQL: 8.2.11 PostGIS: 1.3.2 Ubuntu: 7.10 Here is
my datastore settings and the postgres account has full privileges....
Can you also show us the geometry_columns table contents?
Cheers
Andrea
--
Andrea Aime
OpenGeo - http://opengeo.org
Expert service straight from the developers.
------------------------------------------------------------------------------
Create and Deploy Rich Internet Apps outside the browser with
Adobe(R)AIR(TM)
software. With Adobe AIR, Ajax developers can use existing skills and code
to
build responsive, highly engaging applications that combine the power of
local
resources and data with the reach of the web. Download the Adobe AIR SDK
and
Ajax docs to start building applications
today-http://p.sf.net/sfu/adobe-com
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
--
View this message in context: http://www.nabble.com/PostgreSQL-Schemas-tp21815463p21833547.html
Sent from the GeoServer - User mailing list archive at Nabble.com.
Hi
I am also experiencing this issue. The schema is on the postgresql
search_path, saved for the user using ALTER USER syntax.
I am away from the server at the moment but from memory:
PostgreSQL 8.1.3
POSTGIS 1.3
Geoserver 1.6
on SLES 10SP2
geometry_columns is located in public schema, with spatial_ref_sys
nine other schemas, all with lower_case_schema_names, tables similarly
named, created by hand (psql) and ogr2ogr
I entered the data in the geometry column by hand, using lower case
access using psql, mapserver and quantum GIS working without difficulty
Vincent Hussey
Andrea Aime-4 wrote:
gridcell ha scritto:
GeoServer: 1.7.1 PostgreSQL: 8.2.11 PostGIS: 1.3.2 Ubuntu: 7.10 Here is
my datastore settings and the postgres account has full privileges....
Can you also show us the geometry_columns table contents?
Cheers
Andrea
--
Andrea Aime
OpenGeo - http://opengeo.org
Expert service straight from the developers.
------------------------------------------------------------------------------
Create and Deploy Rich Internet Apps outside the browser with
Adobe(R)AIR(TM)
software. With Adobe AIR, Ajax developers can use existing skills and code
to
build responsive, highly engaging applications that combine the power of
local
resources and data with the reach of the web. Download the Adobe AIR SDK
and
Ajax docs to start building applications
today-http://p.sf.net/sfu/adobe-com
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
--
View this message in context: http://www.nabble.com/PostgreSQL-Schemas-tp21815463p22931090.html
Sent from the GeoServer - User mailing list archive at Nabble.com.
Hmmm. I just tried replicating a similar setup and could not. By any chance could one of you send us an SQL script that would create a sample database to illustrate the problem. I can load it up here and hopefully can replicate the problem.
-Justin
Vincent Hussey wrote:
Hi I am also experiencing this issue. The schema is on the postgresql
search_path, saved for the user using ALTER USER syntax.
I am away from the server at the moment but from memory:
PostgreSQL 8.1.3
POSTGIS 1.3
Geoserver 1.6
on SLES 10SP2
geometry_columns is located in public schema, with spatial_ref_sys
nine other schemas, all with lower_case_schema_names, tables similarly
named, created by hand (psql) and ogr2ogr
I entered the data in the geometry column by hand, using lower case
access using psql, mapserver and quantum GIS working without difficulty
Vincent Hussey
Andrea Aime-4 wrote:
gridcell ha scritto:
GeoServer: 1.7.1 PostgreSQL: 8.2.11 PostGIS: 1.3.2 Ubuntu: 7.10 Here is my datastore settings and the postgres account has full privileges....
Can you also show us the geometry_columns table contents?
Cheers
Andrea
--
Andrea Aime
OpenGeo - http://opengeo.org
Expert service straight from the developers.
------------------------------------------------------------------------------
Create and Deploy Rich Internet Apps outside the browser with
Adobe(R)AIR(TM)
software. With Adobe AIR, Ajax developers can use existing skills and code
to
build responsive, highly engaging applications that combine the power of
local
resources and data with the reach of the web. Download the Adobe AIR SDK
and
Ajax docs to start building applications
today-http://p.sf.net/sfu/adobe-com
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
--
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.
Resolved. Revisited this by dumping the database and restoring it. I am now seeing the data when a schema other than public is listed in the feature type configuration.
I was trying to access tables across a number of schemas, but thinking about it, geoserver is probably asking for data along the following lines:
select fs_table_name from geometry_columns where fs_schema = [text from schema field]
Which obviously would allow for only one schema per feature type. I suppose a work around would be to put views of all the tables I want to export into one schema, and point at that schema?
Thanks for your help.
Vincent Hussey
2009/4/10 Justin Deoliveira <jdeolive@anonymised.com>
Hmmm. I just tried replicating a similar setup and could not. By any chance could one of you send us an SQL script that would create a sample database to illustrate the problem. I can load it up here and hopefully can replicate the problem.
-Justin
Vincent Hussey wrote:
Hi I am also experiencing this issue. The schema is on the postgresql
search_path, saved for the user using ALTER USER syntax.
I am away from the server at the moment but from memory:
PostgreSQL 8.1.3
POSTGIS 1.3
Geoserver 1.6
on SLES 10SP2
geometry_columns is located in public schema, with spatial_ref_sys
nine other schemas, all with lower_case_schema_names, tables similarly
named, created by hand (psql) and ogr2ogr
I entered the data in the geometry column by hand, using lower case
access using psql, mapserver and quantum GIS working without difficulty
Vincent Hussey
Andrea Aime-4 wrote:
gridcell ha scritto:
GeoServer: 1.7.1 PostgreSQL: 8.2.11 PostGIS: 1.3.2 Ubuntu: 7.10 Here is my datastore settings and the postgres account has full privileges…
Can you also show us the geometry_columns table contents?
Cheers
Andrea
–
Andrea Aime
OpenGeo - http://opengeo.org
Expert service straight from the developers.
Create and Deploy Rich Internet Apps outside the browser with
Adobe(R)AIR™
software. With Adobe AIR, Ajax developers can use existing skills and code
to
build responsive, highly engaging applications that combine the power of
local
resources and data with the reach of the web. Download the Adobe AIR SDK
and
Ajax docs to start building applications
today-http://p.sf.net/sfu/adobe-com
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
–
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.
Vincent Hussey ha scritto:
Resolved. Revisited this by dumping the database and restoring it. I am now seeing the data when a schema other than public is listed in the feature type configuration.
I was trying to access tables across a number of schemas, but thinking about it, geoserver is probably asking for data along the following lines:
select fs_table_name from geometry_columns where fs_schema = [text from schema field]
Which obviously would allow for only one schema per feature type.
Actually, one schema per datastore
I suppose a work around would be to put views of all the tables I want to export into one schema, and point at that schema?
Hum... have you tried not specifying a schema at all in the
postgis driver config? It may not work, but worth a shot.
Cheers
Andrea