@Alvaro Herrera, Can i alter the datatype of relid to oid and try ?

On Thu, Jan 16, 2020 at 12:41 AM Alvaro Herrera <alvhe...@2ndquadrant.com>
wrote:

> 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
>

Reply via email to