Re: BUG #1643: dbf2pg broken + quick fix - Mailing list pgsql-bugs

From Boris van Schooten
Subject Re: BUG #1643: dbf2pg broken + quick fix
Date
Msg-id Pine.SOL.4.33.0505051123190.16840-100000@demeter
Whole thread Raw
In response to Re: BUG #1643: dbf2pg broken + quick fix  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: BUG #1643: dbf2pg broken + quick fix
List pgsql-bugs
Looks good to me.  I'd prefer to have a warning message (if (verbose)
fprintf stderr) for each of the exceptional conditions though.  I'm even
so paranoid I prefer to have the verbose switch on by default.

Kinds regards,
Boris van Schooten

On Wed, 4 May 2005, Tom Lane wrote:

> Boris van Schooten <schooten@cs.utwente.nl> writes:
> > Don't know anything about nulls in dbf though.  I am not a dbase expert, I
> > just run into dbfs often when trying to enter gis data into postgis.
>
> I'm considering the following patch, which turns around the test: check
> for an empty string and if so believe it's a null, otherwise just insert
> the value as-is.  I dunno if the check for null is actually meaningful,
> but I doubt this will break any cases that worked before.  Comments anyone?
>
>             regards, tom lane

pgsql-bugs by date:

Previous
From: "Nicholas Vinen"
Date:
Subject: BUG #1648: ISO Year ignores time zone?
Next
From: Tom Lane
Date:
Subject: Re: BUG #1643: dbf2pg broken + quick fix