[postgis-users] More: error when using pgsql2shp

[Fay Du]

Hi everyone:
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
)
 
Fay
 
 
Hi everyone:
 
I got an error when I use pgsql2shp. The error does not always happens.
Sometimes it works fine , sometimes I got following error:
 
sh: -c: line 1: unexpected EOF while looking for matching `''
sh: -c: line 2: syntax error: unexpected end of file 
 
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.
 
Anyone can tell me what happens at here? Thanks in advance.
Fay
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20060605/0fc7b6af/attachment.html>