Hugo wrote:
> hi everybody,
>
> Is it possible tu run vacuum from a plpgsql function ? I have a process that
> copies a lot of data from a csv file with the copy command and at the end of
> the function I would like to force a vacuun, is that possible.
I'm afraid not. VACUUM can't run inside a transaction block
(BEGIN..COMMIT) which is automatically the context you have if you are
inside a function.
--
Richard Huxton
Archonet Ltd