Thread: vacuum with perl dbi / pg 7.1.3

Does anyone know how to perform a vacuum command using Perl DBI and PostgreSQL
7.1.3?  I've tried various ways of doing it, but I always get "DBD::Pg::db do
failed: ERROR:  VACUUM cannot run inside a BEGIN/END block."  My program isn't
using BEGIN/END blocks, so I assume there's a Perl or DBI/DBD::Pg internal
detail that I'm not aware of.

Thanks,
Aaron

--
To contact me via email, substitute
'aaron' for 'spam' in my address.

In article <slrna8fv6o.off.spam@rincon.couts.org>, Aaron Couts wrote:
> Does anyone know how to perform a vacuum command using Perl DBI and PostgreSQL
> 7.1.3?  I've tried various ways of doing it, but I always get "DBD::Pg::db do
> failed: ERROR:  VACUUM cannot run inside a BEGIN/END block."  My program isn't
> using BEGIN/END blocks, so I assume there's a Perl or DBI/DBD::Pg internal
> detail that I'm not aware of.

Autocommit must be ON.

--
To contact me via email, substitute
'aaron' for 'spam' in my address.

Aaron Couts <spam@couts.org> writes:

> Does anyone know how to perform a vacuum command using Perl DBI and
> PostgreSQL 7.1.3?  I've tried various ways of doing it, but I always
> get "DBD::Pg::db do failed: ERROR: VACUUM cannot run inside a
> BEGIN/END block."  My program isn't using BEGIN/END blocks, so I
> assume there's a Perl or DBI/DBD::Pg internal detail that I'm not
> aware of.

What is your 'autocommit' setting on the DBI connection?

-Doug
--
Doug McNaught       Wireboard Industries      http://www.wireboard.com/

      Custom software development, systems and network consulting.
      Java PostgreSQL Enhydra Python Zope Perl Apache Linux BSD...