Geoserver 2.5.1
trying to connect to
Postgresql-9.2-postgis-2.1

Defined two data sources postgis type.

One, with the scheme left in blank, and another with one of the many
schemes of the database selected.

So I "Can't retrieve data from table in a scheme if data source is the
database whitout an specified scheme, but can if the datasource specify the
scheme".

It seems like is correct this behaviour, but you can't take in advance what
are the DB Administrator using the schemes for.

What's the deal?

I have a user with only lecture privileges on all the tables of the
database for Geoserver to connect to.

By now, i have to create a data source for each scheme in order to be able
to work. But:

  It would be nice to have only one data source for the database and be
able to retrieve data from any table from any scheme postgres allows.

That's my pony wish.

I'm writing this because:

 1. Maybe, it is already posible to set a configuration as described.
 2. And, if not, you can take it as a suggestion.
------------------------------------------------------------------------------
HPCC Systems Open Source Big Data Platform from LexisNexis Risk Solutions
Find What Matters Most in Your Big Data with HPCC Systems
Open Source. Fast. Scalable. Simple. Ideal for Dirty Data.
Leverages Graph Analysis for Fast Processing & Easy Data Exploration
http://p.sf.net/sfu/hpccsystems
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Reply via email to