X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id AC0C39DC833 for ; Thu, 29 Dec 2005 01:07:36 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 27399-04 for ; Thu, 29 Dec 2005 01:07:35 -0400 (AST) 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 8A0C39DC83E for ; Thu, 29 Dec 2005 01:07:31 -0400 (AST) 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 jBT51Y2P010886 for ; Thu, 29 Dec 2005 10:32:55 +0530 Received: from amiindiahjwbgh (unknown [10.0.0.205])by venus.amiindia.co.in (Postfix) with ESMTP id AFE92332A99for ; Thu, 29 Dec 2005 10:32:14 +0530 (IST) Message-ID: <003e01c60c36$bb8e4bb0$cd00000a@amiindiahjwbgh> From: "sandhya" To: "postgre" Subject: Fw: reading reading files from the DB ...pls Date: Thu, 29 Dec 2005 10:44:23 +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.1437 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 X-imss-version: 2.5 X-imss-result: Passed X-imss-scores: Clean:99.90000 C:21 M:2 S:5 R:5 X-imss-settings: Baseline:5 C:3 M:3 S:4 R:3 (0.2500 0.7500) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.046 required=5 tests=[AWL=0.045, UNPARSEABLE_RELAY=0.001] X-Spam-Score: 0.046 X-Spam-Level: X-Archive-Number: 200512/355 X-Sequence-Number: 20075 > Hi..... > > I have exported few files into my DB server running on LINUX os. > I connected to it remotely from windows and through one sample application > like webserver i am trying to read the contents of it when ever there is a > request for the specified file.Using the below example code. > Is this correct?I am not finding that it is reading it from the database. > How can i make sure of this.I am unable to open the requested file from win > application through database. > please suggest me ......... > voi d GetFiles(PGconn *conn, unsigned int lobjId, int start) > { > > --------- > > ------------ > > int lobj_fd; > > lobj_fd = lo_open(conn, lobjId, INV_READ); > > if (lobj_fd < 0) > > { > > MessageBox(0,"error","Cannot Object Id ",MB_OK); > > } > > lo_lseek(conn, lobj_fd, start, SEEK_END); > > len = lo_tell(conn,lobj_fd); > > lo_lseek(conn, lobj_fd, start, SEEK_SET); > > buf =(char*) malloc(len + 1); > > nread = 0; > > while (len - nread > 0) > > { > > nbytes = lo_read(conn, lobj_fd, buf, len - nread); > > buf[nbytes] = ' '; > > nread += nbytes; > > } > > MessageBox(0,"Inside get","test",MB_OK); > > free(buf); > > lo_close(conn, lobj_fd); > > } > > > > Thank you..... > Sandhya > > > ----- Original Message ----- > > From: "Tom Lane" > > To: "sandhya" > > Cc: "postgre" > > Sent: Monday, December 26, 2005 9:08 PM > > Subject: Re: [ADMIN] reg:lseek&read ..pls > > > > > > > "sandhya" writes: > > > > But before that i need to know the size of the object from which i am > = > > > > trying to get the contents. > > > > How can i do this? > > > > > > Same way you'd do it for a Unix file: seek to the end, note the end > > > offset, seek back to the start and read. > > > > > > ... lo_open ... > > > lo_size = lo_lseek(conn, fd, 0, SEEK_END); // where's the end? > > > lo_lseek(conn, fd, 0, SEEK_SET); // go back to start > > > > > > regards, tom lane > > > > > > ---------------------------(end of broadcast)--------------------------- > > > TIP 2: Don't 'kill -9' the postmaster > > > > > > > > > > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 2: Don't 'kill -9' the postmaster > > > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend >