On Mon, Jun 3, 2024 at 12:14 PM jian he <jian.universal...@gmail.com> wrote: > > hi. > > ---- setup > drop table if exist test__int cascade; > create extension intarray; > > CREATE TABLE test__int( a int[] ); > CREATE INDEX text_idx on test__int using gist (a gist__intbig_ops(siglen = > 1)); > drop extension intarray cascade; > NOTICE: drop cascades to index text_idx > 2024-06-03 11:53:32.629 CST [41165] ERROR: cache lookup failed for > function 17758 > 2024-06-03 11:53:32.629 CST [41165] STATEMENT: drop extension intarray > cascade; > ERROR: cache lookup failed for function 17758 >
> ------------------------------------------------ extension (ltree, pg_trgm) also have the same problem. drop table if exists t2 cascade; CREATE EXTENSION ltree; CREATE TABLE t2 (t ltree); create index tstidx on t2 using gist (t gist_ltree_ops(siglen=4)); drop extension ltree cascade; drop table if exists t3 cascade; CREATE EXTENSION pg_trgm; CREATE TABLE t3(t text COLLATE "C"); create index trgm_idx on t3 using gist (t gist_trgm_ops(siglen=1)); drop extension pg_trgm cascade; > ------------------------------------------------ extension hstore work as expected, no error. drop table if exists t1 cascade; create extension hstore; CREATE TABLE t1 (h hstore); create index hidx on t1 using gist(h gist_hstore_ops(siglen=1)); drop extension hstore cascade; on the master branch. i didn't test on other branches.