Postgres Pro
Downloads
Home   >   mailing lists

Re: ERROR: dtoi4: integer out of range - Mailing list pgsql-admin

From Tom Lane
Subject Re: ERROR: dtoi4: integer out of range
Date
Msg-id 2207.1049223293@sss.pgh.pa.us
Whole thread Raw
In response to ERROR: dtoi4: integer out of range  (Martins Zarins <mark@vestnesis.lv>)
List pgsql-admin
Tree view 
Martins Zarins <mark@vestnesis.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

pgsql-admin by date:

Previous
From: Robert Treat
Date:
Subject: Re: No user can login
Next
From: Tom Lane
Date:
Subject: Re: Speed & Memory Management