[postgis-tickets] [PostGIS] #2230: pgsql2shp fails with named schema on windows 64

[PostGIS]

#2230: pgsql2shp fails with named schema on windows 64
-----------------------+----------------------------------------------------
 Reporter:  robe       |       Owner:  pramsey      
     Type:  defect     |      Status:  new          
 Priority:  critical   |   Milestone:  PostGIS 2.0.4
Component:  postgis    |     Version:  2.0.x        
 Keywords:  windows64  |  
-----------------------+----------------------------------------------------
 This is a note from Jeff:
 http://lists.osgeo.org/pipermail/postgis-devel/2013-March/023297.html

 I just tested and confirmed its the same issue with 2.0.3. I think we had
 a similar issue a while back with shp2pgsql and perhaps because that is
 more heavily tested it was caught there.

 {{{
 pgsql2shp -f "c:/test.shp" -g geom -u "postgres" -h t -p 5432 -P
 "mypassword" mygisdb public.constrained_geoms
 }}}

 The is is the . is being put in the wrong spot this is what the log shows:
 {{{

 SELECT a.attname, a.atttypid, a.atttypmod, a.attlen FROM pg_attribute a,
 pg_class c, pg_namespace n WHERE n.nspname = 'public.' AND a.attrelid =
 c.oid AND n.oid = c.relnamespace AND a.atttypid != 0 AND a.attnum > 0 AND
 c.relname = 'constrained_geoms'
 }}}

 note the public. instead of public

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2230>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.