[gdal-dev] [SOLVED] Re: Trouble connecting to PostGIS db

[Frank Warmerdam]

On Mon, Oct 6, 2008 at 7:44 AM, Jose Gómez-Dans <jgomezdans at gmail.com> wrote:
> Hi,
>
> On Friday 03 October 2008 20:58:27 you wrote:
>> > Nope, that doesn't change a thing. I am realising that my
>> > geometry_columns table is empty, maybe this is where the problem lies?
>>
>> May be.  However, quotes seem to make difference on both my Windows XP and
>> Windows Vista: Single quotes are yielding the same message that you got,
>> while double quotes are working.
>
>
> Yes, I added an entry in the geometry_columns table, and I can access my data
> in PostGIS. I imported my data with shp2pgsql, and I assumed entries to the
> geometry table were done automatically, which doesn't seem to be the case.
>
> If having an entry in geometry_columns is a requirement, maybe it should be
> visible in OGR's PostGIS page? Or maybe it's there and I haven't seen it!

Jose,

You are correct.  There is a rather questionable decision to
assume the open fails if no layers are found in read-only
mode for this, and a few other drivers.  I've often found this
to be a problem and would consider changing 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    | Geospatial Programmer for Rent