regis.boumera@xxxxxxxxxx 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 your table, so someone might be able to find out what happend to your database in the first place. Marc -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general