Dump statistic issue with index on expressions
Maksim.Melnikov <m.melnikov@postgrespro.ru>
From: "Maksim.Melnikov" <m.melnikov@postgrespro.ru>
To: pgsql-hackers@lists.postgresql.org
Date: 2026-02-25T16:37:24Z
Lists: pgsql-hackers
Attachments
- 0001-Dump-statistic-issue-with-index-on-expressions.patch (text/x-patch) patch 0001
Hi hackers. There is an issue on new feature dump statistics related to index processing. In case when table has more then one index and if one of them is index on expressions we can get error like this: pg_dump --verbose --statistics-only > /dev/null ... pg_dump: reading subscriptions pg_dump: reading subscription membership of tables pg_dump: reading dependency data pg_dump: saving encoding = UTF8 pg_dump: saving "standard_conforming_strings = on" pg_dump: saving "search_path = " pg_dump: error: could not find index attname "source_system" For clarity, schema ddl attached CREATE TABLE test_table_stats ( id uuid NOT NULL, body jsonb, source_system character varying, source_id character varying, model_name character varying NOT NULL ); CREATE INDEX test_table_stats_source_system_text ON test_table_stats USING btree (upper((source_system)::text)); CREATE UNIQUE INDEX test_table_stats_json_system_un ON test_table_stats USING btree (source_system, source_id, model_name); When pg_dump sequentially process indexes in case when index is processed after index on expression, it can use index attrs names of previously processed index. I've attached simple patch to fix it. Best regards Melnikov Maksim
Commits
-
pg_dump: scope indAttNames per index in getIndexes()
- 298bdd379552 19 (unreleased) landed
- 94c02de89c26 18 (unreleased) landed