"Steven Flatt" <steven(dot)flatt(at)gmail(dot)com> 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