> 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