[GENERAL] deadlock detected - when multiple threads try to update one table

2005-12-02 Thread Harakiri
Hello, im using postgresql 8 under SLES 9 and RH 3.x - under both OS i encountered the following problem : Lets say i have a table, which has no reference to any other table - and i create one entry for each day of the year within this table (PK). During a day, i update the values within that

Re: [GENERAL] deadlock detected - when multiple threads try to update one table

2005-12-02 Thread Harakiri
be no deadlock here - T1 just blocks T2 till the update is done, then T2 should be able to update the same row.. Thanks --- Stephan Szabo [EMAIL PROTECTED] wrote: On Fri, 2 Dec 2005, Harakiri wrote: im using postgresql 8 under SLES 9 and RH 3.x - under both OS i encountered the following