From sandhyar@amiindia.co.in Thu Jan 19 07:07:16 2006 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-- From jeff@frostconsultingllc.com Thu Jan 19 07:30:48 2006 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 ED9439DCA13 for ; Thu, 19 Jan 2006 03:30:48 -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 55696-02 for ; Thu, 19 Jan 2006 03:30:48 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from smtp109.sbc.mail.mud.yahoo.com (smtp109.sbc.mail.mud.yahoo.com [68.142.198.208]) by postgresql.org (Postfix) with SMTP id DCF429DC99B for ; Thu, 19 Jan 2006 03:30:44 -0400 (AST) Received: (qmail 3447 invoked from network); 19 Jan 2006 07:30:45 -0000 Received: from unknown (HELO discord.dyndns.org) (jeffroe996@sbcglobal.net@69.226.242.241 with plain) by smtp109.sbc.mail.mud.yahoo.com with SMTP; 19 Jan 2006 07:30:44 -0000 Received: from localhost (localhost.localdomain [127.0.0.1]) by discord.dyndns.org (8.13.4/8.13.4) with ESMTP id k0J7Ujtc002661; Wed, 18 Jan 2006 23:30:45 -0800 Date: Wed, 18 Jan 2006 23:30:45 -0800 (PST) From: Jeff Frost X-X-Sender: jeff@discord.dyndns.org To: sandhya cc: Postgres Subject: Re: Fw: lo_import problem In-Reply-To: <00e101c61cc7$7ea2dcb0$cd00000a@sandhyar> Message-ID: References: <00e101c61cc7$7ea2dcb0$cd00000a@sandhyar> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.12 required=5 tests=[AWL=0.120] X-Spam-Score: 0.12 X-Spam-Level: X-Archive-Number: 200601/211 X-Sequence-Number: 20299 This is what works for me from the command line on Linux with PG 8.0.3: INSERT into images VALUES ( lo_import('/tmp/white.jpg'), 'white'); What version of postgresql are you using? On Thu, 19 Jan 2006, sandhya wrote: > > > > 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. -- Jeff Frost, Owner Frost Consulting, LLC http://www.frostconsultingllc.com/ Phone: 650-780-7908 FAX: 650-649-1954 From sandhyar@amiindia.co.in Thu Jan 19 07:33:40 2006 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 61AC49DCA4D for ; Thu, 19 Jan 2006 03:33:40 -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 54911-06 for ; Thu, 19 Jan 2006 03:33:38 -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 8285E9DCA32 for ; Thu, 19 Jan 2006 03:33:35 -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 k0J7SV1W024762; Thu, 19 Jan 2006 12:58:31 +0530 Received: from sandhyar (unknown [10.0.0.205])by venus.amiindia.co.in (Postfix) with ESMTP id A496E33266A; Thu, 19 Jan 2006 12:58:31 +0530 (IST) Message-ID: <00f801c61ccb$27dcfa10$cd00000a@sandhyar> From: "sandhya" To: "Jeff Frost" Cc: "Postgres" References: <00e101c61cc7$7ea2dcb0$cd00000a@sandhyar> Subject: Re: Fw: lo_import problem Date: Thu, 19 Jan 2006 13:07:09 +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.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 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.074 required=5 tests=[AWL=0.073, UNPARSEABLE_RELAY=0.001] X-Spam-Score: 0.074 X-Spam-Level: X-Archive-Number: 200601/212 X-Sequence-Number: 20300 I am trying on windows............ It is not coming.Version is 8.0 ----- Original Message ----- From: "Jeff Frost" To: "sandhya" Cc: "Postgres" Sent: Thursday, January 19, 2006 1:00 PM Subject: Re: [ADMIN] Fw: lo_import problem > This is what works for me from the command line on Linux with PG 8.0.3: > > INSERT into images VALUES ( lo_import('/tmp/white.jpg'), 'white'); > > What version of postgresql are you using? > > On Thu, 19 Jan 2006, sandhya wrote: > > > > > > > > > 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. > > -- > Jeff Frost, Owner > Frost Consulting, LLC http://www.frostconsultingllc.com/ > Phone: 650-780-7908 FAX: 650-649-1954 > From sandhyar@amiindia.co.in Thu Jan 19 07:35:22 2006 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 8FF099DCA55 for ; Thu, 19 Jan 2006 03:35:22 -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 55247-03 for ; Thu, 19 Jan 2006 03:35:16 -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 23E289DCA4C for ; Thu, 19 Jan 2006 03:35:13 -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 k0J7U4jW025023; Thu, 19 Jan 2006 13:00:04 +0530 Received: from sandhyar (unknown [10.0.0.205])by venus.amiindia.co.in (Postfix) with ESMTP id DB3B4332669; Thu, 19 Jan 2006 13:00:02 +0530 (IST) Message-ID: <010101c61ccb$5e8a7970$cd00000a@sandhyar> From: "sandhya" To: "Jeff Frost" Cc: "Postgres" References: <00e101c61cc7$7ea2dcb0$cd00000a@sandhyar> Subject: Re: Fw: lo_import problem Date: Thu, 19 Jan 2006 13:08:40 +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.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 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.075 required=5 tests=[AWL=0.074, UNPARSEABLE_RELAY=0.001] X-Spam-Score: 0.075 X-Spam-Level: X-Archive-Number: 200601/213 X-Sequence-Number: 20301 I am trying on windows..I am getting the following error message. ERROR: could not open server file ----- Original Message ----- From: "Jeff Frost" To: "sandhya" Cc: "Postgres" Sent: Thursday, January 19, 2006 1:00 PM Subject: Re: [ADMIN] Fw: lo_import problem > This is what works for me from the command line on Linux with PG 8.0.3: > > INSERT into images VALUES ( lo_import('/tmp/white.jpg'), 'white'); > > What version of postgresql are you using? > > On Thu, 19 Jan 2006, sandhya wrote: > > > > > > > > > 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. > > -- > Jeff Frost, Owner > Frost Consulting, LLC http://www.frostconsultingllc.com/ > Phone: 650-780-7908 FAX: 650-649-1954 > From jeff@frostconsultingllc.com Thu Jan 19 07:43:27 2006 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 6E7769DCA25 for ; Thu, 19 Jan 2006 03:43:27 -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 56026-08 for ; Thu, 19 Jan 2006 03:43:27 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from smtp109.sbc.mail.mud.yahoo.com (smtp109.sbc.mail.mud.yahoo.com [68.142.198.208]) by postgresql.org (Postfix) with SMTP id CC7789DCA1D for ; Thu, 19 Jan 2006 03:43:24 -0400 (AST) Received: (qmail 16706 invoked from network); 19 Jan 2006 07:43:26 -0000 Received: from unknown (HELO discord.dyndns.org) (jeffroe996@sbcglobal.net@69.226.242.241 with plain) by smtp109.sbc.mail.mud.yahoo.com with SMTP; 19 Jan 2006 07:43:25 -0000 Received: from localhost (localhost.localdomain [127.0.0.1]) by discord.dyndns.org (8.13.4/8.13.4) with ESMTP id k0J7hQQT003629; Wed, 18 Jan 2006 23:43:26 -0800 Date: Wed, 18 Jan 2006 23:43:26 -0800 (PST) From: Jeff Frost X-X-Sender: jeff@discord.dyndns.org To: sandhya cc: Postgres Subject: Re: Fw: lo_import problem In-Reply-To: Message-ID: References: <00e101c61cc7$7ea2dcb0$cd00000a@sandhyar> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.12 required=5 tests=[AWL=0.120] X-Spam-Score: 0.12 X-Spam-Level: X-Archive-Number: 200601/214 X-Sequence-Number: 20302 This worked fine for me on a freshly installed 8.0.3 on Windows XP: pics=# INSERT into images VALUES ( lo_import('C:\\Program Files\\PostgreSQL\\8.0\\Installation Notes.rtf'), 'notes'); "could not open server file" means that either the file does not exist, or the user you are trying to access the file as does not have the rights to read it. Again, check your permissions as I mentioned to you earlier. On Wed, 18 Jan 2006, Jeff Frost wrote: > This is what works for me from the command line on Linux with PG 8.0.3: > > INSERT into images VALUES ( lo_import('/tmp/white.jpg'), 'white'); > > What version of postgresql are you using? > > On Thu, 19 Jan 2006, sandhya wrote: > >> >> >> >> 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. > > -- Jeff Frost, Owner Frost Consulting, LLC http://www.frostconsultingllc.com/ Phone: 650-780-7908 FAX: 650-649-1954 From sandhyar@amiindia.co.in Thu Jan 19 08:20:01 2006 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 638139DC80D for ; Thu, 19 Jan 2006 04:20:01 -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 62091-04 for ; Thu, 19 Jan 2006 04:20:01 -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 BFD639DC820 for ; Thu, 19 Jan 2006 04:19:54 -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 k0J8ESZb032376; Thu, 19 Jan 2006 13:44:29 +0530 Received: from sandhyar (unknown [10.0.0.205])by venus.amiindia.co.in (Postfix) with ESMTP id E7E7E332669; Thu, 19 Jan 2006 13:44:28 +0530 (IST) Message-ID: <011101c61cd1$938b99a0$cd00000a@sandhyar> From: "sandhya" To: "Jeff Frost" Cc: "Postgres" References: <00e101c61cc7$7ea2dcb0$cd00000a@sandhyar> Subject: Re: Fw: lo_import problem Date: Thu, 19 Jan 2006 13:53:07 +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.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 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.077 required=5 tests=[AWL=0.076, UNPARSEABLE_RELAY=0.001] X-Spam-Score: 0.077 X-Spam-Level: X-Archive-Number: 200601/215 X-Sequence-Number: 20303 ok...jeff thank you very much. I checked in pg_hba.conf and reloaded again and did now working fine. ----- Original Message ----- From: "Jeff Frost" To: "sandhya" Cc: "Postgres" Sent: Thursday, January 19, 2006 1:13 PM Subject: Re: [ADMIN] Fw: lo_import problem > This worked fine for me on a freshly installed 8.0.3 on Windows XP: > > pics=# INSERT into images VALUES ( lo_import('C:\\Program Files\\PostgreSQL\\8.0\\Installation Notes.rtf'), 'notes'); > > "could not open server file" means that either the file does not exist, or the > user you are trying to access the file as does not have the rights to read it. > > Again, check your permissions as I mentioned to you earlier. > > On Wed, 18 Jan 2006, Jeff Frost wrote: > > > This is what works for me from the command line on Linux with PG 8.0.3: > > > > INSERT into images VALUES ( lo_import('/tmp/white.jpg'), 'white'); > > > > What version of postgresql are you using? > > > > On Thu, 19 Jan 2006, sandhya wrote: > > > >> > >> > >> > >> 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. > > > > > > -- > Jeff Frost, Owner > Frost Consulting, LLC http://www.frostconsultingllc.com/ > Phone: 650-780-7908 FAX: 650-649-1954 > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend >