Обсуждение: Re: dbf2pg improvements (password, charset convertions,etc.)
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
Вложения
Yep, I got it, and it is sitting in the "Outstanding Patches" page at:
http://candle.pha.pa.us/cgi-bin/pgpatches
I will add this one there too.
> 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
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
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