Postgres Pro
Downloads
Home   >   mailing lists

cache lookup failed dropping public schema with trgm index - Mailing list pgsql-bugs

From Wyatt Alt
Subject cache lookup failed dropping public schema with trgm index
Date
Msg-id CAGem3qAM7M7B3DdccpgepRxuoKPd2Y74qJ5NSNRjLiN21dPhgg@mail.gmail.com
Whole thread Raw
Responses Re: cache lookup failed dropping public schema with trgm index  (Michael Paquier <michael@paquier.xyz>)
Re: cache lookup failed dropping public schema with trgm index  (Andres Freund <andres@anarazel.de>)
List pgsql-bugs
Tree view
Hi,

This reproduces on 15.4 and 13.12:

create table foo(t text);
create extension pg_trgm;
create index on foo using gist(t gist_trgm_ops);
drop schema public cascade;

NOTICE:  drop cascades to 2 other objects
DETAIL:  drop cascades to table foo
drop cascades to extension pg_trgm
ERROR:  cache lookup failed for function 1195999
Time: 20.968 ms

pgsql-bugs by date:

Previous
From: Andres Freund
Date:
Subject: Re: BUG #18055: logical decoding core on AllocateSnapshotBuilder()
Next
From: Michael Paquier
Date:
Subject: Re: Postgresql15 crash with :FATAL: could not open shared memory segment "/PostgreSQL.0000000": No such file or directory