Re: from 6.5 > 7.1, cannot pg_dumpall. - Mailing list pgsql-novice

From Patrick Coulombe
Subject Re: from 6.5 > 7.1, cannot pg_dumpall.
Date
Msg-id 004a01c14eae$77788e30$6b0e8242@caroline
Whole thread Raw
In response to from 6.5 > 7.1, cannot pg_dumpall.  (Patrick Coulombe <pcoulombe@mediacces.com>)
Responses Re: from 6.5 > 7.1, cannot pg_dumpall.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
> Try dropping that index.

done. but, when i try to recreate it :
medias=> create index contacts_secteurs_contact_id_ke on contacts_secteurs
(contact_id);
... freeze ...

what about if  i drop it, and then vacuum or look into this table for null
value and other bad data. and after recreate it ? it's safe to vacuum my bd
after dropping an index ?

patrick


pgsql-novice by date:

Previous
From: Patrick Coulombe
Date:
Subject: Re: from 6.5 > 7.1, cannot pg_dumpall.
Next
From: Tom Lane
Date:
Subject: Re: from 6.5 > 7.1, cannot pg_dumpall.