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

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to