"Steven Flatt" <steven.flatt@xxxxxxxxx> writes: > I can't reproduce the problem that way either (or when using a server-side > PLpgSQL function to do similar). It looks like you have to go through an > ODBC connection, with the looping done on the client side. Each individual > insert to the temp table needs to be sent over the connection and this is > what degrades over time. I can reproduce on 7.4.6 and 8.1.4. I have a > small C program to do this which I can send you offline if you're > interested. Please. regards, tom lane
