diff options
| author | Bruce Momjian <bruce@momjian.us> | 2003-02-03 15:17:24 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2003-02-03 15:17:24 +0000 |
| commit | 6b196c07549523601aebf14b6b0c0e7603a0ad4d (patch) | |
| tree | 4f4eec32a62eab312745f96ca8f0322663162bbc /src | |
| parent | 4cff59d8d540c441fb0c22dfaa517bc25aa5f794 (diff) | |
| download | postgresql-6b196c07549523601aebf14b6b0c0e7603a0ad4d.tar.gz postgresql-6b196c07549523601aebf14b6b0c0e7603a0ad4d.zip | |
Don't print NO ACTION foreign key actions in dumps and psql \d.
Diffstat (limited to 'src')
| -rw-r--r-- | src/backend/utils/adt/ruleutils.c | 12 |
1 files changed, 7 insertions, 5 deletions
diff --git a/src/backend/utils/adt/ruleutils.c b/src/backend/utils/adt/ruleutils.c index d7474b4d7f7..df5890358b8 100644 --- a/src/backend/utils/adt/ruleutils.c +++ b/src/backend/utils/adt/ruleutils.c @@ -3,7 +3,7 @@ * back to source text * * IDENTIFICATION - * $Header: /cvsroot/pgsql/src/backend/utils/adt/ruleutils.c,v 1.132 2003/01/10 21:08:15 tgl Exp $ + * $Header: /cvsroot/pgsql/src/backend/utils/adt/ruleutils.c,v 1.133 2003/02/03 15:17:24 momjian Exp $ * * This software is copyrighted by Jan Wieck - Hamburg. * @@ -642,7 +642,7 @@ pg_get_constraintdef(PG_FUNCTION_ARGS) switch (conForm->confupdtype) { case FKCONSTR_ACTION_NOACTION: - string = "NO ACTION"; + string = ""; break; case FKCONSTR_ACTION_RESTRICT: string = "RESTRICT"; @@ -662,12 +662,13 @@ pg_get_constraintdef(PG_FUNCTION_ARGS) string = ""; /* keep compiler quiet */ break; } - appendStringInfo(&buf, " ON UPDATE %s", string); + if (strlen(string) != 0) + appendStringInfo(&buf, " ON UPDATE %s", string); switch (conForm->confdeltype) { case FKCONSTR_ACTION_NOACTION: - string = "NO ACTION"; + string = ""; break; case FKCONSTR_ACTION_RESTRICT: string = "RESTRICT"; @@ -687,7 +688,8 @@ pg_get_constraintdef(PG_FUNCTION_ARGS) string = ""; /* keep compiler quiet */ break; } - appendStringInfo(&buf, " ON DELETE %s", string); + if (strlen(string) != 0) + appendStringInfo(&buf, " ON DELETE %s", string); if (conForm->condeferrable) appendStringInfo(&buf, " DEFERRABLE"); |