reserve ivorysql prefix for configs

yasir-hussain-shah · yasir-hussain-shah · commit f350796995b5 · 2026-02-26T10:24:17.000+05:00
diff --git a/contrib/ivorysql_ora/expected/ora_misc_functions.out b/contrib/ivorysql_ora/expected/ora_misc_functions.out
@@ -4181,3 +4181,10 @@ reset nls_date_format;
 reset nls_timestamp_format;
 reset nls_timestamp_tz_format;
 reset default_text_search_config;
+-- should throw errors, because dummy_config is not a valid configuration name
+set ivorysql.dummy_config to dummy;
+ERROR:  invalid configuration parameter name "ivorysql.dummy_config"
+DETAIL:  "ivorysql" is a reserved prefix.
+reset ivorysql.dummy_config;
+ERROR:  invalid configuration parameter name "ivorysql.dummy_config"
+DETAIL:  "ivorysql" is a reserved prefix.
diff --git a/contrib/ivorysql_ora/sql/ora_misc_functions.sql b/contrib/ivorysql_ora/sql/ora_misc_functions.sql
@@ -2345,3 +2345,6 @@ reset nls_date_format;
 reset nls_timestamp_format;
 reset nls_timestamp_tz_format;
 reset default_text_search_config;
+-- should throw errors, because dummy_config is not a valid configuration name
+set ivorysql.dummy_config to dummy;
+reset ivorysql.dummy_config;
diff --git a/contrib/ivorysql_ora/src/ivorysql_ora.c b/contrib/ivorysql_ora/src/ivorysql_ora.c
@@ -113,6 +113,8 @@ _PG_init(void)
 	/* ProcessUtility hook for DISCARD ALL/PACKAGES */
 	prev_ProcessUtility_hook = ProcessUtility_hook;
 	ProcessUtility_hook = ivorysql_ora_ProcessUtility;
+
+	MarkGUCPrefixReserved("ivorysql");
 }
 
 /*

Original file line number	Diff line number	Diff line change
`@@ -113,6 +113,8 @@ _PG_init(void)`
`113`	`113`	`/* ProcessUtility hook for DISCARD ALL/PACKAGES */`
`114`	`114`	`prev_ProcessUtility_hook = ProcessUtility_hook;`
`115`	`115`	`ProcessUtility_hook = ivorysql_ora_ProcessUtility;`
	`116`	`+`
	`117`	`+ MarkGUCPrefixReserved("ivorysql");`
`116`	`118`	`}`
`117`	`119`
`118`	`120`	`/*`