Skip site navigation (1) Skip section navigation (2)

BUG #2452: Error w/ pg_restore and blobs

From: "Robert Treat" <xzilla(at)users(dot)sourceforge(dot)net>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2452: Error w/ pg_restore and blobs
Date: 2006-05-24 13:34:52
Message-ID: 200605241334.k4ODYqlV053787@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      2452
Logged by:          Robert Treat
Email address:      xzilla(at)users(dot)sourceforge(dot)net
PostgreSQL version: 8.1
Operating system:   Fedora Core 4
Description:        Error w/ pg_restore and blobs
Details: 

[root(at)localhost ~]# time pg_restore -U postgres -a --disable-triggers -Fc
mojo.pgr -d mojo
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 4261; 0 0 BLOB COMMENTS
BLOB COMMENTS
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "BLOB
COMMENTS" does not exist
    Command was: ALTER TABLE "BLOB COMMENTS" DISABLE TRIGGER ALL;
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "BLOB
COMMENTS" does not exist
    Command was:
ALTER TABLE "BLOB COMMENTS" ENABLE TRIGGER ALL;
WARNING: errors ignored on restore: 2

real    220m31.582s
user    28m43.769s
sys     14m57.497s
[root(at)localhost ~]#


Relevant lines from my restore file are:

[root(at)localhost ~]# pg_restore -U postgres -Fc mojo.pgr -l | grep BLOB
4260; 0 0 BLOBS - BLOBS
4261; 0 0 BLOB COMMENTS - BLOB COMMENTS

This doesn't really cause any problem for me personally, but seems like it
isn't right, though I couldn't discern if the problem was with pg_restore
misinterpreting the blob comments line or pg_dump adding the line
erroneously.

Responses

pgsql-bugs by date

Next:From: Jim C. NasbyDate: 2006-05-24 21:18:24
Subject: "blah" is not a domain error
Previous:From: Michael FuhrDate: 2006-05-23 15:51:18
Subject: Re: BUG #2451: Short column names return no values within function

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group