pg_stat_kcache icon indicating copy to clipboard operation
pg_stat_kcache copied to clipboard

Using schema for placing pg_stat_statements and pg_stat_kcache

Open shab2 opened this issue 9 months ago • 1 comments

Hello! If I install extension pg_stat_statement into schema pgss, then I have error:

CREATE EXTENSION pg_stat_statements SCHEMA pgss;
CREATE EXTENSION pg_stat_kcache SCHEMA pgsk;
ERROR:  relation "pg_stat_statements" does not exist

But as you can see

show search_path;
                     search_path
-----------------------------------------------------
 "$user", public, pg_profile, pgsk, pgws, pgss, pgps

Is it possible to resolve it?

shab2 avatar Apr 26 '24 11:04 shab2