[FWTools] ogr2ogr and postgres 8.3.4

[Chetan Tiwari]

Hi Frank,

Thanks for the note. I figured the problem out last night. I was
programatically creating tables in PostGIS, but not adding a corresponding
entry to the geometry_columns table. After I started doing that (adding an
appropriate entry in the geometry_columns table), ogr2ogr worked perfectly.
I guess this wasn't the case before, was it?

Thanks much,

Warm regards,

Chetan

On Mon, Nov 10, 2008 at 8:26 AM, Frank Warmerdam <warmerdam at pobox.com>wrote:

> Chetan Tiwari wrote:
>
>> Hi All,
>>
>> I have been having some issues with ogr2ogr and postgres 8.3.4 on Linux. I
>> mainly use it to convert a postgis table to a shapefile. Ogr2ogr works fine
>> with 8.2.4, but seems to be giving me trouble with 8.3.4. <http://8.3.4<http://8.3.0.4/>.>
>> The error message with 8.3.4 is "Unable to open datasource
>> `PG:host=localhost user=user port=5489 dbname=dmap password=xxx' with the
>> following drivers.". I saw something on this list about the geometry_columns
>> table, but couldn't quite follow the thread.
>>
>> Any suggestions will be most appreaciated.
>>
>
> Chetan,
>
> Does ogrinfo work against this datasource name?
>
> Could you add "--debug on" (without the quotes) to your commandline and
> capture all the resulting output for us?
>
> Best regards,
> --
>
> ---------------------------------------+--------------------------------------
> I set the clouds in motion - turn up   | Frank Warmerdam,
> warmerdam at pobox.com
> light and sound - activate the windows | http://pobox.com/~warmerdam
> and watch the world go round - Rush    | Geospatial Programmer for Rent
>
>


-- 
Chetan Tiwari, PhD
Assistant Professor
University of North Texas
Department of Geography
1155 Union Circle #305279
Denton, TX 76203-5017
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.maptools.org/pipermail/fwtools/attachments/20081110/8be8f66e/attachment.html