[postgis-users] shp2pgsql DBF-Column type boolen wrong

[strk at refractions.net]

The revision of shp2pgsql should already handle
boolean values correctly, as long as they are tagged
as FTLogical in the dbf.
On the other hand, it seems that pgsql2shp does *never*
set dbf fields as FTLogical, so the "bug" would be
in the dumper, not the loader.

Would you file a bug report in the bug tracker so I'll
try to do this for 1.0.5 (scheduled this Friday) ?

--strk;

On Tue, Nov 22, 2005 at 02:25:19PM +0100, Düster Horst wrote:
> I try to convert a shapefile with one column of type boolean via shp2pgsql.
> In the resulting pgsql table this column appears as type varchar instead of
> type boolean. I found out the following facts:
> 
> - Coversion shp->pgsql:  
> 	shp2pgsql -d¦-c ...	boolean is changed to varchar
> 	shp2pgsql -a		boolean is correct when in table definition
> the field is defined as boolean
> 
> - Conversion pgsql->shp		works correct, table boolean appears as shp
> boolean
> 
> 
> My system:
> 
> Windows
>   shp2pgsql 1.88.2.7 
>   pgsql2shp 1.74.2.4
> 
> Linux
>  Postgresql 8.1
>  Postgis 1.0.4
> 
> I would be grateful for any hint.
> 
> Regards
> 
> Dr. Horst Düster 
> GIS-Koordinator, Stv. Amtsvorsteher
> 
> Kanton Solothurn 
> Amt für Geoinformation
> Abteilung SO!GIS Koordination
> Rötistrasse 4
> CH-4501 Solothurn 
> 
> Tel.: ++41 (0)32 627 25 32 
> Fax: ++41 (0)32 627 22 14
> 
> horst.duester at bd.so.ch 
> www.sogis.so.ch
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

-- 

 /"\    ASCII Ribbon Campaign
 \ /    Respect for open standards
  X     No HTML/RTF in email
 / \    No M$ Word docs in email