Re: [INTERFACES] large object error

From: Peter T Mount <peter(at)retep(dot)org(dot)uk>
To: Peter Garner <peter(dot)garner(at)toward(dot)com>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: [INTERFACES] large object error
Date: 1998-10-26 06:54:23
Message-ID: Pine.LNX.3.96.981026065303.814N-100000@maidast.retep.org.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

On Mon, 26 Oct 1998, Peter Garner wrote:

> Hi All! :-)
>
> Thanks for your help! :-) I am attempting to write an app
> that uses large objects. It is an offline Usenet NNTP news
> reader that stores all of the message information in a
> postgres database. I am using the LOBS to hold the
> message body. Thus one of the tables is declared as
>
> create table Msg_Bodies
> (
> Msg_Id text not null ,
> Msg_Body OID not null ,
>
> primary key ( Msg_Id )
>
> ) ;
>
>
> I am getting a wierd error attempting to access the lobs.
> When I close the lob, I get the error
>
> PQfn: expected a 'V' from the backend. Got 'N' instead

What interface are you using?

When I was implementing large object for JDBC, I came across this. If
you're using libpq, I may know where the problem is.

>

--
Peter T Mount peter(at)retep(dot)org(dot)uk
Main Homepage: http://www.retep.org.uk
PostgreSQL JDBC Faq: http://www.retep.org.uk/postgres
Java PDF Generator: http://www.retep.org.uk/pdf

In response to

Browse pgsql-interfaces by date

  From Date Subject
Next Message Cary B. O'Brien 1998-10-26 12:41:12 Re: [INTERFACES] large object error
Previous Message Tom Lane 1998-10-26 01:22:09 Re: [INTERFACES] aborted transactions