Hi,
In a trigger function I am creating a temp table . When an update on a
table is executed for say 10k rows. I get the below error.
ERROR: out of shared memory
HINT:You might need to increase max_locks_per_transaction
CONTEXT: SQL Statement "created temp table changedinfo(colName
varchar(100), oldValue varchar(4000), newValue varchar(4000)
Current value of max_locks_per_transaction is 64. Do I have to increase
this?
Regards,
Aditya.