CLUSTER makes table vanish :(

From: Brian Martin <brian(at)theory(dot)org>
To: pgsql-bugs(at)postgresql(dot)org
Subject: CLUSTER makes table vanish :(
Date: 2000-08-11 04:27:00
Message-ID: 20000810212700.C12191@theory.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi everybody,

I don't seem to have a copy of the bug template, so here goes.

In the process of trying to optimize some queries I'm doing, I
tried a CLUSTER command:

cluster track_instance_idx2 on track_instance;

It failed with this error:

ERROR: temp_258c0 is an index relation

Now I wasn't all that surprised because it was the first time I've
tried to use CLUSTER. The surprising thing is that after doing this,
the track_instance table vanished. Any reference to it gives me

ERROR: Relation 'track_instance' does not exist

This is somewhat troubling, as I'm lazy and don't have a recent dump handy.

it appears to have dissapeared from pg_tables:

djukebox=# select * from pg_tables where tablename = 'track_instance';
tablename | tableowner | hasindexes | hasrules | hastriggers
-----------+------------+------------+----------+-------------
(0 rows)

But is still in /usr/local/pgsql/data/base/djukebox:

garth:/usr/local/pgsql/data/base/djukebox# ls track_instance*
track_instance

So the file is still there, but none of my indices for that table are.
(They all started with track_instance as well).

Can anyone shed some light on this situation? I'm running pogstres 7.0.0
on a reasonably up to date debian gnu/linux system (2.2.16 kernel, libc 2.0.7,
etc).

thanks,
Brian

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Paulo Roberto Siqueira 2000-08-11 14:30:25 Wrong link
Previous Message Andrei N.Sobchuck 2000-08-10 11:52:57 Segmentation fault.