title: Unexpected behavior from changing owner in postgres
body: <p>I have a schema of tables <code>myschema</code> with different owners in postgres - owner 'foo' and owner 'bar'</p>
  <p>After granting all privileges on the database to owner 'bar', and then re-logging in as user 'bar', I try to change the ownership of all bar-owned tables to 'foo' with the following command:</p>
  <pre><code>SELECT format(
    'ALTER TABLE %I.%I.%I OWNER TO %I;',
    table_catalog,
    table_schema,
    table_name,
    'foo'  
  )
  FROM information_schema.tables
  WHERE table_schema = 'myschema'
  </code></pre>
  <p>This then returns:</p>
  <pre><code> ALTER TABLE my_db.my_schema.my_tableA OWNER TO foo;
   ALTER TABLE my_db.my_schema.my_tableB OWNER TO foo;
   ALTER TABLE my_db.my_schema.my_tableC OWNER TO foo;
  </code></pre>
  <p>successfully</p>
  <p>Then, when I run <code>select * from pg_tables;</code>, I see that none of the tableowners have changed.  How is this possible and what could be happening?</p>