[postgis-devel] [PostGIS] #393: shp2pgsql returns "fseek(-xxx) failed on DBF file." for large (>2GB) DBF files

[PostGIS]

#393: shp2pgsql returns "fseek(-xxx) failed on DBF file." for large (>2GB) DBF
files
-----------------------------------------------+----------------------------
 Reporter:  maximeguillaud                     |       Owner:  pramsey      
     Type:  defect                             |      Status:  new          
 Priority:  medium                             |   Milestone:  PostGIS 2.0.0
Component:  loader/dumper                      |     Version:  1.5.X        
 Keywords:  shp2pgsql fseek failed large file  |  
-----------------------------------------------+----------------------------

Comment(by dfuhry2):

 OSX is not a problem, since off_t and unsigned long are both 64bit
 integers on 32 bit Macs:
 $ uname -a && cat sizeof_types.c && gcc sizeof_types.c && ./a.out
 Darwin laptop 10.8.0 Darwin Kernel Version 10.8.0: Tue Jun  7 16:33:36 PDT
 2011; root:xnu-1504.15.3~1/RELEASE_I386 i386
 #include <stdio.h>
 int main(int argc, char **argv) { printf("sizeof(off_t): %lu,
 sizeof(unsigned long): %lu, sizeof(int): %lu\n", sizeof(off_t),
 sizeof(unsigned long), sizeof(int)); }

 32-bit Linux will still have the 2GB limitation against trunk, since off_t
 (by default, without _FILE_OFFSET_BITS=64) and unsigned long are both
 32bit integers:
 $ uname -a && cat sizeof_types.c && gcc sizeof_types.c && ./a.out
 Linux host 2.6.30-1-686 #1 SMP Sat Aug 15 19:11:58 UTC 2009 i686 GNU/Linux
 #include <stdio.h>
 int main(int argc, char **argv) { printf("sizeof(off_t): %lu,
 sizeof(unsigned long): %lu, sizeof(int): %lu\n", sizeof(off_t),
 sizeof(unsigned long), sizeof(int)); }
 sizeof(off_t): 4, sizeof(unsigned long): 4, sizeof(int): 4

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/393#comment:17>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.