Am Dienstag, 13. Dezember 2005 16:52 schrieb Tom Lane:
> Mario Weilguni <[EMAIL PROTECTED]> writes:
> > Since the type field is PK, there cannot be 2 rows with type='list', I
> > guess the deadlock must have some different explanation.
>
> Then the deadlock must involve rows in two different tables. What else
> are you doing in the same transaction(s) as updating last_modified?
That's what I think too, unfortunatly, I can't say for sure. The application
uses around 1000 different queries, and I had no logging on for this case. So
I guess two backends might have issued interleaved updates.
I think without logging this cannot be solved here.
Best regards,
Mario Weilguni
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
