Re: vacuum analyze - cannot insert duplicate key... (2)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Patrick Coulombe <pcoulombe(at)mediacces(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: vacuum analyze - cannot insert duplicate key... (2)
Date: 2001-10-01 14:11:24
Message-ID: 23234.1001945484@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Patrick Coulombe <pcoulombe(at)mediacces(dot)com> writes:
> in my data/base/medias/
> medias_categories_media_id_key.999
> i found this file over 700 copy. can i erase them and what the purpose of
> this file ?

If they're zero-length, you can remove them. You definitely need to
update, though; appearance of such files is a symptom of some old bugs.

regards, tom lane

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Jimmy McDonald 2001-10-01 15:44:35 access to postgres?
Previous Message Patrick Coulombe 2001-10-01 13:54:54 vacuum analyze - cannot insert duplicate key... (2)