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
------------------------------------------------------------
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 |