From: | Konireddy Rajashekar <rajkonireddy(at)gmail(dot)com> |
---|---|
To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
Cc: | bhargav kamineni <bhargavpostgres(at)gmail(dot)com>, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: OID out of range |
Date: | 2020-01-15 19:00:52 |
Message-ID: | CAGpkkhs9VkqrQD978eTnYo6SJLhpEB3uU7uTyNEG6brfcK27WQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(dot)g(dot)johnston(at)gmail(dot)com> wrote:
> On Wed, Jan 15, 2020 at 11:36 AM bhargav kamineni <
> bhargavpostgres(at)gmail(dot)com> wrote:
>
>> Any workaround to make it work ?
>>
>
> Convert both to text and join on that? Curious choice making relid
> numeric...
>
> David J.
>
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2020-01-15 19:11:00 | Re: OID out of range |
Previous Message | David G. Johnston | 2020-01-15 18:42:25 | Re: OID out of range |