Re: vacuum with perl dbi / pg 7.1.3

Поиск
Список
Период
Сортировка
От Doug McNaught
Тема Re: vacuum with perl dbi / pg 7.1.3
Дата
Msg-id m3lmcwtr12.fsf@varsoon.denali.to
обсуждение исходный текст
Ответ на vacuum with perl dbi / pg 7.1.3  (Aaron Couts <spam@couts.org>)
Список pgsql-general
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...

В списке pgsql-general по дате отправления:

Предыдущее
От: Doug McNaught
Дата:
Сообщение: Re: Export a database or a table from a database
Следующее
От: Doug McNaught
Дата:
Сообщение: Re: indices