Re: [Postgres-xc-developers] Bug: drop database error!

[Michael P. <mic...@gm...>]

This seems to be linked with the pooler connections.
Drop database does not work correctly if you don't empty pool before
dropping it.

You should do something like:
\c postgres
clean connection to all for database dbt1;
drop database dbt1;
create database dbt1;

Have a look at the commit 54a648a3ffe7f8fc0273295ee17e91cebcb34948 in git
repository for more details.

I admit that we need to call automatically pool cleaning when dropping a
database.
This is not done yet. We should commit a fix soon to support that.

Regards,

-- 
Michael Paquier
http://michaelpq.users.sourceforge.net