Postgres Pro
Downloads
Home   >   mailing lists

Cluster problem - Mailing list pgsql-general

From Andrew Bartley
Subject Cluster problem
Date
Msg-id 000b01c29405$527b12e0$3200a8c0@abartleypc
Whole thread Raw
In response to Error Occurred when run function. How to solve it?  ("annachau" <annachau@hongkong.com>)
Responses Re: Cluster problem
List pgsql-general
Tree view 
Hi all,

I am having trouble with clustering tables at the moment.

I cluster certain tables during housekeeping before I vacuum full analyse
the whole DB.

This error pops up every few days during clustering

ERROR:  Cannot insert a duplicate key into unique index pg_class_oid_index

Can some one please advise.

PG version:

 PostgreSQL 7.2.1 on i686-pc-linux-gnu, compiled by GCC 2.95.4


Thanks

Andrew

pgsql-general by date:

Previous
From: Hubert depesz Lubaczewski
Date:
Subject: log analyzer - please test, and let me know what i can and should improve
Next
From: Tom Lane
Date:
Subject: Re: Cluster problem