q&a   

You've created a database but made an embarrassing typo in the name or for whatever reason you don't like it. How do you rename this database?

If you are using PgAdmin III, you will not see this option. Just one of the ways PgAdmin III lets us down. However there is a simple way of doing it with a PostgreSQL command which has been in existence even in the 7.4 days of PostgreSQL which is documented in PostgreSQL official docs on ALTER DATABASE. In order to do it, you need to first make sure everyone is out of the database (including yourself) otherwise you'll get an annoying database is being accessed by other users or current database may not be renamed error.

1. Connect to some other database other than the one you are trying to rename such as say the postgres db.
2. Kick everyone out of the database you are trying to rename - to figure out users, you can run
   

   SELECT * 
   	FROM pg_stat_activity 
   	WHERE datname = 'myolddbname_goes_here'

3. Now just run this command -
   ALTER DATABASE myolddbname_here RENAME TO mynewdbname_here

What is Constraint Exclusion?

Constraint Exclusion is a feature introduced in PostgreSQL 8.1 which is used in conjunction with Table Inheritance to implement table partitioning strategies. The basic idea is you put check constraints on tables to limit what kind of data can be inserted into it. Constraint Exclusion will then in theory skip over tables whose check constraints guarantee there is no way for it to satisfy the condition of a query.

Constraint Exclusion is a great thing, but it has some limitations and quirks one needs to be aware of that in some cases will prevent it from kicking in. Below are a couple of reasons why it sometimes doesn't work.