Re: [HACKERS] Trigger function in a multi-threaded environment behavior

2010-06-01 Thread Robert Haas
On Tue, Jun 1, 2010 at 7:10 AM, Hardik Belani wrote: > If we introduce postgres triggers (trigger functions) on some of the tables > to track insert/update/delete operations, (This is done by keeping and > updating a counter field for every insert, update and delete operation > performed on a set

Re: [HACKERS] Trigger function in a multi-threaded environment behavior

2010-06-01 Thread Peter Eisentraut
On tis, 2010-06-01 at 16:40 +0530, Hardik Belani wrote: > If we introduce postgres triggers (trigger functions) on some of the > tables to track insert/update/delete operations, (This is done by > keeping and updating a counter field for every insert, update and > delete operation performed on a s

[HACKERS] Trigger function in a multi-threaded environment behavior

2010-06-01 Thread Hardik Belani
We have a multi-threaded environment in linux where multiple threads are performing database operations(insert, update, select and at times delete as well) in transaction mode (which may span across stored procedures) using unixodbc. Now this as is, works fine. If we introduce postgres triggers