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.