[Geoserver-users] Can't retrieve data from table in a scheme if data source is the database whitout, but can if the datasource specify the scheme

GeoServer GeoServer User
1

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.