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