Re: [GENERAL] Failing lo_import on RH 5.1 -- postgresql-6.3.2 (please help-I'm on my knees..)

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: jeroen(at)rulffh(dot)medfac(dot)leidenuniv(dot)nl
Cc: brook(at)trillium(dot)NMSU(dot)Edu, jeroen(at)rulffh(dot)medfac(dot)leidenuniv(dot)nl, pgsql-general(at)postgreSQL(dot)org
Subject: Re: [GENERAL] Failing lo_import on RH 5.1 -- postgresql-6.3.2 (please help-I'm on my knees..)
Date: 1998-11-13 11:27:37
Message-ID: 199811131127.GAA06624@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> Brook Milligan wrote:
> >
> > [jeroen(at)rulgfu sql]$ psql -f test.sql
> > insert into testfile values (lo_import('test.sql'));
> > ERROR: be_lo_import: can't open unix file"test.sql"
> >
> > Isn't the problem that the backend expects test.sql to be in the data
> > directories somewhere? Try a full path.
>
> Good guess. Nevertheless, didn't work.
>
> Jeroen
>
>

Try this patch.

---------------------------------------------------------------------------

Tatsuo Ishii
t-ishii(at)sra(dot)co(dot)jp
---------------------------------------------------------------------------
*** postgresql-v6.4/src/backend/storage/large_object/inv_api.c~ Thu Nov 5 17:48:26 1998
--- postgresql-v6.4/src/backend/storage/large_object/inv_api.c Thu Nov 12 15:52:59 1998
***************
*** 549,556 ****
tuplen = inv_wrnew(obj_desc, buf, nbytes - nwritten);
else
tuplen = inv_wrold(obj_desc, buf, nbytes - nwritten, tuple, buffer);
}
! ReleaseBuffer(buffer);

/* move pointers past the amount we just wrote */
buf += tuplen;
--- 549,557 ----
tuplen = inv_wrnew(obj_desc, buf, nbytes - nwritten);
else
tuplen = inv_wrold(obj_desc, buf, nbytes - nwritten, tuple, buffer);
+ ReleaseBuffer(buffer);
}
!

/* move pointers past the amount we just wrote */
buf += tuplen;

--
Bruce Momjian | http://www.op.net/~candle
maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sergei Chernev 1998-11-13 11:36:07 RE: [GENERAL] PL/pgSQL
Previous Message Bruce Momjian 1998-11-13 11:13:19 Re: [GENERAL] Failing lo_import on RH 5.1 -- postgresql-6.3.2 (please help-I'm on my knees..)