Rouault, Yes, that was the problem. spatial_ref_sys in my database got damaged somehow. I have rebuilt it and now all seems to work right, the problem is resolved.
Thank you fro your help! On 7/8/09 3:07 PM, "Even Rouault" <[email protected]> wrote: Alexandre, the interesting trace I noted in the gdal-debug.txt file is : PG: PQexec(SELECT srtext FROM spatial_ref_sys WHERE srid = 4326) = PGRES_TUPLES_OK, ntuples = 0 It looks like your spatial_ref_sys table is not correctly filled. You should check its content and/or its permissions. Best regards, Even Le Wednesday 08 July 2009 18:24:36 Sorokine, Alexandre, vous avez écrit : > Frank, > > > Actually, I suspect the debug facilities in trunk for the OGR PG driver > > have been upgraded. Would it be practical for you to try things with > > trunk? > > I did some more debugging with the version from the trunk checked out > around 10AM EST today. I compiled it on OSX with macports as: > > /configure --prefix=/Users/sorokine/Documents/appl/gdalsvninst > --with-pg=/opt/local/lib/postgresql83/bin/pg_config > --with-netcdf=/opt/local --enable-debug && make -j7 && make install > > Results of running ogrinfo are in the file in the attachment (ogrinfo with > debug plus postgresql staements from logs). My observations is that trunk > version solves some of the problems but other problems persist: > > 1. Trunk version (compared to 1.6.0) properly sets SRID for the WHERE > clause with the bounding box: > > PG: OGRPGTableLayer::BuildWhere returns: WHERE "the_geom" && > SetSRID('BOX3D(-178.217606000000 18.921785000000, -66.969269000000 > 71.406242000000)'::box3d,4326) > > Compare to 1.6.0: > > PG: OGRPGTableLayer::BuildWhere returns: WHERE the_geom && > SetSRID('BOX3D(-178.217606000000 18.921785000000, -66.969269000000 > 71.406242000000)'::box3d,-1) > > 2. Trunk version does NOT fix reporting of SRS through > OGR_L_GetSpatialRef(layer) or OGR_F_GetSpatialReferemce(feature), both > return NULL. I've tested it in my code and you can see that in trunk > ogrinfo output: > > Layer SRS WKT: > (unknown) > > 3. Trunk version doe not properly set bounding box SRS through > OGR_L_SetSpatialFilterRect() function. I've tested it in my code. > Bounding box works in ogrinfo but ogrinfo does not use this function (it > builds a geometry). > > I hope we will be able to fix it, > > On 7/7/09 11:10 PM, "Frank Warmerdam" <[email protected]> wrote: > > Sorokine, Alexandre wrote: > >> Franks, > >> > >> Thank you for your reply, I did some more checks. Please see my > >> comments below. > > > > Alexandre, > > > > I'm still wondering if this is related to schemas. I was surprised to > > not see any queries against the spatial_ref_sys table. In my trunk build > > I see something like: > > > > PG: PQexec(SELECT srtext FROM spatial_ref_sys WHERE srid = 4326) = > > PGRES_TUPLES_OK, ntuples = 1 > > > > > > Best regards, > > -- > > ---------------------------------------+--------------------------------- > >----- I set the clouds in motion - turn up | Frank Warmerdam, > > [email protected] light and sound - activate the windows | > > http://pobox.com/~warmerdam and watch the world go round - Rush | > > Geospatial Programmer for Rent _______________________________________________ gdal-dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/gdal-dev
