Re: vacuum with perl dbi / pg 7.1.3

From: Aaron Couts <spam(at)couts(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: vacuum with perl dbi / pg 7.1.3
Date: 2002-03-08 15:15:24
Message-ID: slrna8hm70.v8b.spam@rincon.couts.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

In article <slrna8fv6o(dot)off(dot)spam(at)rincon(dot)couts(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Self 2002-03-08 15:47:02 Re: PostgreSQL for PS/2 ?
Previous Message mdb 2002-03-08 14:45:48 Re: Temp Tables