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, there is no difference...
Did you restart the server after raising the value?
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.