From sandhyar@amiindia.co.in Thu Dec 1 10:30:26 2005 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 0A9269DD614 for ; Thu, 1 Dec 2005 06:30:26 -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 40789-04 for ; Thu, 1 Dec 2005 06:30:20 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mars.amiindia.co.in (unknown [203.199.198.229]) by postgresql.org (Postfix) with ESMTP id 42A659DD5E4 for ; Thu, 1 Dec 2005 06:30:20 -0400 (AST) Received: from amiindiahjwbgh ([10.0.0.205]) (authenticated bits=0) by mars.amiindia.co.in (8.12.11/8.12.11) with ESMTP id jB1AbKfV016152; Thu, 1 Dec 2005 16:07:22 +0530 Message-ID: <04c601c5f663$238ff7c0$cd00000a@amiindiahjwbgh> From: "sandhya" To: "postgre" Cc: "sandhya" Subject: Reg: File import&export problem Date: Thu, 1 Dec 2005 16:06:50 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_04C3_01C5F691.3D21E710" 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-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.001 required=5 tests=[HTML_MESSAGE=0.001] X-Spam-Score: 0.001 X-Spam-Level: X-Archive-Number: 200512/4 X-Sequence-Number: 19724 This is a multi-part message in MIME format. ------=_NextPart_000_04C3_01C5F691.3D21E710 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi... Please help me in sorting out the below problem. While doing importing and expoting files(This is first time i am using = this concept)..i got the following error message. Anything i have to include? How to rectify it? pls tell me to proceed further....... : undefined reference to `lo_creat' /tmp/ccYefhjF.o(.text+0x87): In function `importFile': : undefined reference to `lo_open' /tmp/ccYefhjF.o(.text+0xd3): In function `importFile': : undefined reference to `lo_write' /tmp/ccYefhjF.o(.text+0x121): In function `importFile': : undefined reference to `lo_close' /tmp/ccYefhjF.o(.text+0x145): In function `exportFile': : undefined reference to `lo_open' /tmp/ccYefhjF.o(.text+0x1bf): In function `exportFile': : undefined reference to `lo_read' /tmp/ccYefhjF.o(.text+0x22e): In function `exportFile': : undefined reference to `lo_close' /tmp/ccYefhjF.o(.text+0x255): In function `exit_nicely': : undefined reference to `PQfinish' /tmp/ccYefhjF.o(.text+0x2d5): In function `main': : undefined reference to `PQsetdbLogin' /tmp/ccYefhjF.o(.text+0x2e6): In function `main': : undefined reference to `PQstatus' /tmp/ccYefhjF.o(.text+0x315): In function `main': : undefined reference to `PQerrorMessage' /tmp/ccYefhjF.o(.text+0x34a): In function `main': : undefined reference to `PQexec' /tmp/ccYefhjF.o(.text+0x35b): In function `main': : undefined reference to `PQclear' /tmp/ccYefhjF.o(.text+0x37f): In function `main': : undefined reference to `lo_import' /tmp/ccYefhjF.o(.text+0x3a9): In function `main': : undefined reference to `lo_export' /tmp/ccYefhjF.o(.text+0x3bc): In function `main': : undefined reference to `PQexec' thanks, Sandhya ------=_NextPart_000_04C3_01C5F691.3D21E710 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi...
  Please help me in sorting out = the below=20 problem.
While doing importing and expoting = files(This is=20 first time i am using this concept)..i got the following error=20 message.
Anything i have to = include?
How to rectify it?
pls tell me to proceed = further.......
 
 
: undefined reference to=20 `lo_creat'
/tmp/ccYefhjF.o(.text+0x87): In function = `importFile':
:=20 undefined reference to `lo_open'
/tmp/ccYefhjF.o(.text+0xd3): In = function=20 `importFile':
: undefined reference to=20 `lo_write'
/tmp/ccYefhjF.o(.text+0x121): In function = `importFile':
:=20 undefined reference to `lo_close'
/tmp/ccYefhjF.o(.text+0x145): In = function=20 `exportFile':
: undefined reference to=20 `lo_open'
/tmp/ccYefhjF.o(.text+0x1bf): In function = `exportFile':
:=20 undefined reference to `lo_read'
/tmp/ccYefhjF.o(.text+0x22e): In = function=20 `exportFile':
: undefined reference to=20 `lo_close'
/tmp/ccYefhjF.o(.text+0x255): In function = `exit_nicely':
:=20 undefined reference to `PQfinish'
/tmp/ccYefhjF.o(.text+0x2d5): In = function=20 `main':
: undefined reference to=20 `PQsetdbLogin'
/tmp/ccYefhjF.o(.text+0x2e6): In function `main':
: = undefined reference to `PQstatus'
/tmp/ccYefhjF.o(.text+0x315): In = function=20 `main':
: undefined reference to=20 `PQerrorMessage'
/tmp/ccYefhjF.o(.text+0x34a): In function = `main':
:=20 undefined reference to `PQexec'
/tmp/ccYefhjF.o(.text+0x35b): In = function=20 `main':
: undefined reference to = `PQclear'
/tmp/ccYefhjF.o(.text+0x37f):=20 In function `main':
: undefined reference to=20 `lo_import'
/tmp/ccYefhjF.o(.text+0x3a9): In function `main':
: = undefined=20 reference to `lo_export'
/tmp/ccYefhjF.o(.text+0x3bc): In function=20 `main':
: undefined reference to `PQexec'
thanks,
Sandhya
------=_NextPart_000_04C3_01C5F691.3D21E710-- From gbarosio@gmail.com Thu Dec 1 22:44:58 2005 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 329BB9DD6D6 for ; Thu, 1 Dec 2005 18:44:58 -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 29774-06 for ; Thu, 1 Dec 2005 18:44:53 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nproxy.gmail.com (nproxy.gmail.com [64.233.182.200]) by postgresql.org (Postfix) with ESMTP id 89F259DD6DB for ; Thu, 1 Dec 2005 18:44:54 -0400 (AST) Received: by nproxy.gmail.com with SMTP id k26so134145nfc for ; Thu, 01 Dec 2005 14:44:56 -0800 (PST) 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:references; b=WpyVvzkVGuWIQQOlpbwS+jgH+7pF1VSSvjQ9a+SDGWxvCYu32H2eOv478+/CdutLZkbBwHVGYYZ2SMNfWrq+CO1yXT9zsdMle9Kq1Ie/HTeOJIk0qwJTpZ+RXfxjWBisCUiWl/V0Tcr3aSlvWEKlP2fJK4dnln7eB/mEkl3D70w= Received: by 10.48.222.5 with SMTP id u5mr428205nfg; Thu, 01 Dec 2005 14:44:56 -0800 (PST) Received: by 10.48.108.10 with HTTP; Thu, 1 Dec 2005 14:44:55 -0800 (PST) Message-ID: Date: Thu, 1 Dec 2005 22:44:55 +0000 From: Guido Barosio To: sandhya Subject: Re: Reg: File import&export problem Cc: postgre In-Reply-To: <04c601c5f663$238ff7c0$cd00000a@amiindiahjwbgh> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_62384_17674745.1133477095808" References: <04c601c5f663$238ff7c0$cd00000a@amiindiahjwbgh> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.001 required=5 tests=[HTML_MESSAGE=0.001] X-Spam-Score: 0.001 X-Spam-Level: X-Archive-Number: 200512/11 X-Sequence-Number: 19731 ------=_Part_62384_17674745.1133477095808 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Hi Sandhya Your request, again, seems to be poor in terms of information to the mailin= g list. I would sugest you to write this mail again, including the command's being run, and describing the idea behind them. That would be a good start :) Best wishes, Guido On 12/1/05, sandhya wrote: > > Hi... > Please help me in sorting out the below problem. > While doing importing and expoting files(This is first time i am using > this concept)..i got the following error message. > Anything i have to include? > How to rectify it? > pls tell me to proceed further....... > > > : undefined reference to `lo_creat' > /tmp/ccYefhjF.o(.text+0x87): In function `importFile': > : undefined reference to `lo_open' > /tmp/ccYefhjF.o(.text+0xd3): In function `importFile': > : undefined reference to `lo_write' > /tmp/ccYefhjF.o(.text+0x121): In function `importFile': > : undefined reference to `lo_close' > /tmp/ccYefhjF.o(.text+0x145): In function `exportFile': > : undefined reference to `lo_open' > /tmp/ccYefhjF.o(.text+0x1bf): In function `exportFile': > : undefined reference to `lo_read' > /tmp/ccYefhjF.o(.text+0x22e): In function `exportFile': > : undefined reference to `lo_close' > /tmp/ccYefhjF.o(.text+0x255): In function `exit_nicely': > : undefined reference to `PQfinish' > /tmp/ccYefhjF.o(.text+0x2d5): In function `main': > : undefined reference to `PQsetdbLogin' > /tmp/ccYefhjF.o(.text+0x2e6): In function `main': > : undefined reference to `PQstatus' > /tmp/ccYefhjF.o(.text+0x315): In function `main': > : undefined reference to `PQerrorMessage' > /tmp/ccYefhjF.o(.text+0x34a): In function `main': > : undefined reference to `PQexec' > /tmp/ccYefhjF.o(.text+0x35b): In function `main': > : undefined reference to `PQclear' > /tmp/ccYefhjF.o(.text+0x37f): In function `main': > : undefined reference to `lo_import' > /tmp/ccYefhjF.o(.text+0x3a9): In function `main': > : undefined reference to `lo_export' > /tmp/ccYefhjF.o(.text+0x3bc): In function `main': > : undefined reference to `PQexec' > thanks, > Sandhya > -- "Adopting the position that you are smarter than an automatic optimization algorithm is generally a good way to achieve less performance, not more" - Tom Lane. ------=_Part_62384_17674745.1133477095808 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Hi Sandhya

Your request, again, seems to be poor in terms of informa= tion to the mailing list.

I would sugest you to write this mail agai= n, including the command's being run, and describing the idea behind them. = That would be a good start :)

Best wishes,
Guido

On 12= /1/05, sandhya <sandhyar@amiindia.co.in> wrote:
Hi...
  Please help me in sorting out t= he below=20 problem.
While doing importing and expoting fil= es(This is=20 first time i am using this concept)..i got the following error=20 message.
Anything i have to include?
How to rectify it?
pls tell me to proceed further.......<= /font>
 
 
: undefined reference to=20 `lo_creat'
/tmp/ccYefhjF.o(.text+0x87): In function `importFile':
:= =20 undefined reference to `lo_open'
/tmp/ccYefhjF.o(.text+0xd3): In functio= n=20 `importFile':
: undefined reference to=20 `lo_write'
/tmp/ccYefhjF.o(.text+0x121): In function `importFile':
:= =20 undefined reference to `lo_close'
/tmp/ccYefhjF.o(.text+0x145): In funct= ion=20 `exportFile':
: undefined reference to=20 `lo_open'
/tmp/ccYefhjF.o(.text+0x1bf): In function `exportFile':
:= =20 undefined reference to `lo_read'
/tmp/ccYefhjF.o(.text+0x22e): In functi= on=20 `exportFile':
: undefined reference to=20 `lo_close'
/tmp/ccYefhjF.o(.text+0x255): In function `exit_nicely':
:= =20 undefined reference to `PQfinish'
/tmp/ccYefhjF.o(.text+0x2d5): In funct= ion=20 `main':
: undefined reference to=20 `PQsetdbLogin'
/tmp/ccYefhjF.o(.text+0x2e6): In function `main':
:=20 undefined reference to `PQstatus'
/tmp/ccYefhjF.o(.text+0x315): In funct= ion=20 `main':
: undefined reference to=20 `PQerrorMessage'
/tmp/ccYefhjF.o(.text+0x34a): In function `main':
:= =20 undefined reference to `PQexec'
/tmp/ccYefhjF.o(.text+0x35b): In functio= n=20 `main':
: undefined reference to `PQclear'
/tmp/ccYefhjF.o(.text+0x37= f):=20 In function `main':
: undefined reference to=20 `lo_import'
/tmp/ccYefhjF.o(.text+0x3a9): In function `main':
: undef= ined=20 reference to `lo_export'
/tmp/ccYefhjF.o(.text+0x3bc): In function=20 `main':
: undefined reference to `PQexec'
thanks,
Sandhya



--
"Adopting t= he position that you are smarter than an automatic
optimization algorith= m is generally a good way to achieve less
performance, not more" - = Tom Lane. ------=_Part_62384_17674745.1133477095808-- From sandhyar@amiindia.co.in Fri Dec 2 04:46:00 2005 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 A3C749DD702 for ; Fri, 2 Dec 2005 00:46:00 -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 87127-04-3 for ; Fri, 2 Dec 2005 00:45:53 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mars.amiindia.co.in (unknown [203.199.198.229]) by postgresql.org (Postfix) with ESMTP id 79D7F9DD6B6 for ; Fri, 2 Dec 2005 00:45:48 -0400 (AST) Received: from amiindiahjwbgh ([10.0.0.205]) (authenticated bits=0) by mars.amiindia.co.in (8.12.11/8.12.11) with ESMTP id jB24qniL010692; Fri, 2 Dec 2005 10:22:51 +0530 Message-ID: <05e401c5f6fc$2bda85a0$cd00000a@amiindiahjwbgh> From: "sandhya" To: "Guido Barosio" Cc: "postgre" , "sandhya" Subject: reg:File import&export problem Date: Fri, 2 Dec 2005 10:22:17 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_05E1_01C5F72A.455EE060" 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-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.001 required=5 tests=[HTML_MESSAGE=0.001] X-Spam-Score: 0.001 X-Spam-Level: X-Archive-Number: 200512/13 X-Sequence-Number: 19733 This is a multi-part message in MIME format. ------=_NextPart_000_05E1_01C5F72A.455EE060 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi ....... Pls tell me...how to do this? I have to import and export files from/to a database. Say i have a file named "sample" (assume some path) and i want to store = it in to a database. I did this through lo_import function and i got the object id when i = have used.....the following option. \lo_list ********* QUERY ********** SELECT loid as "ID", pg_catalog.obj_description(loid, 'pg_largeobject') = as "Description" FROM (SELECT DISTINCT loid FROM pg_catalog.pg_largeobject) x ORDER BY "ID" Large objects ID | Description -------+------------- 58782 | 58783 | 58784 | But i want to know whether i can see the contents using this id on the = database side.How can i view this? How to store this(object id) if i want to refer using file name(which we = exported to db) Where can i see the file name in DB?Is there any possible way to store = the names of the file in a database? What i thought is: While importing if there is possibility of storing the file name and = Objid in to a table..and whenever if the user wants to export it from = the db..by giving filename..we need to refer to that table and send the = corresponding OBJID?Am i right Pls tell me how to do this? I need this as early as possible.Help me out in doing this.... Thank you, Sandhya ------=_NextPart_000_05E1_01C5F72A.455EE060 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
 
Hi = .......
 
Pls tell me...how to do = this?
I have to import and export files = from/to a=20 database.
Say i have a file named "sample" = (assume some path)=20 and i want to store it in to a database.
I did this through lo_import=20 function and i got the object id  when i have used.....the = following option.
 
 \lo_list
********* QUERY=20 **********
SELECT loid as "ID", pg_catalog.obj_description(loid,=20 'pg_largeobject') as "Description"
FROM (SELECT DISTINCT loid FROM=20 pg_catalog.pg_largeobject) x
ORDER BY "ID"   Large=20 objects
  ID   |=20 Description
-------+-------------
 58782 |
 58783=20 |
 58784 |
But i want to know whether i can see = the contents=20 using this id on the database side.How can i view this?
How to store this(object id) if i = want to=20 refer using file name(which we exported to db)
Where can i see the file name in DB?Is = there any=20 possible way to store the names of the file in a database?
 
What i thought is:
While importing if  there is = possibility of=20 storing the file name and Objid in to a table..and whenever if the user = wants to=20 export it from the db..by giving filename..we need to refer to that = table and=20 send the corresponding OBJID?Am i right
 
Pls tell me how to do = this?
I need this as early as possible.Help = me out in=20 doing this....
 
Thank you,
Sandhya
------=_NextPart_000_05E1_01C5F72A.455EE060--