Re: How do I get the database connections to close down?

From: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>
To: Marcus Claesson <marcus(at)chah(dot)ucc(dot)ie>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: How do I get the database connections to close down?
Date: 2003-02-19 13:36:19
Message-ID: 1045661779.1253.63.camel@linda.lfix.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 2003-02-19 at 11:27, Marcus Claesson wrote:
> I'm using Perl dbi:Pg (as well as DBIx::Recordet) in a CGI script where
> the users connect to my database through the web. The problem is that the
> database connections won't close down and I end up with an increasing
> number of these when 'ps-ef|grep postgres':

> $set -> Disconnect ();

I think that should be

$set -> disconnect ();

Perl is case sensititive, isn't it?

--
Oliver Elphick Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight, UK http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"And the angel answered and said unto the women, Fear
ye not; for I know that ye seek Jesus, who was
crucified. He is not here; for he is risen, as he
said...Therefore be ye also ready; for in such an hour
as ye think not the Son of man cometh."
Matthew 28:5,6; 24:44

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mario Weilguni 2003-02-19 13:38:53 Re: SQL query...
Previous Message Martijn van Oosterhout 2003-02-19 12:11:29 Re: 7.3.1 takes long time to vacuum table?