From c76cb771053c8e50a16b7991ae80a9f8ab969119 Mon Sep 17 00:00:00 2001
From: Tom Lane <tgl@sss.pgh.pa.us>
Date: Wed, 24 May 2006 21:20:11 +0000
Subject: [PATCH] Fix pg_restore to process BLOB COMMENT entries correctly;
they aren't really tables and shouldn't get DISABLE TRIGGER processing. Per
bug #2452 from Robert Treat.
---
src/bin/pg_dump/pg_backup_archiver.c | 7 ++++---
1 file changed, 4 insertions(+), 3 deletions(-)
diff --git a/src/bin/pg_dump/pg_backup_archiver.c b/src/bin/pg_dump/pg_backup_archiver.c
index 55cbf64bd0..4db4e4b9e3 100644
--- a/src/bin/pg_dump/pg_backup_archiver.c
+++ b/src/bin/pg_dump/pg_backup_archiver.c
@@ -15,7 +15,7 @@
*
*
* IDENTIFICATION
- * $PostgreSQL: pgsql/src/bin/pg_dump/pg_backup_archiver.c,v 1.128 2006/05/22 11:21:54 petere Exp $
+ * $PostgreSQL: pgsql/src/bin/pg_dump/pg_backup_archiver.c,v 1.129 2006/05/24 21:20:11 tgl Exp $
*
*-------------------------------------------------------------------------
*/
@@ -312,9 +312,10 @@ RestoreArchive(Archive *AHX, RestoreOptions *ropt)
_printTocEntry(AH, te, ropt, true, false);
- if (strcmp(te->desc, "BLOBS") == 0)
+ if (strcmp(te->desc, "BLOBS") == 0 ||
+ strcmp(te->desc, "BLOB COMMENTS") == 0)
{
- ahlog(AH, 1, "restoring large object data\n");
+ ahlog(AH, 1, "restoring %s\n", te->desc);
_selectOutputSchema(AH, "pg_catalog");
--
2.40.0