perl dbd libraries keeping transactions open? - Mailing list pgsql-interfaces

From Adam Haberlach
Subject perl dbd libraries keeping transactions open?
Date
Msg-id 20030225104638.A7643@newsnipple.com
Whole thread Raw
Responses Re: perl dbd libraries keeping transactions open?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-interfaces
    I'm not sure if this is the right place, but I've got
a question and potential issue.
We've got a system consisting of several daemons written
in perl and a web interface, and we are having issues with
the nightly vacuums not doing anything.  It seems that this
is happening because there is always a transaction held open
by the libraries.
It seems that the implementation is for the libs to
do a BEGIN on connect and after every transaction -- is
this normal.  Is there a way to keep it from causing
problems with vaccuums?
If this isn't the right place, or if anyone knows a
better place to ask this, let me know...

-- 
Adam Haberlach         | "Because manholes are round."
adam@mediariffic.com   |
http://mediariffic.com |


pgsql-interfaces by date:

Previous
From: ash
Date:
Subject: Darwin libpq link failing
Next
From: Tom Lane
Date:
Subject: Re: Darwin libpq link failing