Re: OID out of range

Any workaround to make it work ?

On Thu, 16 Jan 2020 at 00:00, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:

> 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 join
> pg_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(dot)klaver(at)aklaver(dot)com
>
>
>