Re: DTOI4 integer out of range

Tom Lane wrote:
> "shey sewani" <pakix2000@hotmail.com> writes:
> > I am currently running Postgres 7.1.2 on my RedHat 7.1 Linux machines.  I
> > have had a database on postgres for two years now.  During the past two
> > years the database size has grown considerably.
>
> > There are more than 250 Million records in the database.  Furthermore many
> > of these records have been inserted, deleted and re-inserted over the past 2
> > years.
>
> > Within the last few days I have recieved several errors when using pgaccess
> > with postgres.  The most common error I recieve is
> > "dtoi4 integer out of Range, OID 218700327" when I try to update a record
> > through pgaccess.  I do not recieve any errors when I do updates with psql
> > or updates with programs that use libpq++.
>
> Evidently your OID counter has passed 2 billion.  OID is supposed to be
> unsigned, so it can go to 4 billion ... but we used to have quite a lot
> of client code that was sloppy and tried to store OIDs in plain "int"
> variables.  It looks like you have some variant of that problem here.

Tom, I see this OID as 200M, not 2B.  Am I missing something?

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073