On Sat, Jun 29, 2024 at 6:30 PM Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
wrote:
> Could it be that someone accidentally changed ownership after data had
> been created?
>
All tables (except one named "foo") are owned by the service account
fis_tap.
postgres=# select oid
postgres=# from pg_roles
postgres-# where rolname='fis_tap';
oid
-------
16386
(1 row)
tap=# select relowner, count(*)
from pg_class
where relkind in ('r', 't', 'p')
and relnamespace::regnamespace::text = 'tapschema'
group by relowner;
relowner | count
----------+-------
10 | 1
16386 | 30980
(2 rows)