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@rice.edu>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St.,  Houston, TX 77005