Index: src/backend/utils/adt/ruleutils.c
===================================================================
RCS file: /cvsroot/pgsql-server/src/backend/utils/adt/ruleutils.c,v
retrieving revision 1.132
diff -c -c -r1.132 ruleutils.c
*** src/backend/utils/adt/ruleutils.c	10 Jan 2003 21:08:15 -0000	1.132
--- src/backend/utils/adt/ruleutils.c	3 Feb 2003 14:57:33 -0000
***************
*** 642,648 ****
  				switch (conForm->confupdtype)
  				{
  					case FKCONSTR_ACTION_NOACTION:
! 						string = "NO ACTION";
  						break;
  					case FKCONSTR_ACTION_RESTRICT:
  						string = "RESTRICT";
--- 642,648 ----
  				switch (conForm->confupdtype)
  				{
  					case FKCONSTR_ACTION_NOACTION:
! 						string = "";
  						break;
  					case FKCONSTR_ACTION_RESTRICT:
  						string = "RESTRICT";
***************
*** 662,673 ****
  						string = "";	/* keep compiler quiet */
  						break;
  				}
! 				appendStringInfo(&buf, " ON UPDATE %s", string);
  
  				switch (conForm->confdeltype)
  				{
  					case FKCONSTR_ACTION_NOACTION:
! 						string = "NO ACTION";
  						break;
  					case FKCONSTR_ACTION_RESTRICT:
  						string = "RESTRICT";
--- 662,674 ----
  						string = "";	/* keep compiler quiet */
  						break;
  				}
! 				if (strlen(string) != 0)
! 					appendStringInfo(&buf, " ON UPDATE %s", string);
  
  				switch (conForm->confdeltype)
  				{
  					case FKCONSTR_ACTION_NOACTION:
! 						string = "";
  						break;
  					case FKCONSTR_ACTION_RESTRICT:
  						string = "RESTRICT";
***************
*** 687,693 ****
  						string = "";	/* keep compiler quiet */
  						break;
  				}
! 				appendStringInfo(&buf, " ON DELETE %s", string);
  
  				if (conForm->condeferrable)
  					appendStringInfo(&buf, " DEFERRABLE");
--- 688,695 ----
  						string = "";	/* keep compiler quiet */
  						break;
  				}
! 				if (strlen(string) != 0)
! 					appendStringInfo(&buf, " ON DELETE %s", string);
  
  				if (conForm->condeferrable)
  					appendStringInfo(&buf, " DEFERRABLE");
