Yet still to drop the tables you need to have complete information on them in the system tables. So I would go and 'forge' the data by inserting info into pg_attribute based on other entries for the columns of these tables. After that you should be able to drop the tables or do aby other modifications.