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. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
