[Gdal-dev] problem with ogr2ogr -f PostgreSQL...

Chapman, Martin MChapman at sanz.com
Tue Mar 7 18:50:21 EST 2006


Ethan,

You missed my email before which has an attachment.  I had to modify the
driver code to get it to work with 8.x.  I added a new connection prefix
for 8.x connects called PG8:.  The mailing server stopped the
attachment.  Here is what I wrote:

Thom,

I had problems with 8.1 as well.  I made mods to the attached file to
get it to work.  Your connection string for pg 8.x should be PG8: to
connect correctly.  Look at the open method to see my changes.  

Martin

-----Original Message-----
From: Ethan Alpert [mailto:ealpert at digitalglobe.com] 
Sent: Tuesday, March 07, 2006 4:33 PM
To: Chapman, Martin; Thom DeCarlo; gdal-dev at lists.maptools.org
Subject: RE: [Gdal-dev] problem with ogr2ogr -f PostgreSQL...


Actually you need PGB:  NOT PG8: 

I just dumped and inserted data using the CVS version of ogr with
postgres 8.1.3 and postgis 1.1.1

-e

-----Original Message-----
From: gdal-dev-bounces at lists.maptools.org
[mailto:gdal-dev-bounces at lists.maptools.org] On Behalf Of Chapman,
Martin
Sent: Tuesday, March 07, 2006 4:07 PM
To: Thom DeCarlo; gdal-dev at lists.maptools.org
Subject: RE: [Gdal-dev] problem with ogr2ogr -f PostgreSQL...

Thom,

Also, you will have to modify ogr2ogr to pass the PG8: connection prefix
instead of PG:.  When I look at the old code I don't know how it ever
worked.  Basically because the PG: prefix was never being stripped off
the connect string before being passed to the PG driver, and the PG
driver doesn't like the PG: prefix.  Maybe in pre 8.x versions I would
ignore the prefix.

Martin

-----Original Message-----
From: gdal-dev-bounces at lists.maptools.org
[mailto:gdal-dev-bounces at lists.maptools.org] On Behalf Of Thom DeCarlo
Sent: Tuesday, March 07, 2006 3:22 PM
To: gdal-dev at lists.maptools.org
Subject: [Gdal-dev] problem with ogr2ogr -f PostgreSQL...

I've set up my PostGIS-enabled PostgreSQL database and created a dataset
called "spatial". I have several shapefiles that I want to load into a
single layer. I found the instructions on the gdal website but when I
specify a layername at the end of the ogr2ogr command it quietly fails.
That
is, no messages of any kind either at the command line nor in the pgsql
logfile. If I don't specify a layername the command works just fine.

Are there known problems with this function? I'm using PostGIS 1.1.0 and
PostgreSQL 8.1.1 on RHEL3.

Thanks,
Thom

--
Thom DeCarlo
-------------------------------------------------------
             Who is General Failure
         and why is he reading my disk?



_______________________________________________
Gdal-dev mailing list
Gdal-dev at lists.maptools.org
http://lists.maptools.org/mailman/listinfo/gdal-dev

_______________________________________________
Gdal-dev mailing list
Gdal-dev at lists.maptools.org
http://lists.maptools.org/mailman/listinfo/gdal-dev




More information about the Gdal-dev mailing list