Copy Error

From: san_kalyan(at)yahoo(dot)com (Chakravarthy K Sannedhi)
To: pgsql-hackers(at)postgresql(dot)org
Subject: Copy Error
Date: 2001-06-19 02:59:28
Message-ID: 6354d5e2.0106181859.2d433e1@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

When I am trying to import a file(named 'myfile') that is present in
my home directory into the the postgresql database using the
*pgaccess* gui tool, it is giving the following error.

ERROR: COPY command, running in backend with effective uid 26, could
not open file 'myfile' for reading. Errno=Permission denied

Can any one please tell me what I am missing here. Is it necessary for
the 'postgres' user to own the file named 'myfile' under my home
directory.

TIA
Chakravarthy K Sannedhi

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2001-06-19 04:49:01 temp-table-related failure in regression tests
Previous Message Bruce Momjian 2001-06-19 02:59:24 Re: timestamp with/without time zone