Home > mailing lists

Fw: pls help me - Mailing list pgsql-admin

From	sandhya
Subject	Fw: pls help me
Date	March 1, 2006 10:51:25
Msg-id	018201c63d27$34f26ec0$cd00000a@sandhyar Whole thread Raw
List	pgsql-admin

Hi,

In my application i need to create a file dynamically and load it into DB.

So.....I have created one object at run time .....and trying to open it inorder to write the content into it.....

But lo_open is returning -1(-ve value).

where i am doing mistake pls tell me.

lobjId = lo_creat(conn, INV_READ | INV_WRITE);

if (lobjId == 0)

fprintf(stderr, "can't create large object\n");

lobj_fd = lo_open(conn, lobjId, INV_WRITE);

//My application failed at this point..what i am missing here ?

if (lobj_fd < 0)

{

fprintf(stderr, "can't open large object %d\n",lobjId);

}

lo_lseek(conn, lobj_fd, 0, SEEK_SET);

nwritten = 0;

len = strlen(szContent);

while (len - nwritten > 0)

{

nbytes = lo_write(conn, lobj_fd, szContent, len - nwritten);

nwritten += nbytes;

}

From: "sandhya"
Date: 01 March 2006, 09:20:52
Subject: pls help me

From: "sandhya"
Date: 01 March 2006, 11:13:12
Subject: Reg:lo_open error..pls help me