From: Tom Lane <tgl@sss.pgh.pa.us>
To: peter.garner@toward.com
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] large object error
Date: Mon, 26 Oct 1998 11:16:11 -0500
Message-ID: <3790.909418571@sss.pgh.pa.us> (raw)
In-Reply-To: <199810260100.AA107415366@piglet.toward.com>
"Peter Garner" <peter.garner@toward.com> writes:
> 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
This is a bug in libpq 6.3.2 (and probably all prior releases).
It doesn't cope with "NOTICE" messages issued by the backend during
a fast-path function call, which is what all the lo_XXX routines are.
It's impossible to guess from this much info what the NOTICE is and
whether it's anything significant; very possibly it's ignorable.
The backend is willing to proceed with the transaction, anyway.
This bug is fixed in the current sources. Although 6.4 is officially
still beta, I'd really suggest using a current snapshot in place of
6.3.2 --- I believe the current sources are more stable than 6.3.2.
(My company is currently running production apps on a server built
from a late-September snapshot, and it's given us no trouble ...
whereas 6.3.2 had some nasty bugs that got tickled by our apps.)
Alternatively, I think that a small patch to the 6.3.2 sources to handle
NOTICE messages during PQfn() was posted to one or another of the pgsql
mailing lists sometime this summer (not by me). Check the archives.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: tgl@sss.pgh.pa.us, peter.garner@toward.com
Subject: Re: [INTERFACES] large object error
In-Reply-To: <3790.909418571@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox