title: bulk/multiple queries that take a long time never finish in Postgres
body: <p>I have created a function in postgres that inserts data into a table. The function receives a string and enters the value into a table after processing it. What I want is to be able to call the function numerous times in pgAdmin instead of running them in batches.</p>
  
  <p>Example:
  in pgAdmin i open up my sql query window and type</p>
  
  <pre><code>select customfunction('string1');
  select customfunction('string2');
             ^
             .
             .
             .
             .
             v
  select customfunction('string100000000');
  </code></pre>
  
  <p>When I try to run this it only works when I run about 6000 lines (6000 functions). If i cancel it while it is running it doesnt commit anything (not even the first line). I have to keep cutting them into batches to complete the entire query. How can I achieve this without running them in batches.</p>
  
  <p>I want to copy and paste the whole query and wait till everything is done. Right now the query just runs with no response indefinitely if i run over 10000 lines in a batch. Is there a way postgres can commit each line once it runs that line?</p>
  
  <p>I would also like to know if anyone can determine exactly what line is being processed  while the query is running.</p>