[GENERAL] vacuumlo fails pgsql ver 8.3

2012-02-05 Thread Pat Heuvel
. Can someone offer please offer some advice on how to resolve this? TIA. Pat Heuvel (in Australia)

Re: [GENERAL] vacuumlo fails pgsql ver 8.3

2012-02-06 Thread Pat Heuvel
On 6/02/2012 4:39 AM, Tom Lane wrote: Pat Heuvel writes: [ vacuumlo fails ] When I added the -v option, there were many "removing lo x" messages before the above messages appeared. I have previously tried to reindex pg_largeobject, but that process failed as well. You need

Re: [GENERAL] vacuumlo fails pgsql ver 8.3

2012-02-08 Thread Pat Heuvel
On 7/02/2012 3:48 AM, Tom Lane wrote: Pat Heuvel writes: On 6/02/2012 4:39 AM, Tom Lane wrote: What exactly happens when you try to reindex pg_largeobject? ERROR: could not create unique index "pg_largeobject_loid_pn_index" DETAIL: Table contains duplicated values. Could be wo