[postgis-users] More: error when using pgsql2shp

[Fay Du]

Hi Frank:
Thanks for the response.

In one failed example, the edge_id list is:
1,210723,210758,210780,210798,212284,216148,219424,219427,219429,230024,
230
040,230048,230058,230068,230076,230092,230096,230104,230110,230116,23012
6,231056,231066,231086,231096,231108,231116,231122,231375,231377,231974,
231976,231980,231986,231988,231990,231992,232759,232775,232779,232784,23
2786,232788,233253,233604,233781,234001,234006,234017,234022,234033,2344
20,237587,238315,238564,240807,240925,241512,241514,241964

In one successful example, the edge_list is:
1,221237,221249,221251,221267,221299,221301,221303,221305,221952,221962,
224
813,227304,227306,227310,227312,232208,232210,232218,232220,232226,23223
2,232236,232244,232248,232250,232254,235180,237944

Everything else is same. The command is coded in a 4GL program, only 2
things change every time run the program: route_output (it is output
file name), and edge_id list (it is the list of edge id of each row in
the route).

Fay

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
Frank Koormann
Sent: Tuesday, June 06, 2006 3:49 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] More: error when using pgsql2shp

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/)
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users