Re: Serious Crash last Friday

"Henrik Steffen" <steffen@city-map.de> writes:
> yes, you are right 16584 is the oid of the table altseiten, but the
> reltoastidxid is still 0.

Oh, my mistake --- you have to look at the toast table identified by
reltoastrelid, and then its reltoastidxid fingers the index.  For
example:

test72=# create table foo (t text);
CREATE
test72=# select oid,relname,relkind,reltoastrelid,reltoastidxid from pg_class order by oid desc limit 5;
  oid   |       relname       | relkind | reltoastrelid | reltoastidxid
--------+---------------------+---------+---------------+---------------
 812033 | pg_toast_812029_idx | i       |             0 |             0
 812031 | pg_toast_812029     | t       |             0 |        812033
 812029 | foo                 | r       |        812031 |             0
 812026 | manufacturer_z_key  | i       |             0 |             0
 812024 | manufacturer        | r       |             0 |             0
(5 rows)

Here, foo is the base table, pg_toast_812029 is its toast table,
pg_toast_812029_idx is the index.

            regards, tom lane