title: PostgreSQL drop role fails because of default privileges
body: <p>I am trying to drop a role 'xyz' that was previously the owner of the schema with the same name 'xyz'. I altered the schema ownership as below, and run reassigned ownership just in case (although all tables were created by a different user with superuser power). So I run all these:</p>
  
  <pre><code>alter schema xyz owner to postgres;
  reassign owned by xyz to postgres;
  alter default privileges in schema seeds revoke all on tables from xyz cascade;
  alter default privileges in schema seeds revoke all on sequences from xyz cascade;
  alter default privileges in schema seeds revoke all on functions from xyz cascade;
  </code></pre>
  
  <p>And still getting the error:</p>
  
  <pre><code>drop role xyz;
  ERROR:  role "xyz" cannot be dropped because some objects depend on it
  DETAIL:  owner of default privileges on new relations belonging to role xyz in schema xyz
  </code></pre>
  
  <p>Also FYI:</p>
  
  <pre><code>postgres=# \du rsi
  List of roles
  Role name |   Attributes   | Member of   
  -----------+----------------+-----------
  rsi       | No inheritance | {}
  </code></pre>
  
  <p>What am I missing? Any help would be appreciated! Thanks!!</p>