Re: HELP - Mailing list pgsql-bugs

From Rod Taylor
Subject Re: HELP
Date
Msg-id 1031833177.99916.7.camel@jester
Whole thread Raw
In response to HELP  ("Brendon Matthews" <brendonm@bbtechltd.com>)
List 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

pgsql-bugs by date:

Previous
From: pgsql-bugs@postgresql.org
Date:
Subject: Bug #764: 7.3b1 : SET gives misleading error information with non-valid option name and multiple arguments
Next
From: Tom Lane
Date:
Subject: Re: HELP