Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id A2D924758FE for ; Fri, 3 May 2002 05:57:43 -0400 (EDT) Received: from prodserver1.goatelecom.com (unknown [61.1.72.28]) by postgresql.org (Postfix) with ESMTP id 5B1D14758F2 for ; Fri, 3 May 2002 05:56:16 -0400 (EDT) Received: from goatelecom.com by prodserver1.goatelecom.com (8.9.3/1.1.20.3/07Jul00-0916AM) id PAA0000015861; Fri, 3 May 2002 15:36:39 +0530 (IST) Message-Id: <200205031006.PAA0000015861@prodserver1.goatelecom.com> From: Content-Transfer-Encoding: 8bit Subject: INserting images in postgres Date: Sun, 05 May 2002 05:01:02 +0530 To: pgsql-sql@postgresql.org MIME-Version: 1.0 User-Agent: IMHO/0.98.3 (Webmail for Roxen) Content-Type: text/plain; charset=iso-8859-1 X-Archive-Number: 200205/18 X-Sequence-Number: 7654 Hi, I made a table test in postgresql as follows CREATE TABLE test ( number INT; image OID ); but the moment i try to insert an image as a normal user it say it cant do so as a normaal user only superuser (/postgres) can do it. the command for insert is as follows INSERT INTO test VALUES ( 1,lo_import('/path/to/file')); If I want to implement the changes whereby my normal user should be able to insert into the dbase how do i do it ? Do i have to edit any file.I saw pg_hba.conf and other file but found no attributes near it and so also the SET and SHOW declaretions Can anyone point out the error Thanks Sharmad