'k, I've been playing around with the REINDEX stuff, and either I'm mis-understanding something, or there is a bug in 7.4.x ...

If I do a:

REINDEX TABLE pg_statistic;

my 'on disk' INDEX is disappearing, altho there is no errors being generated:

# select oid,relname from pg_class where relname like 'pg_statistic%';
  oid  |           relname
-------+------------------------------
 16408 | pg_statistic
 16647 | pg_statistic_relid_att_index
(2 rows)

But, on disk:

$ ls -l 16408 16647
ls: 16647: No such file or directory
-rw-------  1 pgsql pgsql 385024 Jun 13 15:28 16408

# reindex table pg_statistic;
REINDEX
#

Shouldn't this work?  Or, at least, generate an error message?

----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: [EMAIL PROTECTED]           Yahoo!: yscrappy              ICQ: 7615664

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

              http://archives.postgresql.org

Reply via email to