Re: [gdal-dev] ogr2ogr and PostGIS 2.0

2013-03-21 Thread EdH
Hi, It's the superuser of the whole db cluster so I'd be surprised if its a permissions error. Any ideas what might be wrong in the setup to cause this or how i might diagnose a problem? -- View this message in context: http://osgeo-org.1560.n6.nabble.com/ogr2ogr-and-PostGIS-2-0-tp5041735p5

Re: [gdal-dev] ogr2ogr and PostGIS 2.0

2013-03-21 Thread EdH
Just installed GDAL 1.9.2 and am having the same error. When I run a query in PGadmin to show all tables the gemoetry columns "view" does not appear but the other three "views" do (e.g. geography columns etc...) -- View this message in context: http://osgeo-org.1560.n6.nabble.com/ogr2ogr-and-P

Re: [gdal-dev] ogr2ogr and PostGIS 2.0

2013-03-21 Thread EdH
Thanks for this suggestion, but I'm still getting the same error when I try another table in the same db called "lnr" (i.e. no hyphens). -- View this message in context: http://osgeo-org.1560.n6.nabble.com/ogr2ogr-and-PostGIS-2-0-tp5041735p5042009.html Sent from the GDAL - Dev mailing list ar

[gdal-dev] ogr2ogr and PostGIS 2.0

2013-03-20 Thread EdH
Hi, I'm trying to extract a table from PostGIS into a shapefile. Using the command: "c:\Program Files\Quantum GIS Lisboa\bin\ogr2ogr.exe" -f "ESRI Shapefile" c:\test\planning.shp PG:"host=w2k3nnpgis1 user=postgres dbname=mapdata password=" "dm_planning-apps" And I get this error: ER