title: Show progress of very long postgres procedure (transmit data out of transaction before it ends up)
body: <p>I tried to create tables, but it was useless because each begin-end block wrapped in transaction in postgres, so I can't see any changes before the end of transaction.
  The only solution is rising INFO, I use it to show current step of procedure, but its not exactly what I am looking for. I need to know detailed data of current calculations, because every step can take a few hours. 
  Please suggest me the way to transmit data out of transaction before it ends up.</p>
  
  <p>UPD: I've found the way to transmit progress: I can increase sequences from within my procedure, and  read them from other connection. <a href="http://blog.endpoint.com/2010/04/viewing-postgres-function-progress-from.html" rel="nofollow">http://blog.endpoint.com/2010/04/viewing-postgres-function-progress-from.html</a></p>