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
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-#