ERROR: dtoi4: integer out of range

Поиск
Список
Период
Сортировка
Искать

ERROR: dtoi4: integer out of range

От:
Martins Zarins <mark@vestnesis.lv>
Дата:
Hello all.

heare is my problem.....

vestnesis=# select max(oid) from doc;
    max     
------------
 2299015900
(1 row)

vestnesis=# select id from doc where oid=2299015900;
ERROR:  dtoi4: integer out of range

Postgres version 7.2.3.

INSERT works fine

version 7.2.4 also have this bug.

I didn't tried 7.3.2 yet, because ir requires dump/restore but there is a lot 
of data ~20GB (it'll take some time).

Is there a quick pach for version 7.2.x to allow queries like
select id from doc where oid=2299015900; ??

Mark

Re: ERROR: dtoi4: integer out of range

От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
Martins Zarins  writes:
> vestnesis=# select id from doc where oid=2299015900;
> ERROR:  dtoi4: integer out of range
> Postgres version 7.2.3.

Update to 7.3, or dump/initdb/reload to reduce your range of OIDs,
or put the constant inside single quotes.

			regards, tom lane

FAQ