Dmitriy Igrishin 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 two. Be careful t
Of course, I meant the indexes of which constraints do not depend. :)
2010/3/11 Dmitriy Igrishin
> 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
>
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
