[GENERAL] Re: [webmaster] How to commit/vacuum a batch of delete statements in a postgresql function

[Nava Jyothi]

*Hi PostGresSQL TeamCould you advise us on how to commit records in a batch
when one is doing batch wise deletion*. I came across
http://www.postgresql.org/message-id/60644bymua....@dba2.int.libertyrms.com,
but use of vacuum is giving an error as follows from function.





*********** Error **********ERROR: VACUUM cannot be executed from a
function or multi-command stringSQL state: 25001*My stored procedure is of
the format:


*Loop   exit when <some condition>
  DELETE from incoming_table where xyz='123';
  VACUUM incoming_table; -- or commit;
End Loop;*


I thank you for the help.

-Nava