Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #2452: Error w/ pg_restore and blobs - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #2452: Error w/ pg_restore and blobs
Date
Msg-id 2194.1148505662@sss.pgh.pa.us
Whole thread Raw
In response to BUG #2452: Error w/ pg_restore and blobs  ("Robert Treat" <xzilla@users.sourceforge.net>)
List pgsql-bugs
Tree view 
"Robert Treat" <xzilla@users.sourceforge.net> writes:
> [root@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

pgsql-bugs by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: "blah" is not a domain error
Next
From: Tom Lane
Date:
Subject: Re: "blah" is not a domain error