postgres : relation there even after dropping the database
Chances are that you never created the tables in the correct schema in the first place.  Either that or your dropdb failed to complete.
Try to drop the database again and see what it says.  If that appears to work then go in to postgres and type \l, putting the output here.
I dropped my database that I had previously created for django using :
dropdb <database>
but when I go to the psql  prompt and say \d, I still see the relations there :
How do I remove everything from postgres so that I can do everything from scratch ?