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

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

Thanks a lot, Gerson, that would be excellent.

On 26/05/11 13:49, Gerson Galang wrote:
> Hi Ben, Andrea,
>
> I'm using 2.7.0 taken from the maven repository at download.osgeo.org.
> I've seen that you guys have 2.7.1 in there now, I'll switch to that,
> revert the ownership of the geography view, and test it out for you.
>
> Cheers,
> Gerson
>
> On 05/25/2011 05:06 PM, Ben Caradoc-Davies wrote:
>> Gerson,
>>
>> what version of GeoTools are you using?
>>
>> Andrea Aime thinks this might have been fixed on 28 March (logs say
>> both 2.7.x and trunk):
>> http://jira.codehaus.org/browse/GEOT-3603
>>
>> This means that this should be fixed in 27.0.1 or later or 8.0-M0. If
>> not, we'd like to know.
>>
>> Kind regards,
>> Ben.
>>
>>
>> On 25/05/11 09:57, Gerson Galang wrote:
>>> Hi Ben,
>>>
>>> Yes, our application (being Australian based) only needs to use
>>> geometries.
>>>
>>> Oh, and thanks for filing a Jira entry for this issue.
>>>
>>> Cheers,
>>> Gerson
>>>
>>>
>>> On 05/25/2011 11:38 AM, Ben Caradoc-Davies wrote:
>>>> Geography support is new in PostGIS 1.5.
>>>>
>>>> In my view (no pun intended), GeoTools behaviour could have been
>>>> better in this case: if it could not read geography_columns, it should
>>>> have used the information it could access in geometry_columns if
>>>> possible. I have filed a Jira issue to request this change:
>>>> https://jira.codehaus.org/browse/GEOT-3603
>>>>
>>>> Gerson, I'm assuming that your table was not using geographies, just
>>>> geometries?
>>>>
>>>> Kind regards,
>>>> Ben.
>>>>
>>>> On 25/05/11 07:16, Gerson Galang wrote:
>>>>> 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.
>>>>>>
>>>>>
>>>>
>>>
>>
>

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