Re: OID out of range
От | David G. Johnston |
---|---|
Тема | Re: OID out of range |
Дата | |
Msg-id | CAKFQuwbuH3B0ui3QQde4m=n0jzOhwfQPkACuj_AxMXqWmig0UQ@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: OID out of range (Konireddy Rajashekar <rajkonireddy@gmail.com>) |
Список | pgsql-general |
Please don't top-post here.
On Wed, Jan 15, 2020 at 12:01 PM Konireddy Rajashekar <rajkonireddy@gmail.com> wrote:
tried casting to text,varchar but no luckselect 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.
В списке pgsql-general по дате отправления: