Re: WARNING: out of shared memory

akp geek wrote:
> 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.


is  your script bracketed by BEGIN;  .....  COMMIT;   ?

if so, you might consider breaking it up into smaller chunks, like
BEGIN;  (drop about 50 tables);  COMMIT;   (repeat)