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

From Tom Lane
Subject Re: Postgres will not start due to corrupt index
Date
Msg-id 18941.1349289991@sss.pgh.pa.us
Whole thread Raw
In response to Re: Postgres will not start due to corrupt index  (Igor Neyman <ineyman@perceptron.com>)
Responses Re: Postgres will not start due to corrupt index  (Igor Neyman <ineyman@perceptron.com>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Sequence and Schema permissions information schema
Next
From: Tom Lane
Date:
Subject: Re: surprising behavior or nothing to see here?