WARNING: out of shared memory

From: akp geek <akpgeek(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: WARNING: out of shared memory
Date: 2010-04-21 15:39:08
Message-ID: m2h2024a9fb1004210839g6d342e4en36c99a7fb3be885c@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message A B 2010-04-21 15:45:47 Re: Database viewpoint of subject - Sending e-mails from database table with Cronjob
Previous Message John R Pierce 2010-04-21 15:38:12 Re: Embedded Postgres