Disallow to create multi-column indices using non-btree.

vadim4o · vadim4o · commit 3be7ecb2e4e4 · 1997-03-26T03:05:28.000Z
diff --git a/src/backend/commands/defind.c b/src/backend/commands/defind.c
@@ -7,7 +7,7 @@
  *
  *
  * IDENTIFICATION
- *    $Header: /cvsroot/pgsql/src/backend/commands/Attic/defind.c,v 1.11 1997/03/19 07:52:03 vadim Exp $
+ *    $Header: /cvsroot/pgsql/src/backend/commands/Attic/defind.c,v 1.12 1997/03/26 03:05:28 vadim Exp $
  *
  *-------------------------------------------------------------------------
  */
@@ -107,7 +107,10 @@ DefineIndex(char *heapRelationName,
     relationId = tuple->t_oid;
 
     if (unique && strcmp(accessMethodName,"btree") != 0)
-	elog(WARN, "DefineIndex: unique indexes are only available with the btree access method");
+	elog(WARN, "DefineIndex: unique indices are only available with the btree access method");
+
+    if (numberOfAttributes > 1 && strcmp(accessMethodName,"btree") != 0)
+	elog(WARN, "DefineIndex: multi-column indices are only available with the btree access method");
 
     /*
      * compute access method id

Original file line number	Diff line number	Diff line change
`@@ -7,7 +7,7 @@`
`7`	`7`	`*`
`8`	`8`	`*`
`9`	`9`	`* IDENTIFICATION`
`10`		`- * $Header: /cvsroot/pgsql/src/backend/commands/Attic/defind.c,v 1.11 1997/03/19 07:52:03 vadim Exp $`
	`10`	`+ * $Header: /cvsroot/pgsql/src/backend/commands/Attic/defind.c,v 1.12 1997/03/26 03:05:28 vadim Exp $`
`11`	`11`	`*`
`12`	`12`	`*-------------------------------------------------------------------------`
`13`	`13`	`*/`
`@@ -107,7 +107,10 @@ DefineIndex(char *heapRelationName,`
`107`	`107`	`relationId = tuple->t_oid;`
`108`	`108`
`109`	`109`	`if (unique && strcmp(accessMethodName,"btree") != 0)`
`110`		`- elog(WARN, "DefineIndex: unique indexes are only available with the btree access method");`
	`110`	`+ elog(WARN, "DefineIndex: unique indices are only available with the btree access method");`
	`111`	`+`
	`112`	`+ if (numberOfAttributes > 1 && strcmp(accessMethodName,"btree") != 0)`
	`113`	`+ elog(WARN, "DefineIndex: multi-column indices are only available with the btree access method");`
`111`	`114`
`112`	`115`	`/*`
`113`	`116`	`* compute access method id`