Simon Riggs <[EMAIL PROTECTED]> writes: > On Thu, 2007-09-06 at 15:55 -0400, Tom Lane wrote: >> This would have been painful to fix in 8.2 but it seems relatively >> trivial in HEAD --- we just need another filter option in >> GetCurrentVirtualXIDs.
> Patch enclosed. Tested manually on same/different databases. > No docs changed, nor test cases added. Applied. I changed the docs thus - addition it must wait for all existing transactions to terminate. Thus + addition it must wait for all existing transactions that could potentially + use the index to terminate. Thus which is a bit vague about the details but perhaps that's just as well. 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