Is there a newer version of DBD::Pg?
Pg: 7.4.2
I use perl scripts to import data into my db. When errors occurred
uploading files in Pg ver 7.3.x, $DBI::errstr used to return a row number
from the input file. I could then go to the file make whatever changes and
continue. Since updating to 7.4.2, I no longer receive this information.
I now have to go to psql and run the import and only then will I see the
error row. Is there a newer version than 1.32 of DBD::Pg?
TIA
Patrick Hatcher
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
I use perl scripts to import data into my db. When errors occurred
uploading files in Pg ver 7.3.x, $DBI::errstr used to return a row number
from the input file. I could then go to the file make whatever changes and
continue. Since updating to 7.4.2, I no longer receive this information.
I now have to go to psql and run the import and only then will I see the
error row. Is there a newer version than 1.32 of DBD::Pg?
1.32 is the latest version. If you could provide a sample script that
shows the error you are getting, that would be great. Also, you may be
interested in the DBD::Pg mailing list. Information on the list can
be found at:
http://gborg.postgresql.org/mailman/listinfo/dbdpg-general
- --
Greg Sabino Mullane greg@turnstep.com
PGP Key: 0x14964AC8 200404211802
-----BEGIN PGP SIGNATURE-----
iD8DBQFAhu+TvJuQZxSWSsgRAlfDAKC86kpKIdj9URwK5DLtVevs/LVqlwCeLFmd
iALGzPwV5mseJkPiok8Jflk=
=4rss
-----END PGP SIGNATURE-----
"GSM" == Greg Sabino Mullane <greg@turnstep.com> writes:
I use perl scripts to import data into my db. When errors occurred
uploading files in Pg ver 7.3.x, $DBI::errstr used to return a row number
from the input file. I could then go to the file make whatever changes and
GSM> 1.32 is the latest version. If you could provide a sample script that
GSM> shows the error you are getting, that would be great. Also, you may be
GSM> interested in the DBD::Pg mailing list. Information on the list can
GSM> be found at:
My experience has been that the 1.3x line of DBD::Pg is just plain
broken. On one server running under mod_perl, all placeholder
substituted values were NULL by the time they reached postgres. I've
had other issues with the quote() method returning undef.
Unfortunately those bugs were "not reproduced" even with the full test
cases by the devlopment team.
For my money I'm sticking with DBD::Pg 1.22 since it is completely
stable for me.
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D. Khera Communications, Inc.
Internet: khera@kciLink.com Rockville, MD +1-301-869-4449 x806
AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/