[postgis-users] shp2pgsql problem

[Willy-Bas Loos]

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/0775e7b9/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: bool1rec.shp
Type: application/octet-stream
Size: 380 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20071213/0775e7b9/attachment.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: bool1rec.shx
Type: application/octet-stream
Size: 108 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20071213/0775e7b9/attachment-0001.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: bool1rec.sbn
Type: application/octet-stream
Size: 132 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20071213/0775e7b9/attachment-0002.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: bool1rec.sbx
Type: application/octet-stream
Size: 116 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20071213/0775e7b9/attachment-0003.obj>