Re: [HACKERS] problemsafter crash

2005-02-08 Thread ohp
, 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 > Subject: Re: [HACKERS] problemsafter crash > > ohp@pyrenet.fr writes: > > I had a crash last night and since while vacuum

Re: [HACKERS] problemsafter crash

2005-02-08 Thread Tom Lane
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, to

[HACKERS] problemsafter crash

2005-02-07 Thread ohp
Hi everyone, 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" this is 7.4.6 on unixware. How bad is this? TIA -- Olivier PRENANT Tel: +33-5-61-50-97-00 (W