Disable creation of indexes on system tables.

bmomjian · bmomjian · commit 97c04fad822c · 2001-04-02T14:34:25.000Z
diff --git a/src/backend/catalog/index.c b/src/backend/catalog/index.c
@@ -8,7 +8,7 @@
  *
  *
  * IDENTIFICATION
- *	  $Header: /cvsroot/pgsql/src/backend/catalog/index.c,v 1.144 2001/03/22 06:16:10 momjian Exp $
+ *	  $Header: /cvsroot/pgsql/src/backend/catalog/index.c,v 1.145 2001/04/02 14:34:25 momjian Exp $
  *
  *
  * INTERFACE ROUTINES
@@ -864,6 +864,10 @@ index_create(char *heapRelationName,
 		indexInfo->ii_NumKeyAttrs < 1)
 		elog(ERROR, "must index at least one attribute");
 
+	if (heapRelationName && !allow_system_table_mods &&
+		IsSystemRelationName(heapRelationName) && IsNormalProcessingMode())
+		elog(ERROR, "User-defined indexes on system catalogs are not supported");
+
 	/*
 	 * get heap relation oid and open the heap relation
 	 */

Original file line number	Diff line number	Diff line change
`@@ -8,7 +8,7 @@`
`8`	`8`	`*`
`9`	`9`	`*`
`10`	`10`	`* IDENTIFICATION`
`11`		`- * $Header: /cvsroot/pgsql/src/backend/catalog/index.c,v 1.144 2001/03/22 06:16:10 momjian Exp $`
	`11`	`+ * $Header: /cvsroot/pgsql/src/backend/catalog/index.c,v 1.145 2001/04/02 14:34:25 momjian Exp $`
`12`	`12`	`*`
`13`	`13`	`*`
`14`	`14`	`* INTERFACE ROUTINES`
`@@ -864,6 +864,10 @@ index_create(char *heapRelationName,`
`864`	`864`	`indexInfo->ii_NumKeyAttrs < 1)`
`865`	`865`	`elog(ERROR, "must index at least one attribute");`
`866`	`866`
	`867`	`+ if (heapRelationName && !allow_system_table_mods &&`
	`868`	`+ IsSystemRelationName(heapRelationName) && IsNormalProcessingMode())`
	`869`	`+ elog(ERROR, "User-defined indexes on system catalogs are not supported");`
	`870`	`+`
`867`	`871`	`/*`
`868`	`872`	`* get heap relation oid and open the heap relation`
`869`	`873`	`*/`