BUG #1643: dbf2pg broken + quick fix

From: "Boris van Schooten" <schooten(at)cs(dot)utwente(dot)nl>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1643: dbf2pg broken + quick fix
Date: 2005-05-03 17:44:04
Message-ID: 20050503174404.B3508F0B09@svr2.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


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.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message tirny 2005-05-03 18:56:59 BUG #1644: control structeres perfomance in pgsql
Previous Message Joek Hondius 2005-05-03 09:25:20 BUG #1641: Server crash at 182 connections