Re: Duplicate indexes found in the postgres Database

Tom,

User was able to recreate the problem, but this time only on table got
duplicated 'gui_config'. So here is the info you wanted:

select ctid,xmin,xmax,oid,* from pg_class where relname = 'gui_config';
  ctid  | xmin | xmax |  oid  |  relname   | reltype | relowner | relam |
relfilenode | relpages | reltuples | reltoastrelid | reltoastidxid |
relhasindex | relisshared | relkind | relnatts | relchecks | reltriggers |
relukeys | relfkeys | relrefs | relhasoids | relhaspkey | relhasrules |
relhassubclass |        relacl
--------+------+------+-------+------------+---------+----------+-------+---
----------+----------+-----------+---------------+---------------+----------
---+-------------+---------+----------+-----------+-------------+----------+
----------+---------+------------+------------+-------------+---------------
-+-----------------------
 (2,54) |  176 |  191 | 16560 | gui_config |   16561 |      101 |     0 |
16560 |       10 |      1000 |             0 |             0 | t           |
f           | r       |        2 |         0 |           0 |        0 |
0 |       0 | t          | t          | f           | f              |
{=,aesop_gui=arwdRxt}
 (2,56) |  191 |  206 | 16560 | gui_config |   16561 |      101 |     0 |
16560 |       10 |      1000 |             0 |             0 | t           |
f           | r       |        2 |         0 |           0 |        0 |
0 |       0 | t          | t          | f           | f              |
{=,aesop_gui=arwdRxt}
(2 rows)


-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Saturday, February 01, 2003 12:42 PM
To: Chris White
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Duplicate indexes found in the postgres Database


"Chris White" <cjwhite@cisco.com> writes:
> How do I look at the catalogs and which ones do I need to look at?

Now that I look at it, pg_tables is not a join in 7.2, but just a
straight select from pg_class.  So the problem is definitely in
pg_class.  Let's see the results of

select ctid,xmin,xmax,oid,* from pg_class where relname = 'vm_message';

and similarly for the other duplicates.

> No we haven't seen any system crashes, but people have reported that the
> tables that are duplicated are possibly missing some data.

Hm.  Trying to avoid theorizing in advance of the data...

            regards, tom lane