X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 6A38E9FA430 for ; Thu, 22 Jun 2006 05:13:52 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 36528-09 for ; Thu, 22 Jun 2006 05:13:47 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wr-out-0506.google.com (wr-out-0506.google.com [64.233.184.238]) by postgresql.org (Postfix) with ESMTP id E05E89F9ED6 for ; Thu, 22 Jun 2006 05:13:47 -0300 (ADT) Received: by wr-out-0506.google.com with SMTP id i7so367030wra for ; Thu, 22 Jun 2006 01:13:46 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=IuOb5K3GZOURdSlAuMKu6htrSxAH8ITX3WQ/behx1DvGXgxFpqqEOfQa7k4836a+z675wIn1L4ONORjt63ZEQ8ehwOqtLT23LqoiaGB/X0hAJKriweRc7cnfyfwIeNb0UVbMXwoMPeLnj4AZQXmJG+uVRSpVcUMaNabA3Cwpb4g= Received: by 10.54.65.9 with SMTP id n9mr3037415wra; Thu, 22 Jun 2006 01:13:46 -0700 (PDT) Received: by 10.54.135.18 with HTTP; Thu, 22 Jun 2006 01:13:46 -0700 (PDT) Message-ID: <3f0d61c40606220113i425bde7brd60ec33a87f592f9@mail.gmail.com> Date: Thu, 22 Jun 2006 10:13:46 +0200 From: "Marco Bizzarri" To: sandhya Subject: Re: reg:lo_write Cc: Postgres In-Reply-To: <00d601c695cf$d0edc490$cd00000a@sandhyar> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <00d601c695cf$d0edc490$cd00000a@sandhyar> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/187 X-Sequence-Number: 22149 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 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/