postgres
diff --git a/‎src/bin/pg_dump/pg_backup_archiver.c
Copy file name to clipboardExpand all lines: src/bin/pg_dump/pg_backup_archiver.c
+7-2Lines changed: 7 additions & 2 deletions b/‎src/bin/pg_dump/pg_backup_archiver.c
Copy file name to clipboardExpand all lines: src/bin/pg_dump/pg_backup_archiver.c
+7-2Lines changed: 7 additions & 2 deletions
@@ -538,9 +538,14 @@ RestoreArchive(Archive *AHX)
 				 */
 				if (*te->dropStmt != '\0')
 				{
-					if (!ropt->if_exists)
+					if (!ropt->if_exists ||
+						strncmp(te->dropStmt, "--", 2) == 0)
 					{
-						/* No --if-exists?	Then just use the original */
+						/*
+						 * Without --if-exists, or if it's just a comment (as
+						 * happens for the public schema), print the dropStmt
+						 * as-is.
+						 */
 						ahprintf(AH, "%s", te->dropStmt);
 					}
 					else
Original file line number	Diff line number	Diff line change
`@@ -538,9 +538,14 @@ RestoreArchive(Archive *AHX)`
`538`	`538`	`*/`
`539`	`539`	`if (*te->dropStmt != '\0')`
`540`	`540`	`{`
`541`		`- if (!ropt->if_exists)`
	`541`	`+ if (!ropt->if_exists \|\|`
	`542`	`+ strncmp(te->dropStmt, "--", 2) == 0)`
`542`	`543`	`{`
`543`		`- /* No --if-exists? Then just use the original */`
	`544`	`+ /*`
	`545`	`+ * Without --if-exists, or if it's just a comment (as`
	`546`	`+ * happens for the public schema), print the dropStmt`
	`547`	`+ * as-is.`
	`548`	`+ */`
`544`	`549`	`ahprintf(AH, "%s", te->dropStmt);`
`545`	`550`	`}`
`546`	`551`	`else`