Re: HELP

From: Rod Taylor <rbt(at)rbt(dot)ca>
To: Brendon Matthews <brendonm(at)bbtechltd(dot)com>
Cc: PostgreSQL Bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: HELP
Date: 2002-09-12 12:19:36
Message-ID: 1031833177.99916.7.camel@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Thu, 2002-09-12 at 01:13, Brendon Matthews wrote:
> Hi,
>
> I have been using PostgreSQL 7.2.2 for a while now on one of our live
> machines, however all of a sudden with no warning, we are no longer able to
> run any UPDATE statements on one of our databases. SELECT and INSERT
> statements have no issues.

Try VACUUM FULL (different than regular VACUUM).

Try dumping data / shutdown daemon / fry data directory / initdb / start
daemon / restore data.

--
Rod Taylor

In response to

  • HELP at 2002-09-12 05:13:48 from Brendon Matthews

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2002-09-12 13:13:24 Re: HELP
Previous Message Rod Taylor 2002-09-12 12:12:05 Re: HELP