Re: contrib dbf2sql.pl - Mailing list pgsql-patches

From Manuel Baena García
Subject Re: contrib dbf2sql.pl
Date
Msg-id 1112235651.31089.21.camel@localhost.localdomain
Whole thread Raw
In response to Re: contrib dbf2sql.pl  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-patches
Your current code is caused to fail by the next inputs:
- when the data has null number values.

You can probe it with the examples in:
http://www.clicketyclick.dk/databases/xbase/index.shtml.en

Now I have a new version of dbf2sql with some bug fixed:
     - Support MEMO fields.
     - Support Float Point fields.
     - Exclude deleted records.
     - Replace ' with \' in strings.
     - do all inserts in one transaction.

And my script support all examples of above url.

My program fixes that the current one does not.


El lun, 28-03-2005 a las 00:06 -0500, Bruce Momjian escribió:
> Manuel Baena Garca wrote:
> > El mi?, 23-03-2005 a las 17:07 -0500, Bruce Momjian escribi?:
> > > Are you saying your script has all the functionality of dbf2pg.c?  It
> > > doesn't seem possible.
> >
> > No, I'm not saying it. By example, my script doesn't connect to a pg db,
> > I prefer to use a pipe. My script has the same objective by a different
> > way: "do it as simple as you can".
>
> It might be simple to code, but having a second program is not simpler
> for end-users.  We have had no one else complain about xbase conversion
> so I am not inclined to add a second program, especially since you did
> not say what your program fixes that the current one does not.
>
> Can you show us exactly what input causes our current code to fail, and
> explain why someone with C knowledge can't fix it?
>

Attachment

pgsql-patches by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: (Continued) Updated Turkish translations
Next
From: Dirk Raetzel
Date:
Subject: Re: [BUGS] BUG #1563: wrong week returnded by date_trunc('week',