Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id BAA4F2E424C for ; Fri, 8 Feb 2008 11:59:43 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 37632-03-2 for ; Fri, 8 Feb 2008 11:59:31 -0400 (AST) Received: from mail.autorevenue.com (ip-208.178.167.106.gblx.net [208.178.167.106]) by postgresql.org (Postfix) with ESMTP id 51D492E4267 for ; Fri, 8 Feb 2008 11:59:28 -0400 (AST) Received: (qmail 20111 invoked from network); 8 Feb 2008 11:00:17 -0500 Received: from unknown (HELO dei26g028575) (msteben@10.10.1.20) by mail.autorevenue.com with SMTP; 8 Feb 2008 11:00:17 -0500 From: "Mark Steben" To: Subject: Error on CLUSTER command Date: Fri, 8 Feb 2008 10:59:16 -0500 Message-ID: <00ac01c86a6b$8e761f50$14010a0a@dei26g028575> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00AD_01C86A41.A5A01750" X-Mailer: Microsoft Office Outlook 11 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2992 thread-index: Achqa45lIg/mF7QySGyBeXyQUy5q0A== X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/96 X-Sequence-Number: 28170 This is a multi-part message in MIME format. ------=_NextPart_000_00AD_01C86A41.A5A01750 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hello listers, I am getting the following error when I attempt to CLUSTER on a table: mavmail=# cluster mailer_queue; ERROR: could not create relation "pg_temp_752992924": File exists The 752992924 is the oid of one of the indexes of this table (not the clustering index) This apparently is the result of a previous cluster operation that had not cleaned up properly. Where can I find this file? There are several tables that have this problem. Do I need to Do a database REINDEX or some other type of system maintenance? Again we are running 7.4.5. 8.2.5 scheduled for implementation later this month or early March. Mark Steben Senior Database Administrator @utoRevenueT A Dominion Enterprises Company 480 Pleasant Street Suite B200 Lee, MA 01238 413-243-4800 Home Office 413-243-4809 Corporate Fax msteben @autorevenue.com Visit our new website at www.autorevenue.com IMPORTANT: The information contained in this e-mail message is confidential and is intended only for the named addressee(s). If the reader of this e-mail message is not the intended recipient (or the individual responsible for the delivery of this e-mail message to the intended recipient), please be advised that any re-use, dissemination, distribution or copying of this e-mail message is prohibited. If you have received this e-mail message in error, please reply to the sender that you have received this e-mail message in error and then delete it. Thank you. Come Visit Us at NADA! Booth #5735N February 9th - February 12th Moscone Center in San Francisco, CA ------=_NextPart_000_00AD_01C86A41.A5A01750 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hello listers,

 

I am getting the following error when I attempt to CLUSTER on a = table:

 

 mavmail=3D# cluster = mailer_queue;

ERROR:  could not create relation = "pg_temp_752992924": File exists

 

The 752992924 is the oid of one of the indexes of this table = (not the clustering index)

 

This apparently is the result of a previous cluster operation = that had not cleaned up properly.

Where can I find this file?  There are several tables that = have this problem.  Do I need to

Do a database REINDEX or some other type of system = maintenance?

 

Again we are running 7.4.5.  8.2.5 scheduled for = implementation later this month or early March.

 

Mark Steben

Senior Database Administrator
@utoRevenue™
A Dominion = Enterprises Company
480 = Pleasant Street
Suite = B200
Lee, MA 01238
413-243-4800 Home Office 
413-243-4809 Corporate Fax

msteben@autorevenue.com

Visit our = new website at
www.autorevenue.com

 

IMPORTANT: The information = contained in this e-mail message is confidential and is intended only for the named addressee(s). If the reader of this e-mail message is not the intended recipient (or the individual responsible for the delivery of this e-mail message to the intended recipient), please be advised that any re-use, dissemination, distribution or copying of this e-mail message is = prohibited.  If you have received this e-mail message in error, please reply to = the sender that you have received this e-mail message in error and then = delete it.  Thank you.

Come Visit Us at NADA! =  Booth #5735N
February 9th - February 12th
Moscone Center in San = Francisco, CA

 

------=_NextPart_000_00AD_01C86A41.A5A01750--