[postgis-users] pgsql2shp errors out after upgrading to 0.8.1

[markc at weaponeer.com]

The -b option caused my particular problem, and seems to 
anger the .shp gods in a generic way.  I'll try though to 
pass the debug info along tomorrow.  Along with the .shp I 
import and try to export again with -b. 
 
Honestly not sure how the -b made it into what we are 
doing...  No doubt we randomized ourselves into it! 
 
  Cheers, 
 
  Mark 
 
 
 
 
 
---- Original message ---- 
>Date: Mon, 19 Apr 2004 18:36:56 -0700 
>From: Paul Ramsey <pramsey at refractions.net>   
>Subject: Re: [postgis-users] pgsql2shp errors out after 
upgrading to 0.8.1   
>To: PostGIS Users Discussion 
<postgis-users at postgis.refractions.net>, markc at weaponeer.com 
> 
>Mark, 
>If you could do the debug routine as strk outlines below 
and send him  
>the SQL, it will help us kill this bug for future versions. 
>Thanks, 
>Paul 
> 
>strk wrote: 
> 
>> On Sun, Apr 18, 2004 at 10:04:57PM -0500, 
markc at weaponeer.com wrote: 
>>  
>> (cuts) 
>>  
>>  
>>>markc at linux:~/qgis-0.1> pgsql2shp -b gis_main 
us_plant_rad_x  
>>>Initializing... Done.  
>>>ERROR:  syntax error at or near ""::text,"" at character  
>>>1121  
>>  
>>  
>> You should try to get the entire query. 
>> Uncomment around line 312 in pgsql2shp.c and see what is 
the query. 
>> Note that the -b switch tries to cast every attribute to 
a text, 
>> except the geometries. Also try without the -b switch. 
>>  
>> --strk; 
>> _______________________________________________ 
>> postgis-users mailing list 
>> postgis-users at postgis.refractions.net 
>> http://postgis.refractions.net/mailman/listinfo/
postgis-users 
> 
> 
>--  
>       __ 
>      / 
>      | Paul Ramsey 
>      | Refractions Research 
>      | Email: pramsey at refractions.net 
>      | Phone: (250) 885-0632 
>      \_