Re: [GENERAL] run vacuum from within a function

2005-11-11 Thread Richard Huxton
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 transacti

[GENERAL] run vacuum from within a function

2005-11-10 Thread Hugo
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