Re: COPY fails to read source file

On Tue, May 16, 2000 at 01:57:19PM -0400, Bill Barnes wrote:
> 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

What do permissions on home and billb look like? I'm guessing your missing
an 'x' in there (probably on billb).

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

That the two examples have different paths through the filesystem tree.

Ross

--
Ross J. Reedstrom, Ph.D., <reedstrm(at)rice(dot)edu>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005