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

[strk]

On Mon, Apr 19, 2004 at 08:21:36PM -0500, markc at weaponeer.com wrote:
> This ended up being the "-b" option, we have never used it 
> before -- and I have no idea as to why it was decided to try 
> it now. 
>  
>   We have happy .shp output even with 3M rows. 
>  
> Thanks for the keen eye! 
>  
> Mark 

Mark, nonetheless I'd like to see the "incriminated" query,
because 'syntax error' is not an error I'd expect from pgsql2shp,
even with the -b switch. What I expect is a 'Cannot cast...' or 
similar. Could you please send that main_loop_query ?

TIA

--strk;

>  
>  
>  
>  
>  

> Date: Sun, 18 Apr 2004 22:04:57 -0500
> From: markc at weaponeer.com
> X-Mailer: Webmail Mirapoint Direct 3.2.2-GA
> Subject: pgsql2shp errors out after upgrading to 0.8.1
> To: postgis-users at postgis.refractions.net
> 
> 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) 
>