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 16:49 -0400, Tom Lane wrote: >> 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? > The error has disappeared. Hmm, so something did happen to your index. > Now it can't write to the object. lo_open > seems to be successful, but lo_write is failing with: >> ERROR: invalid large-object descriptor: 0 You forgot to put the open-and-use-descriptor sequence inside a BEGIN block. regards, tom lane -- Sent via pgsql-interfaces mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-interfaces