readOGR, PostGIS - problem with schemas
Am 14.11.2011 13:50, schrieb Ben Madin:
Albin, I too have encountered this problem, and there was a bit of a discussion on this list a little over twelve months ago (search for "error in readogr") The bottom line in my case was to do with the layers (and the correct schemas) not being properly recorded in the geometry columns table. I think I might have truncated and run populate_geometry_columns() a couple of times to overcome this. I think it was also important that the schema you want is in the database search_path... this might have to be done before the populate_geometry_columns function is run. cheers (good luck, the frustration nearly killed me but I was very generously helped by this list.) Ben
Hello Ben, hello list! a truncate on the table geometry_columns followed by a select Populate_Geometry_columns() did the trick - readOGR now works as expected! Thank you very much! kind regards, Albin
| Albin Blaschka, Mag.rer.nat. | Etrichstrasse 26, A-5020 Salzburg | * www.albinblaschka.info * www.thinkanimal.info * | - It's hard to live in the mountains, hard but not hopeless!