Re: reg:lo_write - Mailing list pgsql-admin

From Marco Bizzarri
Subject Re: reg:lo_write
Date
Msg-id 3f0d61c40606220113i425bde7brd60ec33a87f592f9@mail.gmail.com
Whole thread Raw
In response to reg:lo_write  ("sandhya" <sandhyar@amiindia.co.in>)
List pgsql-admin
I'm not sure, but I think you will have problems. As far as I can
understand, largeobject semantics is similar to files. Therefore, you
open an existing LO, and you obtain a file descriptor, which will
point (I think) at the start of the LO. If you write something, the
file descriptor will be moved accordingly. If you open again (i.e. you
issue another lo_open), you will have another file descriptor for the
same LO, which will be at the start of the LO, and you will overwrite
your previous LO.

Please take care with these advices as I'm not a PostgreSQL expert,
just reporting some experience.

Regards
Marco

On 6/22/06, sandhya <sandhyar@amiindia.co.in> wrote:
>
>
> Hi,
>
>   If i use lo_write in different function to write data into an object,Will
> there be any problem?
> like,
> I open my object and add data into it and in another function if i again
> open the same object and add data....It will append to the previous content
> right!Am i wrong?
>
> If i wants to append the content to the present object is there anything i
> need to do?
> Please help me in doing  this................
> I am unable to see the image which i am exporting...
> Thank you,
> Sandhya
>


--
Marco Bizzarri
http://notenotturne.blogspot.com/

pgsql-admin by date:

Previous
From: "sandhya"
Date:
Subject: reg:lo_write
Next
From: "sandhya"
Date:
Subject: Re: reg:lo_write