[postgis-users] error when using pgsql2shp

[Fay Du]

Strk:
Thanks for the quick response. I am working on Linux. POSTGIS Version is
postgis-1.1.1.
I am creating a shortest path and try to create a shape file of the
route. Each route row in route table has edge_id and street_graph  table
has same column and links 2 table together. street_graph  contains
geometry feature and route table does not. It is why I need select
sentence at here.

My route table is a temporary table. I cannot use AddGeometryColumn to
add geometry column after create it.

Fay

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
strk at refractions.net
Sent: Monday, June 05, 2006 3:51 PM
To: postgis-users at postgis.refractions.net
Subject: Re: [postgis-users] error when using pgsql2shp

mmm.. I don't understand why should 'sh' be involved here.
What architecture are you on ? What type of file is `which pgsql2shp` ?

--strk;

On Mon, Jun 05, 2006 at 03:47:28PM -0400, Fay Du wrote:
> 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
>  
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users