33 *back to source text
44 *
55 * IDENTIFICATION
6- * $Header: /cvsroot/pgsql/src/backend/utils/adt/ruleutils.c,v 1.132 2003/01/10 21:08:15 tgl Exp $
6+ * $Header: /cvsroot/pgsql/src/backend/utils/adt/ruleutils.c,v 1.133 2003/02/03 15:17:24 momjian Exp $
77 *
88 * This software is copyrighted by Jan Wieck - Hamburg.
99 *
@@ -642,7 +642,7 @@ pg_get_constraintdef(PG_FUNCTION_ARGS)
642642switch (conForm -> confupdtype )
643643{
644644case FKCONSTR_ACTION_NOACTION :
645- string = "NO ACTION " ;
645+ string = "" ;
646646break ;
647647case FKCONSTR_ACTION_RESTRICT :
648648string = "RESTRICT" ;
@@ -662,12 +662,13 @@ pg_get_constraintdef(PG_FUNCTION_ARGS)
662662string = "" ;/* keep compiler quiet */
663663break ;
664664}
665- appendStringInfo (& buf ," ON UPDATE %s" ,string );
665+ if (strlen (string )!= 0 )
666+ appendStringInfo (& buf ," ON UPDATE %s" ,string );
666667
667668switch (conForm -> confdeltype )
668669{
669670case FKCONSTR_ACTION_NOACTION :
670- string = "NO ACTION " ;
671+ string = "" ;
671672break ;
672673case FKCONSTR_ACTION_RESTRICT :
673674string = "RESTRICT" ;
@@ -687,7 +688,8 @@ pg_get_constraintdef(PG_FUNCTION_ARGS)
687688string = "" ;/* keep compiler quiet */
688689break ;
689690}
690- appendStringInfo (& buf ," ON DELETE %s" ,string );
691+ if (strlen (string )!= 0 )
692+ appendStringInfo (& buf ," ON DELETE %s" ,string );
691693
692694if (conForm -> condeferrable )
693695appendStringInfo (& buf ," DEFERRABLE" );