DEADLOCK INSERT
DEADLOCK INSERT
От:
"Ricardo Durao" <durao@pcsolution.com.br>
Дата:
Hello, Tom Lane I am using version 7.4.8 and I think that I have this problem(bug) that is describe here for you. _________________________________________________________________________ Re: INSERT deadlocks (bug or feature?) From: Tom Lane To: evgeny gridasov Subject: Re: INSERT deadlocks (bug or feature?) Date: Fri, 27 May 2005 10:15:32 -0400 evgeny gridasov writes: > ... and we recieve a deadlock! > Easy to understand why: each insert statement generates query like: > SELECT 1 FROM ONLY "public"."ref" x WHERE "id" = $1 FOR UPDATE OF x > So, is this behaviour of postgresql is a bug or feature? An extremely well-known bug ... which is fixed in CVS tip. regards, tom lane _________________________________________________________________________ How I can fix this in my version. Have a Pacth ? I can get the source of the file and re-compile the Postgresql ? Thanks, for any Help. Ricardo Durão " -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.7.2/14 - Release Date: 14/6/2005