Re: OID out of range - Mailing list pgsql-general

From Adrian Klaver
Subject Re: OID out of range
Date
Msg-id aaa6b3e0-7fe6-9736-b044-0873dcd4fb2d@aklaver.com
Whole thread Raw
In response to OID out of range  (Konireddy Rajashekar <rajkonireddy@gmail.com>)
Responses Re: OID out of range
List pgsql-general
On 1/15/20 10:18 AM, Konireddy Rajashekar wrote:
> I am getting ERROR: OID out of range while firing below SQL , what could 
> be the reason? I am joining pg_class and one user_created table to 
> compare tables size.
> 
> 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
joinpg_class c on  u.relid::bigint =  c.oid::bigint 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 rangetest-# \d user_tables_sizes
 

Given this:

https://www.postgresql.org/docs/12/datatype-oid.html
"The oid type is currently implemented as an unsigned four-byte integer. "

I am pretty sure this:

c.oid::bigint

is the problem.

-- 
Adrian Klaver
adrian.klaver@aklaver.com



pgsql-general by date:

Previous
From: Konireddy Rajashekar
Date:
Subject: OID out of range
Next
From: bhargav kamineni
Date:
Subject: Re: OID out of range