Re: [gdal-dev] PostgreSQL problems

2011-10-15 Thread David J. Bakeman
Sounds like 1.8 and my reading the docs more carefully :) would solve my problems. Thanks for the info Even I really appreciate it! Even Rouault wrote: Le samedi 15 octobre 2011 00:51:01, David J. Bakeman a écrit : > Thanks Even and everyone else who responded! It was the fact that

Re: [gdal-dev] PostgreSQL problems

2011-10-15 Thread Even Rouault
Le samedi 15 octobre 2011 00:51:01, David J. Bakeman a écrit : > Thanks Even and everyone else who responded! It was the fact that I had > created the tables without registering the geometry column. I did that > and now things appear good to go! That is ogrinfo is successful and > lists the thre

Re: [gdal-dev] PostgreSQL problems

2011-10-14 Thread David J. Bakeman
Thanks Even and everyone else who responded! It was the fact that I had created the tables without registering the geometry column. I did that and now things appear good to go! That is ogrinfo is successful and lists the three tables with geometry. Perhaps the normal user of ogr is aware th

Re: [gdal-dev] PostgreSQL problems

2011-10-14 Thread Even Rouault
> OK now we are getting somewhere! I did the following: > > env PG_LIST_ALL_TABLES=YES ogrinfo --debug on PG:'dbname=mydb' > PG: DBName="mydb" > PG: PostgreSQL version string : 'PostgreSQL 8.4.9 on > x86_64-redhat-linux-gnu, compiled by GCC gcc (GCC) 4.5.1 20100924 (Red > Hat 4.5.1-4), 64-bit' >

Re: [gdal-dev] PostgreSQL problems

2011-10-14 Thread David J. Bakeman
Even Rouault wrote: Le vendredi 14 octobre 2011 22:57:32, David J. Bakeman a écrit : Even Rouault wrote: Le vendredi 14 octobre 2011 21:04:12, David J. Bakeman a écrit : Try ogrinfo --debug on -ro PG:'dbname=mydb' OK I am totally confused now here is the output: ogrinfo --

Re: [gdal-dev] PostgreSQL problems

2011-10-14 Thread Even Rouault
Le vendredi 14 octobre 2011 22:57:32, David J. Bakeman a écrit : > Even Rouault wrote: > > Le vendredi 14 octobre 2011 21:04:12, David J. Bakeman a écrit : > > > > Try ogrinfo --debug on -ro PG:'dbname=mydb' > > OK I am totally confused now here is the output: > ogrinfo --debug -ro PG:'dbname=m

Re: [gdal-dev] PostgreSQL problems

2011-10-14 Thread David J. Bakeman
Even Rouault wrote: Le vendredi 14 octobre 2011 21:04:12, David J. Bakeman a écrit : Try ogrinfo --debug on -ro PG:'dbname=mydb' OK I am totally confused now here is the output: ogrinfo --debug -ro PG:'dbname=mydb' INFO: Open of `PG:dbname=mydb' using driver `PostgreSQL' successful.

Re: [gdal-dev] PostgreSQL problems

2011-10-14 Thread Even Rouault
Le vendredi 14 octobre 2011 21:04:12, David J. Bakeman a écrit : Try ogrinfo --debug on -ro PG:'dbname=mydb' and see if something interesting shows up (and post the output to the list if you don't find the solution by yourself) It is really weird that it works with QGIS but not with OGR. Th

Re: [gdal-dev] PostgreSQL problems

2011-10-14 Thread David J. Bakeman
Sorry I was trying to limit the bandwidth I used I figured it was probably something really stupid and someone would just say you forgot to XX :<; Anyway this is a test database so it really is named mydb and I copied the ogrinfo command from the PostgreSQL driver page for OGR. I checked bef

Re: [gdal-dev] PostgreSQL problems

2011-10-13 Thread Eli Adam
David, It probably is a configuration or simple error, however, you've not given much detail to let other people try to guess what it might be. Kyle asked for the output of your command. Also, the exact command (copied from terminal) may help too. I looked at the OGR PosrgreSQL/PostGIS for

Re: [gdal-dev] PostgreSQL problems

2011-10-13 Thread David J. Bakeman
Mateusz Łoskot wrote: On 13 October 2011 23:47, David J. Bakeman wrote: I'm on Fedora core 14 with gdal 1.7.3. I setup postgre and created a spatial enabled database with a table that includes geometry. I can connect using psql mydb. However when I try ogrinfo -ro PG:dbname=mydb it fails

Re: [gdal-dev] PostgreSQL problems

2011-10-13 Thread Mateusz Łoskot
On 13 October 2011 23:47, David J. Bakeman wrote: > I'm on Fedora core 14 with gdal 1.7.3. > > I setup postgre and created a spatial enabled database with a table that > includes geometry.  I can connect using psql mydb.  However when I try > ogrinfo -ro PG:dbname=mydb it fails saying no driver fo

RE: [gdal-dev] PostgreSQL problems

2011-10-13 Thread Kyle Shannon
Can you show us the output of the command? And also ogrinfo --formats From: gdal-dev-boun...@lists.osgeo.org [mailto:gdal-dev-boun...@lists.osgeo.org] On Behalf Of David J. Bakeman Sent: Thursday, October 13, 2011 4:47 PM To: gdal-dev@lists.osgeo.org Subject: [gdal-dev] PostgreSQL problems I&#

[gdal-dev] PostgreSQL problems

2011-10-13 Thread David J. Bakeman
I'm sure I've done something stupid but I've googled for hours and haven't been able to figure this out.  Any help is greatly appreciated! I'm on Fedora core 14 with gdal 1.7.3. I setup postgre and created a spatial enabled database with a table that includes geometry.  I can connect using ps