Re: COPY fails to read source file - Mailing list pgsql-general

From Lincoln Yeoh
Subject Re: COPY fails to read source file
Date
Msg-id 3.0.5.32.20000517181711.008feb90@pop.mecomb.po.my
Whole thread Raw
In response to COPY fails to read source file  (Bill Barnes <bbarnes@operamail.com>)
List pgsql-general
I believe when you use the sql style COPY, the database engine is the one
going out to fetch your file, using the backend UID and associated
permissions.

Whereas if you use the psql \copy, it's using the UID and perms of what you
are running psql as.

If the database engine cannot reach the file through the filesystem tree,
it can't copy it.

Cheerio,
Link.

At 01:57 PM 16-05-2000 -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
>
>----------------------------------------------------------------------------
>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
>------------------------------------------------------------
>
>
>


pgsql-general by date:

Previous
From: Dragos Stoichita
Date:
Subject: Re:simple question for users and db
Next
From: Karl DeBisschop
Date:
Subject: Re: Am I really stupid???