Re: [gdal-dev] postgis: strange behavior when 'public' schema does not exist

2012-04-11 Thread Chaitanya kumar CH
Thanks Martijn, I missed the sentence "It can be dropped, too" when I first read it. I opened a ticket for this issue. http://trac.osgeo.org/gdal/ticket/4611 On Thu, Apr 12, 2012 at 11:59 AM, Martijn van Exel wrote: > On Thu, Apr 12, 2012 at 12:26 AM, Chaitanya kumar CH < > chaitanya...@gmail.

Re: [gdal-dev] postgis: strange behavior when 'public' schema does not exist

2012-04-11 Thread Martijn van Exel
On Thu, Apr 12, 2012 at 12:26 AM, Chaitanya kumar CH wrote: > Martijn, > > Thanks for the excellent error report. > I couldn't find any statement for or against the requirement for the > public schema. Can you provide a reference to this? > > > It's in 5.7.3 of the PostgreSQL documentation: http:

Re: [gdal-dev] postgis: strange behavior when 'public' schema does not exist

2012-04-11 Thread Chaitanya kumar CH
Martijn, Thanks for the excellent error report. I couldn't find any statement for or against the requirement for the public schema. Can you provide a reference to this? On Thu, Apr 12, 2012 at 10:43 AM, Martijn van Exel wrote: > Hi all, > > I had trouble extracting a shape file from a PostGIS t

[gdal-dev] postgis: strange behavior when 'public' schema does not exist

2012-04-11 Thread Martijn van Exel
Hi all, I had trouble extracting a shape file from a PostGIS table using ogr2ogr (1.9.0 on Ubuntu 10.04 64 bit). Debug output from ogr2ogr: mvexel@lima:/osm/tmp/candidates$ ogr2ogr -overwrite -f "ESRI Shapefile" --debug on candidates PG:"dbname=osmus active_schema=us user=osm password=osm" candid