pg_tables system table: tableowner column is incorrect

[emarsden]

pgeltestdb=> select current_user();
      "current_user"       
---------------------------
 pgeltestuser@192.168.1.48
pgeltestdb=> create table foobles(a integer);
CREATE TABLE
pgeltestdb=> select tableowner from pg_catalog.pg_tables where tablename='foobles';
 tableowner 
------------
 postgres
(1 ligne)

Expecting the current user, "pgeltestuser".

Using the current Docker image, which reports version() as "PostgreSQL 15.5".

[zachmu]

Hi @emarsden,

Doltgres has a different user model than postgres does. Because of the distributed nature of the database, we don't want to record ownership of schema objects directly into storage or tie them to the permission model the way that Postgres does, so everything is owned by a single user, postgres. We went down the path of schema object ownership a bit when designing this and it leads to some very troubling conclusions for the distributed use cases. I can go into more detail if you want but that's the top-line summary of why it works this way.

If this is breaking compatibility or some use case for you we'd be very interested in hearing more about how.

[zachmu]

Closing this out for the time being.