Re: OID out of range

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

Please don't top-post here.

On Wed, Jan 15, 2020 at 12:01 PM Konireddy Rajashekar <rajkonireddy@xxxxxxxxx> wrote:

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

Yeah, the join isn't the problem, the error is casting to OID, not from...

Pretty sure your problem is:

pg_relation_size(u.table_size)

David J.