| From: | Doug McNaught <doug(at)wireboard(dot)com> |
|---|---|
| To: | spam(at)couts(dot)org |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: vacuum with perl dbi / pg 7.1.3 |
| Date: | 2002-03-13 15:40:25 |
| Message-ID: | m3lmcwtr12.fsf@varsoon.denali.to |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Aaron Couts <spam(at)couts(dot)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...
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-03-13 15:41:49 | Re: index on large table |
| Previous Message | Jacob Vennervald Madsen | 2002-03-13 15:39:14 | Re: Modifying text data? |