"Sam Mason" <sam(at)samason(dot)me(dot)uk> writes:
> I've just discovered that an index that doesn't refer to any of its table's
> columns isn't automatically dropped when its table is.
I've applied a patch for this:
http://archives.postgresql.org/pgsql-committers/2007-11/msg00137.php
regards, tom lane