Re: Problem with OID wrap

Martin Weinberg <weinberg(at)osprey(dot)astro(dot)umass(dot)edu> writes:
> It seems that OID in one of our databases wrapped during a data
> load from tape.
> The wrap is quite plausible based on the volume of the database and
> the number of tables that have been loaded and reloaded. I would have
> thought that an OID wrap would be harmless (except in the loss of
> uniqueness and meaning for any query which depended on this).
> However, the user complains that part of the table disappeared? Is
> this possible?

I'd be wondering about transaction ID wrap, myself. You might care
to consult the discussion of transaction ID wrap in the 7.2 development
docs (under admin guide "routine maintenance", IIRC).

regards, tom lane