From: | Tomas Vondra <tv(at)fuzzy(dot)cz> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Permission denied in file_fdw (Windows) |
Date: | 2012-12-04 23:56:10 |
Message-ID: | 50BE8D9A.9080307@fuzzy.cz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
On 5.12.2012 00:39, Stefan Keller wrote:
> Hi
>
> I'm getting an error when reading from a file_fdw table in a Windows
> environment.
> Any hints? (see below).
Well, the file clearly isn't accessible by the postgres user (or
whatever user you're using in Windows). The file is opened from a
PostgreSQL backend process, not using your regular user.
> And http://www.postgresql.org/docs/9.1/static/file-fdw.html is not
> really verbose :->
> At least following format options should be mentioned: 'xml', 'text',
> 'csv', 'binary'.
It clearly states that "format" accepts the same values as COPY and even
provides a link to COPY documentation. Placing this kind of details onto
both pages would be just maintenance burden.
> Yours, Stefan
>
>
> That's what I'm doing:
>
> CREATE EXTENSION file_fdw;
>
> CREATE SERVER file_server FOREIGN DATA WRAPPER file_fdw;
>
> CREATE FOREIGN TABLE foreignfiletable(id text, title text)
> SERVER file_server
> OPTIONS(format 'csv', header 'true', filename
> 'C:/Users/someuser/Downloads/file.csv', delimiter '|', null '');
>
> SELECT * FROM foreignfiletable;
> -- ERROR: file »C:/Users/someuser/Downloads/file.csv« could not be
> opened for reading: Permission denied.
What else could PostgreSQL tell you? It tried to open the file, did a
regular open() or something like that and it failed with EACCES error
code. That's all the info there is.
Tomas
From | Date | Subject | |
---|---|---|---|
Next Message | Kenneth Tilton | 2012-12-05 01:04:59 | How get column-wise table info from an arbitrary query? |
Previous Message | Raymond O'Donnell | 2012-12-04 23:48:39 | Re: Permission denied in file_fdw (Windows) |