Re: Table Corruption

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "mike focosi" <mike(at)goldendome(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Table Corruption
Date: 2000-11-09 17:19:47
Message-ID: 11522.973790387@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

"mike focosi" <mike(at)goldendome(dot)com> writes:
> I have several php scripts that allow my clients to add stories to a
> database. I've noticed that once in a while, when they attempt to
> insert/update more than 8k into a table, the table is becoming corrupted.

> Has anybody ever had any problems like the one I described. I've yet to
> upgrade our database servers to 7+ (running 6.4) so I'm hoping maybe that
> would solve the problem. But I'd like to know what the exact problem is.

Try 7.0.* --- it's much more careful about checking row-size limits.
6.4 is ancient history ;-)

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Alfred Perlstein 2000-11-09 19:31:03 Re: large classes (tables)
Previous Message mike focosi 2000-11-09 16:38:39 Table Corruption

Browse pgsql-general by date

  From Date Subject
Next Message mike focosi 2000-11-09 17:20:59 Re: Table Corruption
Previous Message Nick Fankhauser 2000-11-09 17:15:46 RE: NVL (sql oracle)