Gregory Stark <[EMAIL PROTECTED]> writes: > Tom Lane <[EMAIL PROTECTED]> writes: >> The real question is why does the subtransaction actually assign itself >> an XID --- a simple RETURN NEXT operation ought not do that, AFAICS.
> I suspect the answer to that is the same as the answer to what's actually > creating the subtransaction. plperl_return_next doesn't. I think something > must be doing an actual SPI query, not just a return next. The other question on the table is why it didn't respond to QueryCancel in a reasonable amount of time. I'd really like to see a complete test case for this problem ... regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match