Re: BLOBS (ODBC lo object) and pg_restore - Mailing list pgsql-general

Jason Godden <jasongodden@optushome.com.au> writes:
> ./pg_restore -p5431 -dsomedb -Ft -N -X disable-triggers
> /var/db/backup/data.tar
> ERROR: Relation "BLOBs" does not exist

Here's the patch if you need it.

            regards, tom lane

*** src/bin/pg_dump/pg_backup_archiver.c~    Sat Feb  1 17:07:14 2003
--- src/bin/pg_dump/pg_backup_archiver.c    Sun Mar  9 14:36:40 2003
***************
*** 293,299 ****
                       * Maybe we can't do BLOBS, so check if this node is
                       * for BLOBS
                       */
!                     if ((strcmp(te->desc, "BLOBS") == 0) && !_canRestoreBlobs(AH))
                      {
                          ahprintf(AH, "--\n-- SKIPPED \n--\n\n");

--- 293,300 ----
                       * Maybe we can't do BLOBS, so check if this node is
                       * for BLOBS
                       */
!                     if ((strcmp(te->desc, "BLOBS") == 0) &&
!                         !_canRestoreBlobs(AH))
                      {
                          ahprintf(AH, "--\n-- SKIPPED \n--\n\n");

***************
*** 445,450 ****
--- 446,455 ----
      if (!ropt->dataOnly || !ropt->disable_triggers)
          return;

+     /* Don't do it for the BLOBS TocEntry, either */
+     if (te && strcmp(te->desc, "BLOBS") == 0)
+         return;
+
      oldUser = strdup(AH->currUser);
      oldSchema = strdup(AH->currSchema);

***************
*** 506,511 ****
--- 511,520 ----

      /* This hack is only needed in a data-only restore */
      if (!ropt->dataOnly || !ropt->disable_triggers)
+         return;
+
+     /* Don't do it for the BLOBS TocEntry, either */
+     if (te && strcmp(te->desc, "BLOBS") == 0)
          return;

      oldUser = strdup(AH->currUser);