bug 870286 - clean up role creation

* Separate ALTER TABLE ... OWNER TO for each relation type
* Fix many tests
* Separate super user role from normal user roles
* Add a superuser to sql/roles.sql
* Add deprecation notices for old postgres related tests
* Add --no_schema back to setupdb_app.py
* PEP8-ify setupdb_app.py
* Clean up per feedback from @peterbe and @jezdez