Data now showing up - Mailing list pgsql-admin

From Ken Kinder
Subject Data now showing up
Date
Msg-id 20010128111559.A8904@kenkinder.com
Whole thread Raw
Responses Re: Data now showing up  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
After a few months of running, I have a database that consistantly stops
taking inserts. It isn't a high-use database, doesn't give an error, and
is really very odd. The table has one column (text) and never more than
a dozen rows.

After a while, it just stops inserting. You type an insert in psql, it
acts like it did it, you select from the data, and it's simply not there.
If I dump and rebuild the database, the problem is solved.

Any suggestions?

psql (PostgreSQL) 7.0.0

--
Ken Kinder
www.kenkinder.com

pgsql-admin by date:

Previous
From: Dmitry Morozovsky
Date:
Subject: PostgreSQL 7, FreeBSD and locale support
Next
From: Oleg Bartunov
Date:
Subject: Re: PostgreSQL 7, FreeBSD and locale support