Re: URGENT PROBLEM

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.
>