After a crash, some data disappeared in some tables.
Furthermore, there is a table with an INTEGER as primary key. One of its
row is corrupted.
All global requests (no WHERE clause) succeed, but each request with a
WHERE clause on the primary acts like this values does not exist.
Example :
On Tuesday 30 June 2009, regis.boum...@steria.com wrote:
SELECT * FROM t_table t WHERE t.id=1; = no result
Is there a reason for this?
Is there a way to repair the database?
reindex
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
regis.boum...@steria.com wrote:
Is there a reason for this?
Is there a way to repair the database?
I guess your primary key index got damaged. You could try to REINDEX the
table or DROP and recreate the index manually. Perhaps you should do a
backup of your data directory before reindexing