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

2005-12-03 Thread Stephan Szabo
On Fri, 2 Dec 2005, Harakiri wrote: Hi, thanks for the response , It's hard to say with just the above. Are you doing other things in the transactions besides a single update of that table and/or is the order of in each transaction i do basically the same stuff : insert 1 row into

[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

2005-12-02 Thread Stephan Szabo
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 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,

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

2005-12-02 Thread Harakiri
Hi, thanks for the response , It's hard to say with just the above. Are you doing other things in the transactions besides a single update of that table and/or is the order of in each transaction i do basically the same stuff : insert 1 row into table A, B, C (B and C have a foreign key