Re: Execute vacuum - Mailing list pgsql-general

From Carmen Gloria Sepulveda Dedes
Subject Re: Execute vacuum
Date
Msg-id 3FBE77A1.5187DBA@atichile.com
Whole thread Raw
In response to Execute vacuum  (Carmen Gloria Sepulveda Dedes <csepulveda@atichile.com>)
List 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???


pgsql-general by date:

Previous
From: "Thomas LeBlanc"
Date:
Subject: Foreign Keys
Next
From: Ben
Date:
Subject: Re: Foreign Keys