on 9/29/05 6:38 AM, rwp@xxxxxxxxxxx purportedly said:
> Any ideas please? This seems well weird to me, but...
Assuming the code snippet is representative, a couple things:
1. $dbh->prepare($stmt)->execute () || die;
This is mostly a point of protocol, but I can't resist pointing it out.
Although the above syntax works, it is not precisely correct. You should
instead:
$dbh->do($stmt) || die;
2. my $rv=$sth->execute() || die;
You should always finish() every "select" statement handle, or both DBI and
libpq will leak:
$sth->finish;
after the closing bracket of the while() loop.
Best,
Keary Suska
Esoteritech, Inc.
"Demystifying technology for your home or business"
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
