分表的情况下会找不到ON CONFLICT(key)

[Snorlaxa]

Postgresql采用以下sql查找ON CONFLICT(key)，在分表的情况下会找不到key

select column_names from(
        select
            t.relname as table_name,
            i.relname as index_name,
            array_to_string(array_agg(a.attname), ', ') as column_names
        from
            pg_class t,
            pg_class i,
            pg_index ix,
            pg_attribute a
        where
            t.oid = ix.indrelid
            and i.oid = ix.indexrelid
            and a.attrelid = t.oid
            and a.attnum = ANY(ix.indkey)
            and t.relkind = 'r'
            and t.relname like '%'
        group by
            t.relname,
            i.relname
        order by
            t.relname,
            i.relname) as res
    where table_name = 'table_name';

查出的table_name会是子表的名称

[Boris-code]

我表示不会，你这边解决了么，可以提pr