[GRASS-dev] [GRASS GIS] #1274: PostGIS load with v.in.ogr fails without -t

[GRASS GIS]

#1274: PostGIS load with v.in.ogr fails without -t
------------------------+---------------------------------------------------
 Reporter:  arencambre  |       Owner:  grass-dev@…              
     Type:  defect      |      Status:  new                      
 Priority:  normal      |   Milestone:  6.4.1                    
Component:  Default     |     Version:  6.4.1 RCs                
 Keywords:              |    Platform:  MSWindows 7              
      Cpu:  x86-32      |  
------------------------+---------------------------------------------------
 (This problem also happens in 6.4.0.)

 Given the following command (XXX and YYY replaced with valid values):
 {{{
 v.in.ogr -o "dsn=PG:dbname=de host=localhost port=5432 user=XXX
 password=YYY
 sslmode=disable" layer=consistent.master output=master_grass4 --verbose
 }}}

 The result:

 {{{
 Over-riding projection check
 Layer: consistent.master
 Width for column school_zone set to 255 (was not specified by OGR), some
 strings may be truncated!
 Width for column vehicle_color set to 255 (was not specified by OGR), some
 strings may be truncated!
 Width for column offense_location set to 255 (was not specified by OGR),
 some strings may be truncated!
 Width for column work_zone set to 255 (was not specified by OGR), some
 strings may be truncated!
 DBMI-Postgres driver error:
 Cannot connect to Postgres: fe_sendauth: no password
 supplied
 Unable to open database <host=localhost,dbname=de> by driver <pg>
 ERROR: Unable open database <host=localhost,dbname=de> by driver <pg>
 }}}

 I think the important error is '''fe_sendauth: no password supplied'''.
 It's clearly bogus as the width warnings would not be possible unless the
 database table was read, which means there is in fact a valid password.

 If I run the same query with a {{{-t}}}, it works fine, but then I get no
 attributes which isn't what I wanted.

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