Re: Execute vacuum

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

> > 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" ? :)

Y try with that, but it doesn't work.

Any idea???

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ben 2003-11-21 20:47:45 Re: Foreign Keys
Previous Message Thomas LeBlanc 2003-11-21 20:35:54 Foreign Keys