Horton

pg_dump_no_inherit_inherit_col.diff

text/x-patch

Download
Filename: pg_dump_no_inherit_inherit_col.diff
Type: text/x-patch
Part: 0
Message: persevere NO INHERIT when Dump not-null constraints on inherited columns

Patch

Format: unified
File+−
src/bin/pg_dump/pg_dump.c 3 0 
diff --git a/src/bin/pg_dump/pg_dump.c b/src/bin/pg_dump/pg_dump.c
index 450cec285b3..46a6794a57f 100644
--- a/src/bin/pg_dump/pg_dump.c
+++ b/src/bin/pg_dump/pg_dump.c
@@ -17421,6 +17421,9 @@ dumpTableSchema(Archive *fout, const TableInfo *tbinfo)
 						appendPQExpBuffer(q, "CONSTRAINT %s NOT NULL %s",
 										  tbinfo->notnull_constrs[j],
 										  fmtId(tbinfo->attnames[j]));
+
+					if (tbinfo->notnull_noinh[j])
+						appendPQExpBufferStr(q, " NO INHERIT");
 				}
 			}