[PERFORM] Updates on one row causing ExclusiveLock on PostgreSQL 8.3.5

2013-01-10 Thread PostgreSQL
My best regards for all... Please. I need for an advice. I'm having a trouble, that puting others queries in wait state, becouse of ExclusiveLock granted by an Update that only update one row at each time. This update occurs into a function and this function are executed several times and c

[PERFORM] Updates on one row causing ExclusiveLock on PostgreSQL 8.3.5

2013-01-10 Thread PostgreSQL
My best regards for all... Please. I need for an advice. I'm having a trouble, that puting others queries in wait state, becouse of ExclusiveLock granted by an Update that only update one row at each time. This update occurs into a function and this function are executed several times and c