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