equal
deleted
inserted
replaced
715 JOIN pg_catalog.pg_class c2 ON i.indrelid = c2.oid |
715 JOIN pg_catalog.pg_class c2 ON i.indrelid = c2.oid |
716 LEFT JOIN pg_catalog.pg_user u ON u.usesysid = c.relowner |
716 LEFT JOIN pg_catalog.pg_user u ON u.usesysid = c.relowner |
717 LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace |
717 LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace |
718 WHERE c.relkind IN ('i','') |
718 WHERE c.relkind IN ('i','') |
719 AND c2.relname = '%s' |
719 AND c2.relname = '%s' |
|
720 AND i.indisprimary = FALSE |
720 AND n.nspname NOT IN ('pg_catalog', 'pg_toast') |
721 AND n.nspname NOT IN ('pg_catalog', 'pg_toast') |
721 AND pg_catalog.pg_table_is_visible(c.oid);''' % tablename |
722 AND pg_catalog.pg_table_is_visible(c.oid);''' % tablename |
722 indexes_list = self.cnx.system_sql(sql).fetchall() |
723 indexes_list = self.cnx.system_sql(sql).fetchall() |
723 indexes = {} |
724 indexes = {} |
724 for name, in indexes_list: |
725 for name, in indexes_list: |