Drop schema cascade fails since postgresql 8.4

From: Cedric Berger <cedric(at)berger(dot)to>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Drop schema cascade fails since postgresql 8.4
Date: 2009-09-21 13:43:07
Message-ID: 4AB782EB.3060401@berger.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi,

I've a schema with actually 409 tables.
I've made a default installation of postgresql on the mac
(Installer version Version 8.4.1-1 from enterprise db).

Unfortunately, since I upgraded from 8.3, I cannot drop
these kind of schema anymore:

postgres=# drop schema hard_12 cascade
postgres-# ;
WARNING: out of shared memory
ERROR: out of shared memory
HINT: You might need to increase max_locks_per_transaction.

I've tried to double max_locks_per_transaction, double the values
of SHMMAX/SHMALL, there is no difference...

I had no issue with drop cascade with postgresql 8.2 and 8.3

Please let me know what more information is needed to help you
debug that problem.

Thanks,
Cedric Berger
cedric(at)berger(dot)to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Cedric Berger 2009-09-21 13:46:51 BUG #5070: Drop <schema> cascade fails on 8.4
Previous Message tomas 2009-09-21 12:02:54 Re: [BUGS] Databse installation problem