Index: src/backend/utils/adt/ruleutils.c
===================================================================
RCS file: /cvsroot/pgsql/src/backend/utils/adt/ruleutils.c,v
retrieving revision 1.92
diff -c -r1.92 ruleutils.c
*** src/backend/utils/adt/ruleutils.c	6 Mar 2002 19:58:26 -0000	1.92
--- src/backend/utils/adt/ruleutils.c	8 Mar 2002 04:45:51 -0000
***************
*** 395,405 ****
  	 * Start the index definition
  	 */
  	initStringInfo(&buf);
! 	appendStringInfo(&buf, "CREATE %sINDEX %s ON %s USING %s (",
  					 idxrec->indisunique ? "UNIQUE " : "",
  					 quote_identifier(NameStr(idxrelrec->relname)),
! 					 quote_identifier(NameStr(indrelrec->relname)),
  					 quote_identifier(NameStr(amrec->amname)));
  
  	/*
  	 * Collect the indexed attributes in keybuf
--- 395,410 ----
  	 * Start the index definition
  	 */
  	initStringInfo(&buf);
! 	appendStringInfo(&buf, "CREATE %sINDEX %s ON %s ",
  					 idxrec->indisunique ? "UNIQUE " : "",
  					 quote_identifier(NameStr(idxrelrec->relname)),
! 					 quote_identifier(NameStr(indrelrec->relname)));
! 
! 	if (strcmp(NameStr(amrec->amname), "btree") != 0)
! 		appendStringInfo(&buf, "USING %s ",
  					 quote_identifier(NameStr(amrec->amname)));
+ 
+ 	appendStringInfo(&buf, "(");
  
  	/*
  	 * Collect the indexed attributes in keybuf