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.

Reply via email to