@Philip: You were correct. Thanks for the advice; I'm new to Perl, and I
didn't realize that wasn't correct. After changing it as you suggested, the
program seems to work. Again, thanks.
@Martin: I'll take a look around the system I'm working with and see if I can
figure out where the
To: Martin Gainty
Cc: DBI Users Mailing List
Sent: Thursday, March 01, 2007 12:13 AM
Subject: Re: Perl-Postgres connection: 'Commit' method not found in DBI.
Advice?
On 2/28/07, Martin Gainty [EMAIL PROTECTED] wrote:
yep--
Aparently postgres thinks its smarter than anyone
It looks like you're calling commit() on the $sth instead of the $dbh.
Philip
Andrew Edson wrote:
I am working with a perl file intended to enter a postgresql database
(as user postgres), select a list of key values based on one of those
values and delete any records which match the returned
Please post some code, it seems like there is something wrong in
purge_acnt. Line 242 and a few lines before and after should be
interesting, and the lines around DBI-connect.
Alexander
On 28.02.2007 16:50, Andrew Edson wrote:
I am working with a perl file intended to enter a postgresql
Message -
From: Alexander Foken [EMAIL PROTECTED]
To: Andrew Edson [EMAIL PROTECTED]
Cc: dbi-users@perl.org
Sent: Wednesday, February 28, 2007 11:55 AM
Subject: Re: Perl-Postgres connection: 'Commit' method not found in DBI. Advice?
Please post some code, it seems like there is something wrong
, February 28, 2007 6:12 PM
To: Alexander Foken; Andrew Edson
Cc: dbi-users@perl.org
Subject: Re: Perl-Postgres connection: 'Commit' method not found in DBI. Advice?
yep--
Aparently postgres thinks its smarter than anyone that wants to use it and has
Auto-commit ALWAYS turned on
If you find a way
Foken [EMAIL PROTECTED];
Andrew Edson [EMAIL PROTECTED]
Cc: dbi-users@perl.org
Sent: Wednesday, February 28, 2007 8:21 PM
Subject: RE: Perl-Postgres connection: 'Commit' method not found in DBI. Advice?
Isn't AutoCommit turned off at the database handle level?
DBI-connect('dbi:xxx:', uid, pwd
On 2/28/07, Martin Gainty [EMAIL PROTECTED] wrote:
yep--
Aparently postgres thinks its smarter than anyone that wants to use it and
has Auto-commit ALWAYS turned on
If you find a way to turn this *feature* off let me know because it is
massively counter intuitive to normal operation of any