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
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. |