From fbb1966cf3125f07220a546bf424df73327fe47f Mon Sep 17 00:00:00 2001
From: Bruce Momjian <bruce@momjian.us>
Date: Wed, 28 Aug 2002 20:46:47 +0000
Subject: [PATCH] This trivial patches fixes the error message returned by
 CREATE INDEX 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
---
 src/backend/catalog/index.c | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/src/backend/catalog/index.c b/src/backend/catalog/index.c
index e47a9b42892..474040f5fcf 100644
--- 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);
 
 	/*
-- 
2.39.5