[GRASS-dev] [GRASS GIS] #1481: v.in.ogr with postgis layers fails if the table schema is on the first place in the search_path of the database

[GRASS GIS]

#1481: v.in.ogr with postgis layers fails if the table schema is on the first
place in the search_path of the database
-------------------------+--------------------------------------------------
 Reporter:  tomdb        |       Owner:  grass-dev@…              
     Type:  defect       |      Status:  new                      
 Priority:  normal       |   Milestone:                           
Component:  Vector       |     Version:  6.4.1                    
 Keywords:               |    Platform:  Linux                    
      Cpu:  Unspecified  |  
-------------------------+--------------------------------------------------
 The command
 {{{
 v.in.ogr  dsn="PG:dbname=XXX user=XXX host=XXX" layer=venue.stand_lines
 output=lines type=boundary
 }}}
 fails if the schema "venue" is on the first place of the search path of
 the database XXX. The same command without the schema definition (
 "layer=stand_lines") works fine as expected.
 Examples:
 {{{
 XXX=>ALTER DATABASE XXX set search_path = venue,public;

 GRASS 6.4.1 (xy):~/grassdata/xy >v.in.ogr dsn="PG:dbname=XXX user=XXX
 host=localhost " layer=venue.stand_lines output=lines type=boundary
 --overwrite
 WARNING: Vector map <lines> already exists and will be overwritten
 ERROR: Layer <venue.stand_lines> not available
 }}}
 {{{
 XXX=>ALTER DATABASE XXX set search_path = venue,public;

 GRASS 6.4.1 (xy):~/grassdata/xy >v.in.ogr dsn="PG:dbname=XXX user=XXX
 host=localhost " layer=stand_lines output=lines type=boundary --overwrite

 ...works fine....
 }}}

 {{{
 XXX=>ALTER DATABASE XXX set search_path = public,venue;

 GRASS 6.4.1 (xy):~/grassdata/xy > v.in.ogr dsn="PG:dbname=XXX user=XXX
 host=localhost " layer=venue.stand_lines output=lines type=boundary
 --overwrite

 ...works fine....
 }}}

 {{{
 XXX=>ALTER DATABASE XXX set search_path = venue,public;

 GRASS 6.4.1 (xy):~/grassdata/xy > v.in.ogr  dsn="PG:dbname=XXX user=XXX
 host=localhost " layer=stand_lines output=lines type=boundary --overwrite

 ...works fine....
 }}}


 {{{
 XXX=>ALTER DATABASE XXX set search_path = public;

 GRASS 6.4.1 (xy):~/grassdata/xy > v.in.ogr  dsn="PG:dbname=XXX user=XXX
 host=localhost " layer=venue.stand_lines output=lines type=boundary
 --overwrite

 ...works fine....
 }}}

-- 
Ticket URL: <http://trac.osgeo.org/grass/ticket/1481>
GRASS GIS <http://grass.osgeo.org>