473,320 Members | 1,914 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

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

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 23 '05 #1
4 1354

-----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/.../dbdpg-general

- --
Greg Sabino Mullane gr**@turnstep.com
PGP Key: 0x14964AC8 200404211802

-----BEGIN PGP SIGNATURE-----

iD8DBQFAhu+TvJuQZxSWSsgRAlfDAKC86kpKIdj9URwK5DLtVe vs/LVqlwCeLFmd
iALGzPwV5mseJkPiok8Jflk=
=4rss
-----END PGP SIGNATURE-----

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 23 '05 #2

-----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/.../dbdpg-general

- --
Greg Sabino Mullane gr**@turnstep.com
PGP Key: 0x14964AC8 200404211802

-----BEGIN PGP SIGNATURE-----

iD8DBQFAhu+TvJuQZxSWSsgRAlfDAKC86kpKIdj9URwK5DLtVe vs/LVqlwCeLFmd
iALGzPwV5mseJkPiok8Jflk=
=4rss
-----END PGP SIGNATURE-----

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 23 '05 #3
>>>>> "GSM" == Greg Sabino Mullane <gr**@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: kh***@kciLink.com Rockville, MD +1-301-869-4449 x806
AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

Nov 23 '05 #4
>>>>> "GSM" == Greg Sabino Mullane <gr**@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: kh***@kciLink.com Rockville, MD +1-301-869-4449 x806
AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

Nov 23 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Pablo S | last post by:
Hi there mod_perl/Pg folks, I have 2 systems, one OLD, (linux 2.4 running postgresql-7.2.1-5 with a perl web db on Apache/1.3.23 mod_perl 1.26 and dbi 1.37 with peristent db connections via...
1
by: Tim Nelson | last post by:
**** Post for FREE via your newsreader at post.usenet.com **** I am a newbie try to port my applications to Postgres. I have an application that is bulk loading a table with autocommit off (with...
0
by: Piotr B. | last post by:
Hello, I want to make use of a Perl script "ora2pg" (Oracle to PostgreSQL schema converter), which requires the following modules: DBI, DBD::Oracle and DBD::Pg. As I don't use Perl on a...
0
by: Envex Developments | last post by:
Hey guys, I have a need to install the DBD::Pg Perl module on many shared web servers, which do not have PostgreSQL installed. Then the DBD::Pg module will just connect to a remote PostgreSQL...
0
by: Envex Developments | last post by:
Hey guys, I have a need to install the DBD::Pg Perl module on many shared web servers, which do not have PostgreSQL installed. Then the DBD::Pg module will just connect to a remote PostgreSQL...
0
by: Alex | last post by:
Hi, I am using DBD::Pg in some of my scripts. I want to customize the error login based on the error received. While I am happy with the Errstr message I want to take specific actions depending...
10
by: Ausrack Webmaster | last post by:
Hi I am trying to insert a simple email address into a text field, and I get the below error: DBD::Pg::st execute failed: ERROR: pg_atoi: error in "<support@somedomain.com>": can't parse...
11
by: greg | last post by:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 A new version of DBD::Pg is about to be released (1.32), and we need your help to test it out. If you use DBD::Pg, please download and test the...
2
by: David Siebert | last post by:
Anyone using Activestate Perl and DBD-Pg? I am using perl 5.8.3 ppm does not seem to work. I downloaded the DBD-Pg ..zip file I found through google but ppm could not seem to install that. Any...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.