Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group