From: | Denis Perchine <dyp(at)perchine(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: problem with fe/be protocol and large objects |
Date: | 2001-03-13 15:15:17 |
Message-ID: | 01031321151700.00608@dyp.perchine.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Monday 12 March 2001 03:24, Eric Marsden wrote:
> I am trying to debug my socket-level interface to the backend, which
> implements the 6.4 protocol. It works for general queries, but I have
> a problem with large objects.
>
> lo_create and lo_unlink seem to work OK; I get an oid which looks ok
> and there is a corresponding xinv??? file in the base/ directory.
> lo_open returns 0 as a file descriptor. However, following up with one
> of the other lo functions which take descriptor arguments (such as
> lo_write or lo_tell) fails with
>
> ERROR: lo_tell: invalid large object descriptor (0)
You should do ANY operations with LOs in transaction.
> Looking at be-fsstubs.c it seems that this arises when cookies[fd] is
> NULL. I don't know what this might come from: the lo_tell is sent
> right after the lo_open, on the same connection.
>
> Running the sample lo program in C works, so I suppose the problem
> must come from the bytes I'm sending. Any ideas what could cause this?
>
>
> PostgreSQL 7.0.3 on sparc-sun-solaris2.5.1, compiled by gcc 2.95.2
--
Sincerely Yours,
Denis Perchine
----------------------------------
E-Mail: dyp(at)perchine(dot)com
HomePage: http://www.perchine.com/dyp/
FidoNet: 2:5000/120.5
----------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-03-13 15:19:20 | Re: Performance monitor |
Previous Message | Bruce Momjian | 2001-03-13 15:05:47 | Re: SIGTERM/FATAL error |