Re: Tables dissapearing

On Mon, Aug 27, 2007 at 05:58:26PM -0400, Andrew Sullivan wrote:
> On Mon, Aug 27, 2007 at 11:44:38PM +0200, Kamil Srot wrote:
> > When this problem appeared for the first time, I had clearly the
> > wraparound problem... I did vacuum it and partially restored the data...
>
> I don't think vacuum would "fix" a wrap around problem in the way you
> describe.  I don't think you have a wrap problem.

Actually, it can: if you have just experienced wraparound (within 1
billion transactions or so) then vacuum will magically cause the
wrapped rows to reappear.

Ofcourse, your indexes may be invalid, your constraints may be
violated, but the data will still be there...

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.