Re: BUG #1643: dbf2pg broken + quick fix

From: Boris van Schooten <schooten(at)cs(dot)utwente(dot)nl>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #1643: dbf2pg broken + quick fix
Date: 2005-05-04 09:40:19
Message-ID: Pine.SOL.4.33.0505041115100.3997-100000@demeter
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

I can't find anything about dbase nulls either. Never seen one. I'll
report it when I find nulls (or other bugs in the code). I'm using some
5-10 different db formats, and noticed most of the converters need some
work (as usual).

The isinteger seems to be made to do double duty, but it doesn't exactly
do it well. The code is dated +/-1995, and the version number is unclear,
but I noticed there have been recent changes. Maybe cvs will give more
info?

Tell me when you got your patch ready, then I'll test the newest version.

There was this funny thing with the bug report form on the postgres site.
I got mails which suggest that the message bounced. Later I sent a mail to
Bruce Momjian. I never knew if you replied to the bug report or to the
mail to Bruce. Do you know what happened here? Do bug reports get
bounced?

Kind regards,
Boris van Schooten

On Tue, 3 May 2005, Tom Lane wrote:

> Boris van Schooten <schooten(at)cs(dot)utwente(dot)nl> writes:
> > See the spec.
>
> > http://www.dbase.com/KnowledgeBase/int/db7_file_fmt.htm
>
> Thanks for the link. As far as can be told from this, dbase hasn't got
> nulls at all -- is that correct, or are they just omitting a ton of
> relevant information?
>
> It looks to me like we should just remove the special case for integer
> fields altogether. The special case for date fields is wrong in detail
> as well: as coded it will accept "date" fields with a leading sign,
> which surely is not intentional.
>
> regards, tom lane
>

Browse pgsql-bugs by date

  From Date Subject
Next Message Kjh 2005-05-04 12:18:30 BUG #1646: ERROR: column "mycolumn" is of type boolean but expression is of type character
Previous Message Sokolov Yura 2005-05-04 08:58:36 BUG 1614 and BUG 1616 : Inadequate GIST Behaviour