Re: Table Corruption - Mailing list pgsql-general

From Tom Lane
Subject Re: Table Corruption
Date
Msg-id 11522.973790387@sss.pgh.pa.us
Whole thread Raw
In response to Table Corruption  ("mike focosi" <mike@goldendome.com>)
List pgsql-general
"mike focosi" <mike@goldendome.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

pgsql-general by date:

Previous
From: "mike focosi"
Date:
Subject: Re: Table Corruption
Next
From: Stephan Szabo
Date:
Subject: RE: NVL (sql oracle)