Re: Error on CLUSTER command

Поиск
Список
Период
Сортировка
От Mark Steben
Тема Re: Error on CLUSTER command
Дата
Msg-id 00b101c86a6f$3eef3f80$14010a0a@dei26g028575
обсуждение исходный текст
Ответ на Re: Error on CLUSTER command  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Error on CLUSTER command  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
The number may change pointing to another index or stay the same.
The error persists if I repeat 3 or 4 times.  Usually after the
4th or 5th time the cluster is successful.

What is the risk of performing an upgrade to 7.4.19?

-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Friday, February 08, 2008 11:19 AM
To: Mark Steben
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Error on CLUSTER command

"Mark Steben" <msteben@autorevenue.com> writes:
> 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

If you repeat the command, does the error persist?  Does the number
stay the same?

> Again we are running 7.4.5.

Tsk tsk.  Why not 7.4.19, or at least some reasonably recent 7.4.x
update?

            regards, tom lane


В списке pgsql-admin по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Error on CLUSTER command
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Where to find information on the new HOT tables?