Re: [BUGS] Drop schema cascade fails since postgresql 8.4

2009-09-21 Thread Alvaro Herrera
Cedric Berger wrote: > 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

[BUGS] Drop schema cascade fails since postgresql 8.4

2009-09-21 Thread Cedric Berger
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-#