Re: OID out of range
| От | Konireddy Rajashekar |
|---|---|
| Тема | Re: OID out of range |
| Дата | |
| Msg-id | CAGpkkhsmCpcsttsVw+KR+hx_+MFTWKu-dx8Godrz1W8brfXo+Q@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: OID out of range (Alvaro Herrera <alvherre@2ndquadrant.com>) |
| Ответы |
Re: OID out of range
|
| Список | 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@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 по дате отправления: