Re: ERROR: dtoi4: integer out of range

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Martins Zarins <mark(at)vestnesis(dot)lv>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: ERROR: dtoi4: integer out of range
Date: 2003-04-01 18:54:53
Message-ID: 2207.1049223293@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Martins Zarins <mark(at)vestnesis(dot)lv> 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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2003-04-01 19:07:57 Re: Speed & Memory Management
Previous Message Robert Treat 2003-04-01 18:45:56 Re: No user can login