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
Of course, I meant the indexes of which constraints do not depend. :)
2010/3/11 Dmitriy Igrishin dmit...@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
Dmitriy Igrishin dmit...@gmail.com writes:
How can I select names of indexes of table (or even whole schema) that are
not dependent on constraints?
Right at the moment, the only reliable way to tell whether an index is
associated with a constraint is to look for a pg_depend entry linking
the