Re: [GENERAL] Data corruption (8.2.5 Windows XP)

2009-06-30 Thread Marc Schablewski
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 reinde

Re: [GENERAL] Data corruption (8.2.5 Windows XP)

2009-06-30 Thread Alan Hodgson
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 subsc