-- A setting that a release removed is refused with the library loaded, in a SET, ALTER ROLE and ALTER DATABASE alike, and is not there to SHOW
-- (sift.enable_col, declared in 3.0 and never read; sift.table_auto_defrag_dead_pct, without effect since 4.0). The text is the server's, for a reserved prefix.
CREATE EXTENSION pg_sift;
\set VERBOSITY default
SET sift.enable_col = off;
ERROR:  invalid configuration parameter name "sift.enable_col"
DETAIL:  "sift" is a reserved prefix.
SET sift.table_auto_defrag_dead_pct = 1;
ERROR:  invalid configuration parameter name "sift.table_auto_defrag_dead_pct"
DETAIL:  "sift" is a reserved prefix.
SHOW sift.enable_col;
ERROR:  unrecognized configuration parameter "sift.enable_col"
SHOW sift.table_auto_defrag_dead_pct;
ERROR:  unrecognized configuration parameter "sift.table_auto_defrag_dead_pct"
RESET sift.enable_col;
ERROR:  invalid configuration parameter name "sift.enable_col"
DETAIL:  "sift" is a reserved prefix.
ALTER ROLE CURRENT_USER SET sift.enable_col = off;
ERROR:  invalid configuration parameter name "sift.enable_col"
DETAIL:  "sift" is a reserved prefix.
SELECT format('ALTER DATABASE %I SET sift.table_auto_defrag_dead_pct = 1', current_database()) AS alter_db \gset
:alter_db;
ERROR:  invalid configuration parameter name "sift.table_auto_defrag_dead_pct"
DETAIL:  "sift" is a reserved prefix.
-- the switches that stay
SET sift.enable_col_scan = off;
SET sift.enable_agg = off;
RESET sift.enable_col_scan;
RESET sift.enable_agg;
DROP EXTENSION pg_sift;