Thread: URGENT PROBLEM

"Bruce Irvine" <b.irvine@sportingpulse.com> writes:
> We are having MAJOR & URGENT problems with Postresql occaisonly corrupting =
> tables on insert.

Can't help you with that much information.

What Postgres version is this?  (If your answer is not "7.0.3" or
"7.1.2", I'm going to tell you to upgrade before anything else.)

What is the table schema?  What kind of corruption do you see exactly?
        regards, tom lane

How 'bout posting what version of pgsql you're running, and we'll start 
back at square one :)

-d

Bruce Irvine wrote:

> Hi All,
>
>  
>
> This is my first post, so I hope I'm in the right area and doing it 
> correctly.
>
>  
>
> We are having MAJOR & URGENT problems with Postresql occaisonly 
> corrupting tables on insert.  I had a quick look through your archive 
> and couldn't find anything. It seems to happen mostly on large inserts 
> (lots of data into one text field). This results in corrupting the 
> table and hanging the psql console whenever I try to INSERT, UPDATE, 
> DELETE, SELECT, etc. Doing an "EXPLAIN SELECT * FROM table" shows that 
> I have around 100 - 1000 extra rows. The problem is often fixed by 
> running VACUUM against the table, however VACUUM often hangs leaving 
> the table locked until I delete the lock file. 
>
>  
>
> Its only a basic INSERT statement into a basic table.
>
>  
>
> Thanks in advance.
>
>  
>
> Bruce Irvine.
>
> SportingPulse.
>