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 k

[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 spe