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 46B6E9DC820 for ; Thu, 19 Jan 2006 03:07:16 -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 51965-01 for ; Thu, 19 Jan 2006 03:07:15 -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 0AAD89DC80D for ; Thu, 19 Jan 2006 03:07:12 -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 k0J72Ijc020327 for ; Thu, 19 Jan 2006 12:32:18 +0530 Received: from sandhyar (unknown [10.0.0.205])by venus.amiindia.co.in (Postfix) with ESMTP id 82995332669for ; Thu, 19 Jan 2006 12:32:18 +0530 (IST) Message-ID: <00e101c61cc7$7ea2dcb0$cd00000a@sandhyar> From: "sandhya" To: "Postgres" Subject: Fw: lo_import problem Date: Thu, 19 Jan 2006 12:40:57 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00DE_01C61CF5.983E68F0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-imss-version: 2.5 X-imss-result: Passed X-imss-scores: Clean:62.34707 C:21 M:1 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.073 required=5 tests=[AWL=0.071, HTML_MESSAGE=0.001, UNPARSEABLE_RELAY=0.001] X-Spam-Score: 0.073 X-Spam-Level: X-Archive-Number: 200601/210 X-Sequence-Number: 20298 This is a multi-part message in MIME format. ------=_NextPart_000_00DE_01C61CF5.983E68F0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable When i am using lo_import to load files into the database i am getting = the following error..... Please help me what i need to do Insert into sampletbl values(lo_import('c:\\sample.txt'),'sample.txt'); ERROR: function lo_import ("unknown") does not exist HINT: No function matches the given name and argument types. You may = need to ad d explicit type casts. ------=_NextPart_000_00DE_01C61CF5.983E68F0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
 

When i am using lo_import to load files into the = database i am=20 getting the following error.....
Please help me what i need to do
 
Insert into sampletbl=20 values(lo_import('c:\\sample.txt'),'sample.txt');
 
ERROR:  function lo_import ("unknown") = does not=20 exist
HINT:  No function matches the given name and argument = types. You=20 may need to ad
d explicit type casts.
------=_NextPart_000_00DE_01C61CF5.983E68F0--