Simon Riggs <[EMAIL PROTECTED]> writes:
> On Mon, 2005-05-09 at 15:18 -0400, Tom Lane wrote:
>> ... usually. We will promote later arrivals in front of older ones if
>> the alternative would be a deadlock (eg, the later one already holds
>> some lock that would block the earlier one).
> Thats part of deadlock detection? I had thought we just blew one away...
Only after deciding that there's no way to rearrange the lock queues to
eliminate the deadlock.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
