Re: dbf2pg improvements (password, charset convertions,etc.)

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(at)candle(dot)pha(dot)pa(dot)us>
> > To: ivan(at)pilasnet(dot)com
> > CC: pgsql-patches(at)postgresql(dot)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(at)servidor(dot)pilasnet(dot)com(dot)uy>
> > > Asunto: [Fwd: dbf2pg improvements (password, charset convertions, etc.)]
> > > Para: boekhold(at)tibco(dot)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(at)servidor(dot)pilasnet(dot)com(dot)uy>
> > > Asunto: dbf2pg improvements (password, charset convertions, etc.)
> > > Para: boekhold(at)cindy(dot)et(dot)tudelft(dot)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(at)postgresql(dot)org so that your
> > > message can get through to the mailing list cleanly
> >
> > --
> > Bruce Momjian | http://candle.pha.pa.us
> > pgman(at)candle(dot)pha(dot)pa(dot)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(at)postgresql(dot)org

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