[prev in list] [next in list] [prev in thread] [next in thread]
List: postgis-users
Subject: Re: [postgis-users] shp2pgsql DBF-Column type boolen wrong
From: strk () refractions ! net
Date: 2005-11-22 22:29:00
Message-ID: 20051122222900.GC77400 () keybit ! net
[Download RAW message or body]
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@bd.so.ch
> www.sogis.so.ch
>
> _______________________________________________
> postgis-users mailing list
> postgis-users@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
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic