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.
