Copy Error - Mailing list pgsql-general

From san_kalyan@yahoo.com (Chakravarthy K Sannedhi)
Subject Copy Error
Date
Msg-id 6354d5e2.0106162126.60cfc679@posting.google.com
Whole thread Raw
Responses Re: Copy Error  ("Thalis A. Kalfigopoulos" <thalis@cs.pitt.edu>)
List pgsql-general
Hi,

When I am trying to import a file in my home directory into the the
pgsql database using the *pgaccess* gui tool, it is giving the
following message.

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

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

TIA
Chakravarthy K Sannedhi

pgsql-general by date:

Previous
From: Jeff Waugh
Date:
Subject: Re: Permissions & Ownership (BUG?)
Next
From: gyoungblood@quicknet.net (Gregory Youngblood)
Date:
Subject: ExecEvalExpr: unknown expression type 704 problems