COPY fails to read source file

From: Bill Barnes <bbarnes(at)operamail(dot)com>
To: postgres general mail list <pgsql-general(at)postgresql(dot)org>
Subject: COPY fails to read source file
Date: 2000-05-16 17:57:19
Message-ID: 39261F06@operamail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello all:

Using 6.5.3, SuSE 6.4, logged in as 'billb'.

Here are 2 instances of the COPY command;

-----------------------------------------------------------------------------
copy custprofile from '/home/billb/custpr.txt' using delimiters ';';
The result is:
ERROR: COPY command, running in backend with with effective uid 26, could
not open '/home/billb/custpr.txt' for reading. Errno = Permission denied
(13).
The file looks like
-rw-r--r-- 1 billb users 58902 May 16 11:45 /home/billb/custpr.txt

----------------------------------------------------------------------------
copy custprofile from '/mnt/DOS_C/sybase/custpr.txt' using delimiters ';';
The result is:
COPY
The file looks like
-rwxr-xr-x 1 root root 58902 May 16 11.56 /mnt/DOS_C/sybase/custpr.txt

---------------------------------------------------------------------------

The second instance gave me the results I wanted, but why did the first
instance fail? If anything, I would have expected permission denied on the
root owner. I have had the same results on other ocassions.

What am I missing?

TIA
Bill Barnes

------------------------------------------------------------
This e-mail has been sent to you courtesy of OperaMail, a
free web-based service from Opera Software, makers of
the award-winning Web Browser - http://www.operasoftware.com
------------------------------------------------------------

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Robert B. Easter 2000-05-16 18:41:10 max tuple size and filesystem block size
Previous Message Ron Peterson 2000-05-16 17:07:19 Re: Re: search.cgi not found on ur site