Re: from 6.5 > 7.1, cannot pg_dumpall.

From: Patrick Coulombe <pcoulombe(at)mediacces(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: from 6.5 > 7.1, cannot pg_dumpall.
Date: 2001-10-06 21:32:57
Message-ID: 004a01c14eae$77788e30$6b0e8242@caroline
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2001-10-06 22:57:59 Re: from 6.5 > 7.1, cannot pg_dumpall.
Previous Message Patrick Coulombe 2001-10-06 21:24:29 Re: from 6.5 > 7.1, cannot pg_dumpall.