On 6/02/2012 4:39 AM, Tom Lane wrote:
Pat Heuvel <pheuvel@tpg.com.au> 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
ERROR: could not create unique index "pg_largeobject_loid_pn_index"
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.