pg_dump: dumpBlobs(): could not open large object: ERROR: large object 27729547 does not exist

Hi,

I have a Postgresql-7.4.19 database in SQL_ASCII Encoding format. There is
a table, besides other tables, in the database, that is used to store BLOBs
through a Web-based application. I normally take database backup using
pg_dump, as and when needed, and it has always worked fine. It was needed
as a special case to manually delete some of the records for BLOBs directly
from the back-end. I took backup of the database using pg_dump before
deleting the records. Then, I deleted the required records via psql prompt
from that table. Then, I tried another database backup using pg_dump, but
it gave error: "pg_dump: dumpBlobs(): could not open large object: ERROR:
large object 27729547 does not exist." I have been looking into PostgreSQL
forums for this issue, and it is suggested that 'pg_largeobject' table might
contain invalid references towards blobs, and REINDEX table pg_largeobject
should fix the issue. Is this the only possible solution in this case or
some other solution also exists? Also, when this REINDEX is done by
Postgres? Is it needed to be done manually or we can force it automatically
somehow? What are the chances of REINDEX operation goes wrong/bust?

Please suggest.

Kind Regards,

Manoj Agarwal