Re: Drop schema cascade fails since postgresql 8.4 - Mailing list pgsql-bugs

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.