[postgis-users] shp2pgsql problem

[Tom Glancy]

Your dbf file contains spaces (0x20) in the "microrelie" boolean and "macrorelie" boolean fields. The representation of NULL in boolean fields is a question mark (0x3f). Allowable characters in a boolean field are Y,y,N,n,T,t,F,f,?
 
It looks like your dbf is broken.
 
Regards,
Tom
 

>>> "Willy-Bas Loos" <willybas at gmail.com> 12/13/2007 6:15 AM >>>
here's the rest of the shapefile (still one record, attached). 

On Dec 13, 2007 11:04 AM, Willy-Bas Loos <willybas at gmail.com> wrote:


Hi,

I have a small problem wit shp2pgsql, it doesn't convert my colleague's shapefile correctly.
I've attached the 1rec shapefile and the shp2pgsql result in this mail, hope that works.

I'm using this version: RCSID: $Id: shp2pgsql.c,v 1.88.2.7 2005/08/29 22:36:14 strk Exp $
on windows XP.

The problem is in two of the boolean fields: "microrelie" boolean and "macrorelie" boolean. 
They are both created, but their values don't make it into the INSERT statement. They turn up as empty strings, which is illegal SQL.
There are lots (37) of fields in the shapefile.
12 other boolean fields are handled correctly. 
The "bad" fields are the 24th and the 25th field.

is this some bug?

WBL


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20071213/d5c248b8/attachment.html>