Re: vacuumlo fails pgsql ver 8.3

On 6/02/2012 4:39 AM, Tom Lane wrote:
> Pat Heuvel<pheuvel(at)tpg(dot)com(dot)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.