Hi Tom, The problem was worse then that: there were actually twice the same row in the table, delete those twins helped. One of my customer suffered the same problem in 2 of his tables and even the OID was the same!
how can that be possible? again, deleting those rows helped On Tue, 8 Feb 2005, Tom Lane wrote: > Date: Tue, 08 Feb 2005 10:40:33 -0500 > From: Tom Lane <[EMAIL PROTECTED]> > To: ohp@pyrenet.fr > Cc: pgsql-hackers list <pgsql-hackers@postgresql.org> > Subject: Re: [HACKERS] problemsafter crash > > ohp@pyrenet.fr writes: > > I had a crash last night and since while vacuuming databases (either full > > or lazy) I get this error: > > > duplcate key violates unique cnstraint "pg_statistic_relid_att_index" > > Reindexing pg_statistic would probably make that go away ... > > regards, tom lane > -- Olivier PRENANT Tel: +33-5-61-50-97-00 (Work) 6, Chemin d'Harraud Turrou +33-5-61-50-97-01 (Fax) 31190 AUTERIVE +33-6-07-63-80-64 (GSM) FRANCE Email: ohp@pyrenet.fr ------------------------------------------------------------------------------ Make your life a dream, make your dream a reality. (St Exupery) ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings