On 6/02/2012 4:39 AM, Tom Lane wrote:
ERROR: could not create unique index "pg_largeobject_loid_pn_index"Pat Heuvel <pheuvel@xxxxxxxxxx> writes:[ vacuumlo fails ] When I added the -v option, there were many "removing lo xxxxx" messages before the above messages appeared. I have previously tried to reindex pg_largeobject, but that process failed as well.You need to get the index consistent before trying vacuumlo; that program is not designed to deal with inconsistent catalogs. What exactly happens when you try to reindex pg_largeobject? regards, tom lane DETAIL: Table contains duplicated values. ********** Error ********** ERROR: could not create unique index "pg_largeobject_loid_pn_index" SQL state: 23505 Detail: Table contains duplicated values. |
