Re: dbf2pg improvements (password, charset convertions,etc.) - Mailing list pgsql-patches

I will keep this and apply to 7.2 soon.

>     Hello.
>
> > -------- Original Message --------
> > Subject: Re: [PATCHES] [Fwd: dbf2pg improvements (password, charset
> > convertions,etc.)]
> > Date: Thu, 3 May 2001 15:17:01 -0400 (EDT)
> > From: Bruce Momjian <pgman@candle.pha.pa.us>
> > To: ivan@pilasnet.com
> > CC: pgsql-patches@postgresql.org
> >
> > Well, if you contacted the author and didn't get a reply, you can send
> > them over here and we can include them in 7.2.
>     I tried to contact the author but in one case the server didn't exist,
> then tried another address and it said that there was a problem with
> relaying, etc..
>     So, it is not that the author didn't reply, it is just that it didn't
> received the email... I hope it agrees with my changes.
>     Well, I have sent a tarball and a patch last time, but it seems that
> you didn't notice.
>     Now I am attaching a tarball with a little fix regarding dates.
>     You can upload that tarball as it is or maybe removing the "_ivan"
> filename part, that depends if you want to have a version alongside the
> original version or replacing the 3.0 version with this new version.
>     Thanks very much and I hope this new version proves usefull to others,
> now lets go and convert that old .DBF based databases to PostgreSQL!
>
>
> > >       Hello.
> > >       Well, I cannot contact the original author so I send this here as my
> > > last resort.
> > >       This is regarding a program you distribute in the "contrib" directory
> > > of your FTP server, the program is called "dbf2pg".
> > >       I have made some usefull changes that I want to share, see the rest of
> > > the email for more information.
> > >       Please, tell me if I have to do anything else to update that program,
> > > especially if this is not the correct place to send this email (and if
> > > so, sorry!, I am trying to help), any other comments are appreciated.
> > >       Take in account that I am not subscribed to this mailing list, so
> > > please send me a copy of the emails!
> > >       Thanks and goodbye.
> > >
> > > -------- Original Message --------
> > > De: Ivan Baldo <ivan@servidor.pilasnet.com.uy>
> > > Asunto: [Fwd: dbf2pg improvements (password, charset convertions, etc.)]
> > > Para: boekhold@tibco.com
> > >
> > >       Hello.
> > >       I sent you an email to your old account and it bounced, I hope this is
> > > your new email address.
> > > P.s.: dbf2pg should have your new email address and possibly a list of
> > > changes, also the manpage points to an old version (2.0).
> > > P.s.2: if you accept the changes, PostgreSQL people should get the new
> > > version, and btw., where is the official location for this program?
> > >
> > > -------- Original Message --------
> > > De: Ivan Baldo <ivan@servidor.pilasnet.com.uy>
> > > Asunto: dbf2pg improvements (password, charset convertions, etc.)
> > > Para: boekhold@cindy.et.tudelft.nl
> > >
> > >       Hello.
> > >       First of all, thanks for dbf2pg!!!
> > >       We will start to use it here soon.
> > >       I taken it from the Postgres site, in a "contrib" directory somewhere,
> > > it had version 3.0.
> > >       I am sending you a traball of my version of the full source and a patch
> > > with the differences.
> > >       You can see that there is in it an "ivan.txt" file, you can delete this
> > > file, it is just for your (and my own) information.
> > >       For your convenience, here is a bit of that file:
> > >
> > > SUMMARY OF CHANGES:
> > > - dbf2pg.c::isinteger()
> > >         - tried to optimize it.
> > > - dbf2pg.c::usage()
> > >         - cosmetic changes, some options added.
> > > - dbf2pg.c::main()
> > >         - support for '-W' flag for asking user password.
> > >         - support for '-U username' flag to specify user name.
> > > - dbf2pg.c::do_inserts()
> > >         - if the user didn't specify a transaction block size, then set
> > > it to be
> > >           all the records.
> > > - dbf2pg.c
> > >         - fixed handling of date, also, there's no need for '-a' option
> > > anymore.
> > >         - support for charset conversion through options '-F
> > > charset_from' and
> > >           '-T charset_to', using standard Unix "iconv" support.
> > > - dbf2pg.1
> > >         - removed references to msql.
> > >         - updated a bit (should be checked since I am not a manpage
> > > expert).
> > >
> > > MISC NOTES:
> > > - behaviour regarding errors, warnings and informations should be
> > > normalized,
> > >   I suggest stderr for errors and stdout for anything else.
> > >
> > > -- END OF ivan.txt --
> > >
> > >       If you are not the correct person to contact, please, tell me who can I
> > > contact or what can I do then, since this changes could be usefull for
> > > the world and it is good to share them.
> > >
> > >       Well, I will wait for your reply, goodbye!
> > > P.s.: I have tested this on SuSE Linux 7.0 only, should be tested on
> > > more platforms!
> >
> > [ application/x-gzip is not supported, skipping... ]
> >
> > [ application/x-gzip is not supported, skipping... ]
> >
> > >
> > > ---------------------------(end of broadcast)---------------------------
> > > TIP 3: if posting/reading through Usenet, please send an appropriate
> > > subscribe-nomail command to majordomo@postgresql.org so that your
> > > message can get through to the mailing list cleanly
> >
> > --
> >   Bruce Momjian                        |  http://candle.pha.pa.us
> >   pgman@candle.pha.pa.us               |  (610) 853-3000
> >   +  If your life is a hard drive,     |  830 Blythe Avenue
> >   +  Christ can be your backup.        |  Drexel Hill, Pennsylvania
> > 19026

[ application/x-gzip is not supported, skipping... ]

>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026