Re: dbf2pg improvements (password, charset convertions,etc.) - Mailing list pgsql-patches
From | Bruce Momjian |
---|---|
Subject | Re: dbf2pg improvements (password, charset convertions,etc.) |
Date | |
Msg-id | 200105101535.f4AFZdd28094@candle.pha.pa.us Whole thread Raw |
In response to | Re: dbf2pg improvements (password, charset convertions,etc.) (Ivan Baldo <ivan@pilasnet.com>) |
List | pgsql-patches |
I have added dbf2pg into the official PostgreSQL CVS tree under /contrib/dbase. It will appear in 7.2. I removed the ivan.txt file, created a new Makefile, and updated a few things. Thanks. > 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... ] -- 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
pgsql-patches by date: