Re: Postgres will not start due to corrupt index

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Igor Neyman <ineyman(at)perceptron(dot)com>
Cc: Robert Sosinski <rsosinski(at)ticketevolution(dot)com>, Merlin Moncure <mmoncure(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>, "Spike Grobstein" <spike(at)ticketevolution(dot)com>
Subject: Re: Postgres will not start due to corrupt index
Date: 2012-10-03 18:46:31
Message-ID: 18941.1349289991@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Igor Neyman <ineyman(at)perceptron(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2012-10-03 18:50:28 Re: surprising behavior or nothing to see here?
Previous Message Tom Lane 2012-10-03 18:30:07 Re: Sequence and Schema permissions information schema