| From: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
|---|---|
| To: | Konireddy Rajashekar <rajkonireddy(at)gmail(dot)com> |
| Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: OID out of range |
| Date: | 2020-01-15 19:11:00 |
| Message-ID: | 20200115191100.GA29546@alvherre.pgsql |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 | Konireddy Rajashekar | 2020-01-15 19:17:23 | Re: OID out of range |
| Previous Message | Konireddy Rajashekar | 2020-01-15 19:00:52 | Re: OID out of range |