Re: DTOI4 integer out of range

Tom Lane wrote:
> "shey sewani" <pakix2000(at)hotmail(dot)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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073