[postgis-users] More: error when using pgsql2shp

[Frank Koormann]

Hi,

* Fay Du <fay.du at versaterm.com> [060605 22:02]:
>    Sorry I forgot to list my pgsql2shp command. It is:
> 
>    pgsql2shp -f  route_output  -r  my_db SELECT gid, the_geom FROM
>    street_graph  WHERE edge_id in
>    (1,221237,221249,221251,221267,221299,221301,221303,221305,221952,221962)
> 
[...]

>    sh: -c: line 1: unexpected EOF while looking for matching `''
>    sh: -c: line 2: syntax error: unexpected end of file

Have you ansured that there is no linebreak in your command line ?
> 
>    My command likes:
> 
>    SELECT gid, the_geom FROM street_graph  WHERE edge_id in
>    (1,221237,221249,221251,221267,221299,221301,221303,221305,221952,221962);
> 
>    The error always happens when I have a long edge_id list, for example 50
>    items in list.

Does it _always_ happen with a long edge_id list or _only_ with a long
list. In any case it would be helpful to get an actually failing
example.
  
Regards,

        Frank

-- 
Frank Koormann                             <frank.koormann at intevation.de>
 Professional Service around Free Software       (http://intevation.net/)
 FreeGIS Project                                 (http://freegis.org/)