Re: OID rollover? - Mailing list pgsql-general

From Bruce Momjian
Subject Re: OID rollover?
Date
Msg-id 200004100234.WAA08922@candle.pha.pa.us
Whole thread Raw
In response to OID rollover?  (Charles Martin <martin@chasm.org>)
List pgsql-general
> What happens to my database when the OID rolls over?
>
> If the answer is "doom", is there anything I can do about it?
>

Actually, no one has every reported a roll-over, so I can't say for
sure.  They are unsigned ints, so it should go past 2 gigs.  If it goes
past 4 gigs, it rolls to zero again.  Having duplicate oids in the same
table is really not a crisis, though there could be come oid collision
in the system tables that could cause problems.

--
  Bruce Momjian                        |  http://www.op.net/~candle
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-general by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: PHP-Postgres link
Next
From: Titus Brown
Date:
Subject: Minor hack to support LO string searches