Re: Selecting names of indexes that are not dependent on constraints.

От:

Tom Lane <tgl@sss.pgh.pa.us>

Дата:

11 марта 2010 г. в 11:35:01

Selecting names of indexes that are not dependent on constraints.

От:

Dmitriy Igrishin <dmitigr@gmail.com>

Дата:

11 марта 2010 г. в 11:16:10

Re: Selecting names of indexes that are not dependent on constraints.

От:

Dmitriy Igrishin <dmitigr@gmail.com>

Дата:

11 марта 2010 г. в 11:21:31

Of course, I meant the indexes of which constraints do not depend. :)

2010/3/11 Dmitriy Igrishin <dmitigr@gmail.com>

Hey all,

How can I select names of indexes of table (or even whole schema) that are not dependent on constraints?

Unfortunately there is no way to select only "independent" indexes from pg_indexes view.

How can I do it?

Regards,
Dmitriy Igrishin