[R-sig-Geo] readOGR, PostGIS - problem with schemas

[Albin Blaschka]

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!