ERROR: dtoi4: integer out of range

From: Martins Zarins <mark(at)vestnesis(dot)lv>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: ERROR: dtoi4: integer out of range
Date: 2003-04-01 16:13:03
Message-ID: 200304011913.03824.mark@vestnesis.lv
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Robert Treat 2003-04-01 18:41:27 Re: Speed & Memory Management
Previous Message lists 2003-04-01 14:28:25 Re: pg_restore problem