Re: Execute vacuum

From: "Magnus Naeslund(t)" <mag(at)fbab(dot)net>
To: Carmen Gloria Sepulveda Dedes <csepulveda(at)atichile(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Execute vacuum
Date: 2003-11-21 17:16:03
Message-ID: 3FBE4853.2040802@fbab.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Carmen Gloria Sepulveda Dedes wrote:

> Hello!
>
> Can I execute VACUUM ANALYZE from ecpg?
>
> How I do that???
>
> /*
> I do: EXEC SQL VACUUM ANALYZE <table>;
> But I get error: 'ERROR: VACUUM cannot run inside a transaction block'
>
> */
>

Turn on/off autocommit maybe?
Or fake it with "EXEC SQL COMMIT; VACUUM ANALYZE" ? :)

Magnus

In response to

  • Execute vacuum at 2003-11-21 14:53:55 from Carmen Gloria Sepulveda Dedes

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-11-21 17:16:56 Re: Pg Dump error
Previous Message Mike Mascari 2003-11-21 17:08:27 Re: linking postgre to AD