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 <[email protected]> Software Engineering Team Leader CSIRO Earth Science and Resource Engineering Australian Resources Research Centre ------------------------------------------------------------------------------ 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
