Thread: run vacuum from within a function

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.

thanks in advance

Hugo

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