Re: BLOBS (ODBC lo object) and pg_restore

Jason Godden <jasongodden(at)optushome(dot)com(dot)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);