Postgres Pro
Downloads
Home   >   mailing lists

Re: OID out of range - Mailing list pgsql-general

From Konireddy Rajashekar
Subject Re: OID out of range
Date
Msg-id CAGpkkhsmCpcsttsVw+KR+hx_+MFTWKu-dx8Godrz1W8brfXo+Q@mail.gmail.com
Whole thread Raw
In response to Re: OID out of range  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Responses Re: OID out of range
List pgsql-general
Tree view
@Alvaro Herrera, Can i alter the datatype of relid to oid and try ? 

On Thu, Jan 16, 2020 at 12:41 AM Alvaro Herrera <alvherre@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

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: OID out of range
Next
From: "David G. Johnston"
Date:
Subject: Re: OID out of range