WARNING: out of shared memory

[akp geek <akpgeek@xxxxxxxxx>]

Hi All -

                I have been trying to drop 2000 tables using a script. I am getting the following error message. I have the value set for max_locks_per_transaction = 100 . Error message is as follows

WARNING:  out of shared memory

ERROR:  out of shared memory

HINT:  You might need to increase max_locks_per_transaction.

********** Error **********

ERROR: out of shared memory

SQL state: 53200

Hint: You might need to increase max_locks_per_transaction.

appreciate your help

regards