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 Even Rouault
Selon 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...) Ah then it is likely a problem with the setup of your database.

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 Even Rouault
Selon 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). You didn't specify which GDAL/OGR version you are using. You need GDAL/OGR 1.9 or later for PostGIS 2.0 compatibility. > > > > > > -- > View t

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

Re: [gdal-dev] ogr2ogr and PostGIS 2.0

2013-03-21 Thread Armin Schmidt
Might this be a problem with your table's name: "dm_planning-apps" ? Having a hyphen in a table's name can have all sorts of side effects. Armin -- View this message in context: http://osgeo-org.1560.n6.nabble.com/ogr2ogr-and-PostGIS-2-0-tp5041735p5041984.html Sent from the GDAL - Dev mailing l

[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