Hi Tom,

Thanks! That's exactly what it was. There was a discrepancy in the data that turned this into an endless loop. Everything has been running smoothly since I made a change.

Thanks so much,

On Apr 23, 2005, at 12:50 PM, Tom Lane wrote:

Richard Plotkin <[EMAIL PROTECTED]> writes:
Thanks for your responses this morning.  I did the select relname, and
it returned 0 rows.  I do have one function that creates a temp table
and fills it within the same transaction.  I'm pasting it below.
Perhaps the "ON COMMIT DROP" is causing problems, and I need to drop
the table at the end of the function instead of using ON COMMIT DROP?

Well, I think we can conclude that the function is pushing way more
data into the temp table than you expect. I am wondering if that loop
in the middle of the function is turning into an infinite loop --- could
it be finding some sort of cycle in your page data? You might want to
add some RAISE NOTICE commands to the loop so you can track what it's

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
     subscribe-nomail command to [EMAIL PROTECTED] so that your
     message can get through to the mailing list cleanly

Reply via email to