dataimport/massive_store.py
changeset 11019 36838a012ccc
parent 11018 1df243392d45
child 11020 c8c8f6a6147f
equal deleted inserted replaced
11018:1df243392d45 11019:36838a012ccc
   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: