[postgis-users] shp2pgsql problem

[Willy-Bas Loos]

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/505c5cad/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: bool1rec.dbf
Type: application/x-dbase
Size: 1554 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20071213/505c5cad/attachment.bin>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: bool1rec.copy
Type: application/octet-stream
Size: 1972 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20071213/505c5cad/attachment.obj>