> The use case is something like:-
>>
>> ·There is a table let’s say “A” and the trigger is created on this table
>> let say “A_TRIGGER”.
>>
>> ·The trigger captures the data change happens in table A into table B.
>>
>> ·There would be a huge insert, update, delete on table A, the side
>> effect o
Hi Shridhar,
Probably you should read a bit about how PostgreSQL locks and what
operation requires which locks. More importantly what happens when these
locks are not available.
ISTM, your trigger operation tries a bulk operation
(INSERT/DELETE/UPDATE) on table B but the nightly reindex acqu
Hi,
I am experience the problem where locks acquired by postgres are NOT getting
released.
The use case is something like:-
. There is a table let's say "A" and the trigger is created on this
table let say "A_TRIGGER".
. The trigger captures the data change happens in
