Search Postgresql Archives

Re: OID out of range

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux