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

[strk]

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;