| From: | "Thalis A(dot) Kalfigopoulos" <thalis(at)cs(dot)pitt(dot)edu> |
|---|---|
| To: | Chakravarthy K Sannedhi <san_kalyan(at)yahoo(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Copy Error |
| Date: | 2001-06-20 21:19:41 |
| Message-ID: | Pine.LNX.4.21.0106201717290.24987-100000@aluminum.cs.pitt.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Give the fullname of the file. Make sure the file is on the server machine and not your local machine (in case you are forwarding pgaccess to another X terminal)
cheers,
thalis
On 16 Jun 2001, Chakravarthy K Sannedhi wrote:
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thalis A. Kalfigopoulos | 2001-06-20 21:21:51 | Re: ExecEvalExpr: unknown expression type 704 problems |
| Previous Message | Stephan Szabo | 2001-06-20 21:16:59 | Re: performance tuning or real bug ? |