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