Make drop_view(:view_name, :foreign=>true) drop foreign tables on PostgreSQL
Make create_table with :foreign option reversible on PostgreSQL

Now that we support dropping foreign tables, creating foreign
tables should be reversible.