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
