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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: No restore of BLOB data (permissions?)



Jordi Mulet <jmuletalbiach(at)yahoo(dot)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



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group