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