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. >>>>> >>>> >>> >> > ------------------------------------------------------------------------------ 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 [email protected] https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
