MIME-Version: | 1.0 |
X-Mailer: | MIME-tools 5.405 (Entity 5.404) |
Subject: | elimination of AutoCommit warning |
Content-Type: | multipart/mixed; boundary="----------=_1040057068-27394-0" |
Content-Length: | 0 |
Content-Type: | text/plain |
Content-Disposition: | inline |
Content-Transfer-Encoding: | binary |
X-RT-Original-Encoding: | iso-8859-1 |
Content-Length: | 508 |
Apache::Session 1.54
perl: 5.8.0 or 5.6.1
uname -a: Linux wasabi.rp.lan 2.4.7-10smp #1 SMP Thu Sep 6 17:09:31 EDT 2001 i686 unknown (but will affect all o/s)
Apache::Session::Store::Postgres.pm assumes that the $dbh created has AutoCommit to Off and therefore blithely calls {$self->{dbh}->commit without checking for AutoCommit which triggers the warning:
commit ineffective with AutoCommit enabled at /opt/projects/sitegroup/oxford/5.8.0/Apache/Session/Store/Postgres.pm line 93.
patch supplied
Marcus
Content-Type: | application/octet-stream; name="Postgres.pm.patch" |
Content-Disposition: | inline; filename="Postgres.pm.patch" |
Content-Transfer-Encoding: | base64 |
Content-Length: | 303 |
--- Postgres.pm 2002-12-16 16:26:41.000000000 +0000
+++ Postgres.pm.modified 2002-12-16 16:33:02.000000000 +0000
@@ -89,7 +89,7 @@
sub DESTROY {
my $self = shift;
- if ($self->{commit}) {
+ if ($self->{commit} && ! $self->{dbh}->{AutoCommit}) {
$self->{dbh}->commit;
}