[postgis-users] Size of FTDate field in dbf files

[Peter Hopfgartner]

Dear PostGIS developers

After having changed the field size from 10 to 8 everything works fine 
as expected.

This means that the comment in file pgsql2shp.c, lines 2730,2731 is not 
accurate anymore.


The attached diff is against the current SVN.

Best regards,

Peter Hopfgartner and Sergio Segala
R3 GIS

http://www.r3-gis.com


Peter Hopfgartner wrote:
> Dear mailing list members,
>
> we had some problems when editing shape files containing dates 
> generated with pgsql2shp. In particular, editing these files with 
> ArcGIS and some OS desptop GIS (QGIS or OpenJump, sorry I can't 
> remember exactly) the attributes where shifted by some white spaces.
>
> Looking at the files generated with pgsql2shp, we noted that  a length 
> of 10 bytes is assigned to date fields (see also current the svn 
> snapshot, loader/pgsql2shp.c:2735,2736), in apparent contrast with the 
> dbf file format specification 
> (http://www.dbase.com/knowledgebase/int/db7_file_fmt.htm), which 
> specifies that these field are 8 bytes long.
>
> Best regards,
>
> Peter Hopfgartner and Sergio Segala
> R3 GIS
>
> http://www.r3-gis.com
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>

-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgsql2shp.date-field-size.diff
Type: text/x-patch
Size: 483 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080410/cc9bce4a/attachment.bin>