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

[markc at weaponeer.com]

Hello, 
  I've used pgsql2shp many times with this database, after 
upgrading to 0.8.1 I am getting an odd cast error. 
 
  Postgres is 7.4.2, using bison-1.875 (the problem ??), 
PostGIS is using gdal-1.2.0 (proj-4.4.7). 
 
  Also if I import a .shp of this made in 1-2004 (which 
seems to work) it dies with another syntax error. 
 
  I can send a dump of this db, as it's reasonably small. 
 
 Thanks, 
 
  Mark 
 
 
   
 
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 
markc at linux:~/qgis-0.1> psql -d gis_main 
Welcome to psql 7.4.2, the PostgreSQL interactive terminal. 
 
Type:  \copyright for distribution terms 
       \h for help with SQL commands 
       \? for help on internal slash commands 
       \g or terminate with semicolon to execute query 
       \q to quit 
 
gis_main=# select * from us_plant_rad_x; 
gis_main=# 
gis_main=# select version(); 
                                       version 
------------------------------------------------------------------------------------- 
 PostgreSQL 7.4.2 on i686-pc-linux-gnu, compiled by GCC gcc 
(GCC) 3.3.1 (SuSE Linux) 
(1 row)