Re: [Geotools-gt2-users] Permission Denied Error on a PostGIS Query

[Ben Caradoc-D. <Ben...@cs...>]

alter view geography_columns owner to gis;

You can see views with \dv (no semicolon required as this is a postgres 
command and not SQL).


On 24/05/11 14:55, Gerson Galang wrote:
> Hi Guys,
>
> I ingested a couple of shape files into PostGIS and after running a
> query against it, an exception gets thrown even if the query returns a
> proper response.
>
> Here are the tables I have in my DB:
> geo=# \dt;
>                List of relations
>    Schema |       Name        | Type  | Owner
> --------+-------------------+-------+-------
>    public | geometry_columns  | table | gis
>    public | lga07aaust_region | table | gis
>    public | spatial_ref_sys   | table | gis
>    public | ssc06aaust_region | table | gis
>
> Here's the code snippet that I'm trying to execute:
>           String typeName = "ssc06aaust_region";
>           FeatureSource source = dataStore.getFeatureSource(typeName);
>
>           Filter filter = CQL
>                   .toFilter("name_2006 = 'Melbourne'");
>           FeatureCollection<SimpleFeatureType, SimpleFeature>  features =
> source
>                   .getFeatures(filter);
>           System.out.println(features.size());
>
> And the exception that it throws back to the terminal:
> May 24, 2011 2:55:14 PM org.geotools.jdbc.JDBCFeatureSource buildFeatureType
> WARNING: Error occured determing srid for ssc06aaust_region.wkb_geometry
> org.postgresql.util.PSQLException: ERROR: permission denied for relation
> geography_columns
>       at
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
>       at
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
>       at
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
>       at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
>       at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:353)
>       at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:252)
>       at
> org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
>       at
> org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
>       at
> org.geotools.data.postgis.PostGISDialect.getGeometrySRID(PostGISDialect.java:386)
>       at
> org.geotools.jdbc.JDBCFeatureSource.buildFeatureType(JDBCFeatureSource.java:291)
>       at
> org.geotools.jdbc.JDBCDataStore.createFeatureSource(JDBCDataStore.java:767)
>       at
> org.geotools.data.store.ContentDataStore.getFeatureSource(ContentDataStore.java:384)
>       at
> org.geotools.data.store.ContentDataStore.getFeatureSource(ContentDataStore.java:349)
>       at
> org.geotools.data.store.ContentDataStore.getFeatureSource(ContentDataStore.java:102)
>       at au.org.aurin.wfs.client.QueryLab.filterFeatures(QueryLab.java:116)
>       at au.org.aurin.wfs.client.QueryLab.connect(QueryLab.java:103)
>       at au.org.aurin.wfs.client.QueryLab.<init>(QueryLab.java:67)
>       at au.org.aurin.wfs.client.QueryLab.main(QueryLab.java:54)
>
> Note that I still get "1" as the output in stdout even if the exception
> gets thrown in stderr.
>
> Any ideas?
>
> Thanks,
> Gerson
>
> ------------------------------------------------------------------------------
> vRanger cuts backup time in half-while increasing security.
> With the market-leading solution for virtual backup and recovery,
> you get blazing-fast, flexible, and affordable data protection.
> Download your free trial now.
> http://p.sf.net/sfu/quest-d2dcopy1
> _______________________________________________
> Geotools-gt2-users mailing list
> Geo...@li...
> https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
>

-- 
Ben Caradoc-Davies <Ben...@cs...>
Software Engineering Team Leader
CSIRO Earth Science and Resource Engineering
Australian Resources Research Centre