Re: pqlib large object error
Tom Lane <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.interfaces |
|---|---|
| Message-ID | <[email protected]> |
Edward Amsden <[email protected]> writes: > On Tue, 2008-06-10 at 14:29 -0400, Tom Lane wrote: >> Edward Amsden <[email protected]> writes: >>> I cannot seem to figure this error message out: >>> >>> ERROR: duplicate key value violates unique constraint "pg_largeobject_loid_pn_index" >> >> Huh, that shouldn't happen. Is it repeatable? > Yes. It happens every time the program runs, no matter what db or user, > tried unix socket and tcp connect >> What PG version >> is your server? > 8.3.1, running on Ubuntu Linux Hmph. The only thing I can think of is that that index is corrupt, but it seems unlikely that it would be so in all databases. What happens if you REINDEX pg_largeobject? regards, tom lane -- Sent via pgsql-interfaces mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-interfaces