Willem Buitendyk <willem@pcfish.ca> writes:
> The problem was with the following:
> FOR current_row IN SELECT * from temp_tags_18_counted
> The select from the [temp_tags_18_counted] view is made up of 3 cross
> joins. When I simplify and remove the joins everything works. I tried
> this with some test data with only a few rows and the joins in place and
> it works too.
> In the production data table there are about 250K rows. Is it possible
> that calls to queries are colliding here or not giving each other enough
> time before being whisked around to next call in the FOR loop?
No. Please provide a test case instead of speculating. And, again,
what is the PG version?
regards, tom lane