Hi, thanks for the tips. But I don't seem to be able to locally override
the value of AutoCommit for one handle (I only need to use AutoCommit for
one script!). If I follow the instructions on the URL you pointed me to,
and do something like:
my $dbh = DBI-connect (dbi:Pg:dbname=hello,
On Wed, 16 Oct 2002, Kirk Bowe wrote:
my $dbh = DBI-connect (dbi:Pg:dbname=hello, postgres, foo);
my %orig = ();
my @attrs = qw(AutoCommit RaiseError);
$orig{$_} = $dbh-{$_} for @attrs;
$dbh-{AutoCommit} = 0; $dbh-{RaiseError} = 1;
When I later do the $dbh-commit, it fails with this
I'm using Apache::DBI connecting to a Postgres db. I'm using Template
Toolkit but no explicit db calls from within the templates -- they're all
done within the perl modules.
Unfortunately after a couple of hours of moderate use Postgres reaches its
max_clients level (which is set below max
.--[ Kirk Bowe wrote (2002/10/15 at 20:40:15) ]--
|
| I'm using Apache::DBI connecting to a Postgres db. I'm using Template
| Toolkit but no explicit db calls from within the templates -- they're all
| done within the perl modules.
|
| Unfortunately after a couple of hours
Kirk Bowe wrote:
Unfortunately after a couple of hours of moderate use Postgres reaches its
max_clients level (which is set below max httpds in httpd.conf)
This is usually caused by mistakes in your connection calls where they
have slightly different connect info resulting in multiple