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 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly