inserting a file into a database. - Mailing list pgsql-novice

Hi all,

I'm trying to insert a file into a database from a php form. Here's my sql
statement..

$sql="insert into scripts (id, submittedby, description, script, scriptfile)
values (nextval('scripts_id_seq'), '$loginname', '$description', '$script',
lo_import('$userfile'))";

Here's the error I get..

Warning: PostgresSQL query failed: ERROR: You must have Postgres superuser
privilege to use server-side lo_import(). Anyone can use the client-side
lo_import() provided by libpq. in put-file.php on line 4

OK, I understand the error, no problems. How do I fix it? How do I get around
it? Anyone have a better solution for the sql statement? I don't want to use
libpq, I wanted to be able to do it with php. My webserver runs as "wwwrun", my
postgres superuser is "postgres".

Here's my permission table..

xxxx=# \z
Access permissions for database "xxxx"
     Relation     | Access permissions
------------------+---------------------
 scripts          | {"=","wwwrun=arwR"}
 scripts_id_seq   | {"=","wwwrun=arwR"}

If anyone has some suggestions, please let me know.

Thanks,
Chris.




This email message and any accompanying attachments may contain information that
is confidential and subject to legal privilege.  If you are not the intended
recipient, do not read, use, disseminate, distribute or copy this message or
attachments.  If you have received this message in error, please notify the
sender immediately and delete this message.  Any views expressed in this message
are those of the individual sender, except where the sender expressly, and with
authority, states them to be the views of AMP/GIO.  Before opening any
attachments, please check them for viruses and defects.