Re: vacuumlo fails pgsql ver 8.3

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.