Re: OID out of range

On 2020-Jan-15, Konireddy Rajashekar wrote:

> rangetest-# \d user_tables_sizes
>                      Table "user_tables_sizes"
>    Column    |            Type             | Collation | Nullable | Default
> -------------+-----------------------------+-----------+----------+---------
>  relid       | numeric                     |           |          |

Why do you have this column defined as numeric?  It seems more sensible
to have it as type oid; it's probably that column where you have the
out-of-range values.

--
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services