[Gdal-dev] gdal 1.2.6 and postgis 0.9.2 OK - gdal 1.3.1 and postgis 1.1.3 KO

[Frank Warmerdam]

Arlo wrote:
> Hi All,
> 
> I'm dealing now with a big issue on my project.
> I use GDAL in my c++ code to connect to a custom database wich contains
> a few geometrics data like this
...
> Everything works fine as long as i used gdal 1.2.6 and postgis 0.9.2,
> but i need to install my project on a new platform which contains
> postgis 1.1.3.
> 
> My first try with a updated postgis was'nt sucessful. My c++ code fail
> on getting the geometry of my feature (feature->GetGeometryRef() = NULL)
> 
> I thought that gdal 1.2.6 isn't compatible with postgis >= 1 (new
> postgresql binary stockage of geometry ?), so i try gdal 1.3.2 without
> more success
> 
> Symtoms are :
> 
>    * the new orginfo (1.3.1) are silent about the two databases i test
>      (postgis 0.9.2 and 1.1.3 ). It just say
> 
> ./ogrinfo -al  "PG:dbname=...host=192.168.0.129 user=...password=..."
> INFO: Open of `PG:dbname=...host=192.168.0.129 user=sytadin password=...'
> using driver `PostgreSQL' successful.

Arlo,

Are your layers properly registered in the GEOMETRY_COLUMNS table?
I think that at some point in history, the OGR PG driver was changed
to only treat tables listed in GEOMETRY_COLUMNS as layers.

I'm not surprised that GDAL 1.2.6 doesn't work against PostGIS 1.0+.
I'm currently using PostGIS 1.0.x, so it is possible there are some
issues with 1.1.x but I would expect them to be debilitating or I
would have heard quite a bit about it.

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    | President OSGF, http://osgeo.org