title: COMMIT in PostgreSQL stored procedure
body: <p>I have a PostgreSQL stored procedure which loops over a very large list, and makes changes to some of its members using <code>UPDATE</code>.</p>
  
  <p>Is there a way to commit these changes per iteration, not at the end of the function execution? It would allow me to run the function for shorts periods of time, making small changes at each run.</p>
  
  <p>Thanks,</p>
  
  <p>Adam</p>