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

From Tom Lane
Subject Re: BUG #1643: dbf2pg broken + quick fix
Date
Msg-id 13952.1115175318@sss.pgh.pa.us
Whole thread Raw
In response to BUG #1643: dbf2pg broken + quick fix  ("Boris van Schooten" <schooten@cs.utwente.nl>)
List pgsql-bugs
Boris van Schooten <schooten@cs.utwente.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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #1644: control structeres perfomance in pgsql
Next
From: "Kjh"
Date:
Subject: BUG #1646: ERROR: column "mycolumn" is of type boolean but expression is of type character