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
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
