Re: strange behavior on 8.1 - Mailing list pgsql-general

Csaba Nagy <nagy@ecircle-ag.com> writes:
> Ok, I found a fix which works for me: don't use ON COMMIT DELETE ROWS on
> the temporary tables, but explicitly delete the rows once processed.
> However, I think it should work with ON COMMIT DELETE ROWS too, and it
> works fine indeed in 8.0.3.

I found the bug, and indeed ON COMMIT DELETE ROWS is the only case where
there's a significant chance of observing a problem.  Thanks for the
report!

            regards, tom lane