tried casting to text,varchar but no luck select u.relid,c.relnamespace::regnamespace::text,c.relname,now() as current_time,pg_size_pretty(pg_relation_size(c.oid)) as current_size,pg_size_pretty(u.table_size) as previous_size,pg_size_pretty(pg_relation_size(c.oid) - pg_relation_size(u.table_size)) as diff from user_tables_sizes u join pg_class c on u.relid::varchar= c.oid::varchar where c.relkind='r' and c.relnamespace::regnamespace::text='rpx_reporting_stage' and u.captured_dt::date=current_date - interval '1 days' ;
ERROR: OID out of range On Thu, Jan 16, 2020 at 12:12 AM David G. Johnston < david.g.johns...@gmail.com> wrote: > On Wed, Jan 15, 2020 at 11:36 AM bhargav kamineni < > bhargavpostg...@gmail.com> wrote: > >> Any workaround to make it work ? >> > > Convert both to text and join on that? Curious choice making relid > numeric... > > David J. >
