[postgis-devel] [PostGIS] #522: pgsql2shp ignoring the -f switch

[PostGIS]

#522: pgsql2shp ignoring the -f switch
----------------------+-----------------------------------------------------
  Reporter:  robe     |       Owner:  pramsey      
      Type:  defect   |      Status:  closed       
  Priority:  medium   |   Milestone:  PostGIS 1.5.3
 Component:  postgis  |     Version:  1.5.X        
Resolution:  fixed    |    Keywords:               
----------------------+-----------------------------------------------------
Changes (by mcayland):

  * status:  new => closed
  * resolution:  => fixed


Comment:

 I don't think this is a bug. According to the pgsql2shp help output:

 USAGE: ./pgsql2shp [<options>] <database> [<schema>.]<table>
        ./pgsql2shp [<options>] <database> <query>

 Both the database and query/table arguments are compulsary and must be the
 last arguments (looking at the code, this restriction will have always
 existed unless system getopt()s have started doing something really clever
 before the switch back to our inbuilt one).

 Variations on the following queries work for me on both Win32 and Linux:

 pgsql2shp -h prodserv -p 5434 -u robe -f projects -g the_point gisdb
 vwprojects
 pgsql2shp -h prodserv -p 5434 -u robe -f dndprojects -g the_point gisdb
 "SELECT * FROM vwdndprojects WHERE the_point IS NOT NULL"

 Regina, can you confirm and resolve as "invalid" if this works in your
 tests?

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/522#comment:6>
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.