Re: Postgres will not start due to corrupt index - Mailing list pgsql-general

> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
> Sent: Wednesday, October 03, 2012 2:47 PM
> To: Igor Neyman
> Cc: Robert Sosinski; Merlin Moncure; pgsql-general@postgresql.org;
> Spike Grobstein
> Subject: Re: [GENERAL] Postgres will not start due to corrupt index
>
> Igor Neyman <ineyman@perceptron.com> writes:
> > I wonder if there is a column in pg catalog, that indicates the type
> of the index.  I couldn't find one.
>
> join relam to pg_am.oid
>
> > So, I ran the following sql trying to find system indexes of gin or
> gist type:
>
> There aren't any.
>
>             regards, tom lane

Tom, thank you.

In this case:

select i.indexname, a.amname, i.tablename from pg_indexes i JOIN
(pg_class c join pg_am a ON (c.relam = a.oid) ) ON (i.indexname = c.relname)
WHERE i.schemaname = 'pg_catalog';

Regards,
Igor Neyman