Re: [ADMIN] No restore of BLOB data (permissions?)

From: Tom Lane <tgl(at)sss.pgh.pa.us>
Date: Wed Aug 29 2007 - 10:49:26 EDT

Jordi Mulet <jmuletalbiach@yahoo.com> writes:
> Info on log file:
> 2007-08-29 08:46:52 ERROR: duplicate key violates unique constraint "pg_lar=
> geobject_loid_pn_index"

So the problem is you've already *got* that blob, or at least one with the same OID, in the target database. Try restoring into an empty database.

                        regards, tom lane

---------------------------(end of broadcast)---------------------------

TIP 7: You can help support the PostgreSQL project by donating at

                
http://www.postgresql.org/about/donate

Received on Wed Aug 29 10:52:02 2007