Tigran Mkrtchyan <tigran(dot)mkrtchyan(at)desy(dot)de> writes:
> I got a incorrect or unexpected behavior in concurrent environment.
This is not a bug, nor even surprising. Since you haven't committed
the second transaction, there are a growing number of
dead-but-not-recyclable versions of the updated row. The active client
has to check each of these versions during its primary key uniqueness
check during each update.
regards, tom lane
In response to
pgsql-bugs by date
|Next:||From: Tom Lane||Date: 2006-12-29 04:04:41|
|Subject: Re: BUG #2866: cast varchar to decimal failure |
|Previous:||From: Theodore Petrosky||Date: 2006-12-28 13:26:24|
|Subject: Re: BUG #2867: FULL PATH name problem |