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

[Gerson G. <ger...@gm...>]

Thanks Ben and Jody for your help. :-)

The issue was really due to the permissions on the geography_columns 
view. I didn't realise that PostGIS uses a view in addition to the two 
tables it added in the database.

Cheers,
Gerson

On 05/24/2011 06:51 PM, Ben Caradoc-Davies wrote:
> I think your request succeeded, but I suspect that, because of the 
> error encountered while trying to determine the SRID, your geometries 
> won't have a SRID until you grant at a minimum read access to 
> geography_columns, and so spatial operations including reprojection 
> will likely fail.
>
> On 24/05/11 14:55, Gerson Galang wrote:
>> Note that I still get "1" as the output in stdout even if the exception
>> gets thrown in stderr.
>