| From: | Konireddy Rajashekar <rajkonireddy(at)gmail(dot)com> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
| Cc: | "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:17:23 |
| Message-ID: | CAGpkkhsmCpcsttsVw+KR+hx_+MFTWKu-dx8Godrz1W8brfXo+Q@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
@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(at)2ndquadrant(dot)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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2020-01-15 19:20:07 | Re: OID out of range |
| Previous Message | Alvaro Herrera | 2020-01-15 19:11:00 | Re: OID out of range |