This trivial patches fixes the error message returned by CREATE INDEX

bmomjian · bmomjian · commit fbb1966cf312 · 2002-08-28T20:46:47.000Z
when it finds an existing relation with the same name as the
to-be-created index.

Old error message:

nconway=# create table foo (a int);
CREATE TABLE
nconway=# create index foo on foo (a);
ERROR:  index named "foo" already exists

I replaced 'index' with 'relation' in the error message.

Neil Conway
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.189 2002/08/11 21:17:34 tgl Exp $
+ *	  $Header: /cvsroot/pgsql/src/backend/catalog/index.c,v 1.190 2002/08/28 20:46:47 momjian Exp $
  *
  *
  * INTERFACE ROUTINES
@@ -561,7 +561,7 @@ index_create(Oid heapRelationId,
 		elog(ERROR, "Shared indexes cannot be created after initdb");
 
 	if (get_relname_relid(indexRelationName, namespaceId))
-		elog(ERROR, "index named \"%s\" already exists",
+		elog(ERROR, "relation named \"%s\" already exists",
 			 indexRelationName);
 
 	/*

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.189 2002/08/11 21:17:34 tgl Exp $`
	`11`	`+ * $Header: /cvsroot/pgsql/src/backend/catalog/index.c,v 1.190 2002/08/28 20:46:47 momjian Exp $`
`12`	`12`	`*`
`13`	`13`	`*`
`14`	`14`	`* INTERFACE ROUTINES`
`@@ -561,7 +561,7 @@ index_create(Oid heapRelationId,`
`561`	`561`	`elog(ERROR, "Shared indexes cannot be created after initdb");`
`562`	`562`
`563`	`563`	`if (get_relname_relid(indexRelationName, namespaceId))`
`564`		`- elog(ERROR, "index named \"%s\" already exists",`
	`564`	`+ elog(ERROR, "relation named \"%s\" already exists",`
`565`	`565`	`indexRelationName);`
`566`	`566`
`567`	`567`	`/*`