I have been trying to import a file into a table using lo_import and keep
getting the error
ERROR: could not open server file "/tmp/myfile": Permission denied
The file is in /tmp so it is world readable and I made sure the file had the
correct permissions by doing chmod 777. My user has super user privileges as
well. I tried importing other files such as /etc/hosts as a test and this
worked fine. I am running Gentoo linux with Postgres 8.0. Does anyone have
any idea what the problem is and what I need to do to correct it?
Thanks in advance