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
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..) |