Re: DTOI4 integer out of range

Tom Lane wrote:
> "shey sewani"  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