Re: Selecting names of indexes that are not dependent on constraints. - Mailing list pgsql-sql

From Dmitriy Igrishin
Subject Re: Selecting names of indexes that are not dependent on constraints.
Date
Msg-id b4399d111003110720m4805d511pb468aefb0f3cd60c@mail.gmail.com
Whole thread Raw
In response to Selecting names of indexes that are not dependent on constraints.  (Dmitriy Igrishin <dmitigr@gmail.com>)
List pgsql-sql
Of course, I meant the indexes of which constraints do not depend. :)<br /><br /><div class="gmail_quote">2010/3/11
DmitriyIgrishin <span dir="ltr"><<a href="mailto:dmitigr@gmail.com">dmitigr@gmail.com</a>></span><br
/><blockquoteclass="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex;
padding-left:1ex;"> Hey all,<br /><br />How can I select names of indexes of table (or even whole schema) that are not
dependenton constraints?<br /><br />Unfortunately there is no way to select only "independent" indexes from pg_indexes
view.<br/><br />How can I do it?<br /><br />Regards,<br /><font color="#888888">Dmitriy Igrishin<br
/></font></blockquote></div><br/> 

pgsql-sql by date:

Previous
From: Dmitriy Igrishin
Date:
Subject: Selecting names of indexes that are not dependent on constraints.
Next
From: Tom Lane
Date:
Subject: Re: Selecting names of indexes that are not dependent on constraints.