Re: COPY command error in psql.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Matthew Stanfield <matthew(at)propertyknowledge(dot)com>
Cc: PostgreSQL General Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Re: COPY command error in psql.
Date: 2002-04-09 13:50:43
Message-ID: 28796.1018360243@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Matthew Stanfield <matthew(at)propertyknowledge(dot)com> writes:
> COPY ab FROM '/home/ms/db/csv/AB.csv'
> psql:batchfile:1: Error: Copy command, running in backend with effective
> uid 26, could not open file '/home/ms/db/csv/AB.csv' for reading. Errorno =
> permission denied (13).

> Now I understand why this happened the first time I ran the command as only
> user 'ms' had any kind of permission for AB.csv.

What about permissions on the containing directories? That path
requires search (x) permission on each directory traversed to reach the
file...

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2002-04-09 13:51:21 Re: COPY command error in psql.
Previous Message Tom Lane 2002-04-09 13:42:41 Re: SPI_execp() failed in RI_FKey_cascade_del()