Lists: | pgsql-bugs |
---|
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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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.
From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | "Robert Treat" <xzilla(at)users(dot)sourceforge(dot)net> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #2452: Error w/ pg_restore and blobs |
Date: | 2006-05-24 21:21:02 |
Message-ID: | 2194.1148505662@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-bugs |
"Robert Treat" <xzilla(at)users(dot)sourceforge(dot)net> writes:
> [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;
Dealt with, thanks for report.
regards, tom lane