Re: BUG #2452: Error w/ pg_restore and blobs

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
Thread:
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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2006-05-24 21:29:34 Re: "blah" is not a domain error
Previous Message Jim C. Nasby 2006-05-24 21:18:24 "blah" is not a domain error