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
