From sandhyar@amiindia.co.in Thu Jun 22 08:06:11 2006 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 003689FA60C for ; Thu, 22 Jun 2006 05:06:11 -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 35066-06 for ; Thu, 22 Jun 2006 05:06:00 -0300 (ADT) X-Greylist: delayed 00:29:27.672728 by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 9A9819FA65C for ; Thu, 22 Jun 2006 05:06:01 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from venus.amiindia.co.in (unknown [203.199.198.234]) by svr4.postgresql.org (Postfix) with ESMTP id 24D885AF03F for ; Thu, 22 Jun 2006 07:36:23 +0000 (GMT) Received: from localhost (localhost.localdomain [127.0.0.1]) by venus.amiindia.co.in (8.12.11/8.12.11) with SMTP id k5M7SX72013862 for ; Thu, 22 Jun 2006 12:58:33 +0530 Received: from sandhyar (unknown [10.0.0.205])by venus.amiindia.co.in (Postfix) with ESMTP id 63589332692; Thu, 22 Jun 2006 12:58:32 +0530 (IST) Message-ID: <00d601c695cf$d0edc490$cd00000a@sandhyar> From: "sandhya" To: "Postgres" Cc: "sandhya" Subject: reg:lo_write Date: Thu, 22 Jun 2006 13:15:20 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00D3_01C695FD.E9B9F2E0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1506 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506 X-imss-version: 2.040 X-imss-result: Passed X-imss-scanInfo: M:P L:E SM:0 X-imss-tmaseResult: TT:0 TS:0.0000 TC:00 TRN:0 TV:3.52.1006(14518.003) X-imss-scores: Clean:85.23028 C:2 M:4 S:5 R:5 X-imss-settings: Baseline:5 C:3 M:3 S:4 R:3 (0.2500 0.2500) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/186 X-Sequence-Number: 22148 This is a multi-part message in MIME format. ------=_NextPart_000_00D3_01C695FD.E9B9F2E0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, =20 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 ------=_NextPart_000_00D3_01C695FD.E9B9F2E0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi,
  
  If i use lo_write in different function to = write data=20 into an object,Will there be any problem?
like,
I open my object and add data into it and in = another=20 function if i again open the same object and add data....It will = append to=20 the previous content right!Am i wrong?
 
If i wants to append the content to the present = object is=20 there anything i need to do?
Please help me in doing =20 this................
I am unable to see the image which i am=20 exporting...
Thank you,
Sandhya
 
------=_NextPart_000_00D3_01C695FD.E9B9F2E0-- From marco.bizzarri@gmail.com Thu Jun 22 08:13:52 2006 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/ From sandhyar@amiindia.co.in Thu Jun 22 08:44:09 2006 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 6552A9FA430 for ; Thu, 22 Jun 2006 05:44:09 -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 42226-01 for ; Thu, 22 Jun 2006 05:43:59 -0300 (ADT) X-Greylist: delayed 01:07:38.921443 by SQLgrey- Received: from venus.amiindia.co.in (unknown [203.199.198.234]) by postgresql.org (Postfix) with ESMTP id 1B52C9F9ED6 for ; Thu, 22 Jun 2006 05:43:56 -0300 (ADT) Received: from venus.amiindia.co.in (localhost.localdomain [127.0.0.1]) by venus.amiindia.co.in (8.12.11/8.12.11) with ESMTP id k5M8V56t025486; Thu, 22 Jun 2006 14:01:06 +0530 Received: from sandhyar (unknown [10.0.0.205])by venus.amiindia.co.in (Postfix) with ESMTP id 89599332690; Thu, 22 Jun 2006 14:01:05 +0530 (IST) Message-ID: <011d01c695d8$93cba830$cd00000a@sandhyar> From: "sandhya" To: "VivekanandaSwamy R." , "Marco Bizzarri" , "Postgres" References: Subject: Re: reg:lo_write Date: Thu, 22 Jun 2006 14:17:59 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0118_01C69606.AA37ED80" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1506 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506 X-imss-version: 2.040 X-imss-result: Passed X-imss-scanInfo: M:P L:E SM:0 X-imss-tmaseResult: TT:0 TS:0.0000 TC:00 TRN:0 TV:3.52.1006(14518.003) X-imss-scores: Clean:99.90000 C:2 M:4 S:5 R:5 X-imss-settings: Baseline:5 C:3 M:3 S:4 R:3 (0.2500 0.2500) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/188 X-Sequence-Number: 22150 This is a multi-part message in MIME format. ------=_NextPart_000_0118_01C69606.AA37ED80 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Thank you all.... I have to just modify the already existing application for DB = support.So..where ever they are using write i should only use my = lo_write...No way to escape from it.....So trying to sort it out....I = will keep one file descriptor..and will check whether it is getting or = not..... Regards, Sandhya ----- Original Message -----=20 From: VivekanandaSwamy R.=20 To: sandhya=20 Sent: Thursday, June 22, 2006 1:56 PM Subject: RE: [ADMIN] reg:lo_write Dear sandhya, According to my knowledge....If u use LO_WRITE function to write data = into an object,it wil be problem with primary data.because the = descripter wil always take recent existing data.Expetially this wil come = under client-server arch. Why don't U use...lo_export and lo_import for = lorge objects? Thanks & Regards Vivekananda.R | Software Engineer =20 Infinite Computer Solutions | Exciting Times.Infinite Possibilities... = SEI-CMMI level 5 | ISO 9001:2000 Tel +91-80-5193-0000| Fax +91-80-51930009 | Cell No = +91-9986463365|www.infics.com =20 -------------------------------------------------------------------------= ----- From: pgsql-admin-owner@postgresql.org = [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of sandhya Sent: Thursday, June 22, 2006 1:15 PM To: Postgres Cc: sandhya Subject: [ADMIN] reg:lo_write Hi, =20 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 Information transmitted by this e-mail is proprietary to = Infinite Computer Solutions and / or its Customers and is intended for = use only by the individual or the entity to which it is addressed, and = may contain information that is privileged, confidential or exempt from = disclosure under applicable law. If you are not the intended recipient = or it appears that this mail has been forwarded to you without proper = authority, you are notified that any use or dissemination of this = information in any manner is strictly prohibited. In such cases, please = notify us immediately at info.in@infics.com and delete this email from = your records. =20 ------=_NextPart_000_0118_01C69606.AA37ED80 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Thank you all....
I have to just modify the already existing = application for DB=20 support.So..where ever they are using write i should only use my = lo_write...No=20 way to escape from it.....So trying to sort it out....I will keep one = file=20 descriptor..and will check whether it is getting or = not.....
 
Regards,
Sandhya
 
----- Original Message -----
From:=20 VivekanandaSwamy R. =
To: sandhya
Sent: Thursday, June 22, 2006 = 1:56=20 PM
Subject: RE: [ADMIN] = reg:lo_write

Dear sandhya,
According to my knowledge....If u use = LO_WRITE function=20 to write data into an object,it wil be problem with primary = data.because=20 the descripter wil always take recent existing data.Expetially this = wil come=20 under client-server arch.
 
          &nbs= p;         =20 Why don't U use...lo_export and lo_import for lorge=20 objects?
 
 

Thanks =20 &  Regards

Vivekananda.R |=20 Software Engineer=20 =           

Infinite=20 Computer Solutions |=20 Exciting Times=85Infinite Possibilities...

SEI-CMMI=20 level 5 |=20 ISO=20 9001:2000

 Tel=20 +91-80-5193-0000|=20 Fax  +91-80-51930009 |=20 Cell No  +91-9986463365|www.infics.com          

 


From: = pgsql-admin-owner@postgresql.org=20 [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of=20 sandhya
Sent: Thursday, June 22, 2006 1:15 = PM
To:=20 Postgres
Cc: sandhya
Subject: [ADMIN]=20 reg:lo_write

Hi,
  
  If i use lo_write in different function to = write data=20 into an object,Will there be any problem?
like,
I open my object and add data into it and in = another=20 function if i again open the same object and add data....It will = append=20 to the previous content right!Am i wrong?
 
If i wants to append the content to the present = object is=20 there anything i need to do?
Please help me in doing =20 this................
I am unable to see the image which i am=20 exporting...
Thank you,
Sandhya
 
Information = transmitted by this=20 e-mail is proprietary to Infinite Computer Solutions and / or = its=20 Customers and is intended for use only by the individual or the = entity=20 to which it is addressed, and may contain information that is=20 privileged, confidential or exempt from disclosure under = applicable law.=20 If you are not the intended recipient or it appears that this = mail has=20 been forwarded to you without proper authority, you are notified = that=20 any use or dissemination of this information in any manner is = strictly=20 prohibited. In such cases, please notify us immediately at=20 info.in@infics.com and delete this email from your=20 = records.
------=_NextPart_000_0118_01C69606.AA37ED80-- From sandhyar@amiindia.co.in Thu Jun 22 09:52:10 2006 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 228B79FA60C for ; Thu, 22 Jun 2006 06:52:10 -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 51125-01 for ; Thu, 22 Jun 2006 06:52:02 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from venus.amiindia.co.in (unknown [203.199.198.234]) by postgresql.org (Postfix) with ESMTP id C0E3B9F9ED6 for ; Thu, 22 Jun 2006 06:52:00 -0300 (ADT) Received: from venus.amiindia.co.in (localhost.localdomain [127.0.0.1]) by venus.amiindia.co.in (8.12.11/8.12.11) with ESMTP id k5M9fKTE006719; Thu, 22 Jun 2006 15:11:26 +0530 Received: from sandhyar (unknown [10.0.0.205])by venus.amiindia.co.in (Postfix) with ESMTP id D07F7332690; Thu, 22 Jun 2006 15:11:20 +0530 (IST) Message-ID: <014c01c695e2$62c0d530$cd00000a@sandhyar> From: "sandhya" To: "Marco Bizzarri" Cc: "Postgres" References: <00d601c695cf$d0edc490$cd00000a@sandhyar> <3f0d61c40606220113i425bde7brd60ec33a87f592f9@mail.gmail.com> Subject: Re: reg:lo_write Date: Thu, 22 Jun 2006 15:28:16 +0530 MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1506 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506 X-imss-version: 2.040 X-imss-result: Passed X-imss-scanInfo: M:P L:E SM:0 X-imss-tmaseResult: TT:0 TS:0.0000 TC:00 TRN:0 TV:3.52.1006(14518.003) X-imss-scores: Clean:68.31562 C:2 M:4 S:5 R:5 X-imss-settings: Baseline:5 C:3 M:3 S:4 R:3 (0.2500 0.2500) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/189 X-Sequence-Number: 22151 Hi Macro.. If i assign my lobj_fd(say LO file descriptor) to one Global int. But will my lo_write work if i pass that global int inplace of lobjfd.... One more thing...It should be in "begin" and "end" sessions right! How can i open a LO in many places and write the content into it.....Will it get appended to the previous content? You said two different file descriptors i will be having?How to overcome it?Any suggestion pls Anybody please give me suggestion how can i over come this problem?So that i can proceed further ----- Original Message ----- From: "Marco Bizzarri" To: "sandhya" Cc: "Postgres" Sent: Thursday, June 22, 2006 1:43 PM Subject: Re: [ADMIN] reg:lo_write > 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/ > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match > From marco.bizzarri@gmail.com Thu Jun 22 10:01:57 2006 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 1D3CC9F9FE3 for ; Thu, 22 Jun 2006 07:01:57 -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 43630-08 for ; Thu, 22 Jun 2006 07:01:46 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wr-out-0506.google.com (wr-out-0506.google.com [64.233.184.239]) by postgresql.org (Postfix) with ESMTP id DF0C79FA606 for ; Thu, 22 Jun 2006 07:01:46 -0300 (ADT) Received: by wr-out-0506.google.com with SMTP id i7so383395wra for ; Thu, 22 Jun 2006 03:01:45 -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=HfkzyRBhdNVxsVoVgyKze5q38YDqyLC+mrp/dDPHAQps6JY5XW6Mk502w0Xpg5T75vKcsuFd/sv01WRF858/xUvCr36dmVKWMAu6bmr6wpEslNkMn+t+gg5shVq3iOYihfFVczjd2H2ecE8f4WhlSGfm64rZTL+PUZkGRh8yBHE= Received: by 10.54.126.2 with SMTP id y2mr1948018wrc; Thu, 22 Jun 2006 03:01:45 -0700 (PDT) Received: by 10.54.135.18 with HTTP; Thu, 22 Jun 2006 03:01:44 -0700 (PDT) Message-ID: <3f0d61c40606220301m27da36cfvacaeff9e272f2fad@mail.gmail.com> Date: Thu, 22 Jun 2006 12:01:44 +0200 From: "Marco Bizzarri" To: sandhya Subject: Re: reg:lo_write Cc: Postgres In-Reply-To: <014c01c695e2$62c0d530$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> <3f0d61c40606220113i425bde7brd60ec33a87f592f9@mail.gmail.com> <014c01c695e2$62c0d530$cd00000a@sandhyar> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/190 X-Sequence-Number: 22152 Hi Sandhya. On 6/22/06, sandhya wrote: > Hi Macro.. > If i assign my lobj_fd(say LO file descriptor) to one Global int. > But will my lo_write work if i pass that global int inplace of lobjfd.... Yes, I think so. > One more thing...It should be in "begin" and "end" sessions right! If you mean inside a single transaction, yes, the lobj_fd is sensible within one transaction. > How can i open a LO in many places and write the content into it.....Will it > get appended to the previous content? If you have to open and append to the previous content, you could use other lo_lseek, and pass it SEEK_END, so that you will position to the end of the LO. At that point, you could "append" to the end of the LO. > You said two different file descriptors i will be having?How to overcome > it?Any suggestion pls > > Anybody please give me suggestion how can i over come this problem?So that i > can proceed further > > > > > ----- Original Message ----- > From: "Marco Bizzarri" > To: "sandhya" > Cc: "Postgres" > Sent: Thursday, June 22, 2006 1:43 PM > Subject: Re: [ADMIN] reg:lo_write > > > > 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/ > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 9: In versions below 8.0, the planner will ignore your desire to > > choose an index scan if your joining column's datatypes do not > > match > > > > > Regards Marco -- Marco Bizzarri http://notenotturne.blogspot.com/ From marco.bizzarri@gmail.com Thu Jun 22 10:03:30 2006 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 7B9CC9FA606 for ; Thu, 22 Jun 2006 07:03:30 -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 49554-07 for ; Thu, 22 Jun 2006 07:03:24 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wr-out-0506.google.com (wr-out-0506.google.com [64.233.184.227]) by postgresql.org (Postfix) with ESMTP id 1AFF49F9ED6 for ; Thu, 22 Jun 2006 07:03:24 -0300 (ADT) Received: by wr-out-0506.google.com with SMTP id i3so359359wra for ; Thu, 22 Jun 2006 03:03:23 -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=CTpgKzprjKwnBCfMomDvBccUGYC04B2v9XeOzmOS+5MErxuVvOw+iC7xXLy5mj59AuPemx5D+iuqyDLKgVZjW+i5hBuBxXDPIY/QHiJz+N1sR2MuDYs7vT5WGyKXKzQJlNvZuvqwO9X0YF68Qus8V8RWa0fgPlOM7qG8V3HCTkM= Received: by 10.54.125.11 with SMTP id x11mr3098747wrc; Thu, 22 Jun 2006 03:03:23 -0700 (PDT) Received: by 10.54.135.18 with HTTP; Thu, 22 Jun 2006 03:03:23 -0700 (PDT) Message-ID: <3f0d61c40606220303k5df56eb7pae4bfa69b4ef72be@mail.gmail.com> Date: Thu, 22 Jun 2006 12:03:23 +0200 From: "Marco Bizzarri" To: sandhya Subject: Re: reg:lo_write Cc: Postgres In-Reply-To: <3f0d61c40606220301m27da36cfvacaeff9e272f2fad@mail.gmail.com> 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> <3f0d61c40606220113i425bde7brd60ec33a87f592f9@mail.gmail.com> <014c01c695e2$62c0d530$cd00000a@sandhyar> <3f0d61c40606220301m27da36cfvacaeff9e272f2fad@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/191 X-Sequence-Number: 22153 Did you look at this example? http://www.redhat.com/docs/manuals/database/RHDB-7.1.3-Manual/prog/largeobjects.html (I think you can find better example in the postgresql documentation, this was the first one I found) On 6/22/06, Marco Bizzarri wrote: > Hi Sandhya. > > On 6/22/06, sandhya wrote: > > Hi Macro.. > > If i assign my lobj_fd(say LO file descriptor) to one Global int. > > But will my lo_write work if i pass that global int inplace of lobjfd.... > > Yes, I think so. > > > One more thing...It should be in "begin" and "end" sessions right! > > If you mean inside a single transaction, yes, the lobj_fd is sensible > within one transaction. > > > How can i open a LO in many places and write the content into it.....Will it > > get appended to the previous content? > > If you have to open and append to the previous content, you could use > other lo_lseek, and pass it SEEK_END, so that you will position to the > end of the LO. At that point, you could "append" to the end of the LO. > > > You said two different file descriptors i will be having?How to overcome > > it?Any suggestion pls > > > > Anybody please give me suggestion how can i over come this problem?So that i > > can proceed further > > > > > > > > > > ----- Original Message ----- > > From: "Marco Bizzarri" > > To: "sandhya" > > Cc: "Postgres" > > Sent: Thursday, June 22, 2006 1:43 PM > > Subject: Re: [ADMIN] reg:lo_write > > > > > > > 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/ > > > > > > ---------------------------(end of broadcast)--------------------------- > > > TIP 9: In versions below 8.0, the planner will ignore your desire to > > > choose an index scan if your joining column's datatypes do not > > > match > > > > > > > > > > > Regards > Marco > > -- > Marco Bizzarri > http://notenotturne.blogspot.com/ > -- Marco Bizzarri http://notenotturne.blogspot.com/ From sandhyar@amiindia.co.in Thu Jun 22 12:57:22 2006 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 AFF6E9F9FE3 for ; Thu, 22 Jun 2006 09:57:22 -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 69389-10 for ; Thu, 22 Jun 2006 09:57:08 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from venus.amiindia.co.in (unknown [203.199.198.234]) by postgresql.org (Postfix) with ESMTP id ACC8C9F9ED6 for ; Thu, 22 Jun 2006 09:57:00 -0300 (ADT) Received: from venus.amiindia.co.in (localhost.localdomain [127.0.0.1]) by venus.amiindia.co.in (8.12.11/8.12.11) with ESMTP id k5MCnGFg010630; Thu, 22 Jun 2006 18:19:17 +0530 Received: from sandhyar (unknown [10.0.0.205])by venus.amiindia.co.in (Postfix) with ESMTP id 69198332688; Thu, 22 Jun 2006 18:19:16 +0530 (IST) Message-ID: <01d101c695fc$9fb64e60$cd00000a@sandhyar> From: "sandhya" To: "Marco Bizzarri" Cc: "Postgres" References: <00d601c695cf$d0edc490$cd00000a@sandhyar> <3f0d61c40606220113i425bde7brd60ec33a87f592f9@mail.gmail.com> <014c01c695e2$62c0d530$cd00000a@sandhyar> <3f0d61c40606220301m27da36cfvacaeff9e272f2fad@mail.gmail.com> <3f0d61c40606220303k5df56eb7pae4bfa69b4ef72be@mail.gmail.com> Subject: Re: reg:lo_write Date: Thu, 22 Jun 2006 18:36:05 +0530 MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1506 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506 X-imss-version: 2.040 X-imss-result: Passed X-imss-scanInfo: M:P L:E SM:0 X-imss-tmaseResult: TT:0 TS:0.0000 TC:00 TRN:0 TV:3.52.1006(14522.003) X-imss-scores: Clean:83.40636 C:2 M:4 S:5 R:5 X-imss-settings: Baseline:5 C:3 M:3 S:4 R:3 (0.2500 0.2500) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/193 X-Sequence-Number: 22155 Hi, In the examples what ever they are doing is with in one session....But its not in my case. I have to open the LO in each and every function and have to write my data into it and close. I am trying to get the Length of it and setting the position to END....After first write when i check the length of it when it coems fro second write....the filedescriptor is showing zero again...Every time it is showing zero and only the last content is persisting....?How to come out from this problem? Even Global File descriptor too failed....to get this... No way can we open a LO and append the content to it....... please help me...anybody Thank you all, Regards Sandhya ----- Original Message ----- From: "Marco Bizzarri" To: "sandhya" Cc: "Postgres" Sent: Thursday, June 22, 2006 3:33 PM Subject: Re: [ADMIN] reg:lo_write > Did you look at this example? > > http://www.redhat.com/docs/manuals/database/RHDB-7.1.3-Manual/prog/largeobjects.html > > (I think you can find better example in the postgresql documentation, > this was the first one I found) > > On 6/22/06, Marco Bizzarri wrote: > > Hi Sandhya. > > > > On 6/22/06, sandhya wrote: > > > Hi Macro.. > > > If i assign my lobj_fd(say LO file descriptor) to one Global int. > > > But will my lo_write work if i pass that global int inplace of lobjfd.... > > > > Yes, I think so. > > > > > One more thing...It should be in "begin" and "end" sessions right! > > > > If you mean inside a single transaction, yes, the lobj_fd is sensible > > within one transaction. > > > > > How can i open a LO in many places and write the content into it.....Will it > > > get appended to the previous content? > > > > If you have to open and append to the previous content, you could use > > other lo_lseek, and pass it SEEK_END, so that you will position to the > > end of the LO. At that point, you could "append" to the end of the LO. > > > > > You said two different file descriptors i will be having?How to overcome > > > it?Any suggestion pls > > > > > > Anybody please give me suggestion how can i over come this problem?So that i > > > can proceed further > > > > > > > > > > > > > > > ----- Original Message ----- > > > From: "Marco Bizzarri" > > > To: "sandhya" > > > Cc: "Postgres" > > > Sent: Thursday, June 22, 2006 1:43 PM > > > Subject: Re: [ADMIN] reg:lo_write > > > > > > > > > > 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/ > > > > > > > > ---------------------------(end of broadcast)--------------------------- > > > > TIP 9: In versions below 8.0, the planner will ignore your desire to > > > > choose an index scan if your joining column's datatypes do not > > > > match > > > > > > > > > > > > > > > > > Regards > > Marco > > > > -- > > Marco Bizzarri > > http://notenotturne.blogspot.com/ > > > > > -- > Marco Bizzarri > http://notenotturne.blogspot.com/ >