Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

BUG #1643: dbf2pg broken + quick fix



The following bug has been logged online:

Bug reference:      1643
Logged by:          Boris van Schooten
Email address:      schooten(at)cs(dot)utwente(dot)nl
PostgreSQL version: 7.4.5, 8.0.2
Operating system:   FreeBSD
Description:        dbf2pg broken + quick fix
Details: 

As several people on the mailing lists have already noted, dbf2pg is broken.
 It usually fails to enter the numeric values from the dbf file in the sql
tables.  If you enable verbose output (-vv) you see "Illegal numeric value
found" errors.  

As it turns out, the integer checking code (contrib/dbase/dbf2pg.c, function
isinteger) is broken.  It appears the function reports 0 in case it finds a
space in the dbf rather than a digit.  I disabled it (always made it return
1).  Now, my dbf files import fine.



Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group