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 >