Handle dropping indexes for schema qualified tables on PostgreSQL

PostgreSQL doesn't accept schema qualification when adding indexes,
assuming that the index will always be placed in the same schema
as that table.  So make the same assumption when dropping
an index from a table, using the table's schema.
Show an example of a foreign_key call with a specific type