Re: Permission denied in file_fdw (Windows)

From: Stefan Keller <sfkeller(at)gmail(dot)com>
To: Tomas Vondra <tv(at)fuzzy(dot)cz>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Permission denied in file_fdw (Windows)
Date: 2012-12-05 10:05:15
Message-ID: CAFcOn2_EXWhfY7Kfu-jKFuLmGLsCRGLi3K50SLPuvU1cV38Rmg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Thomas

Works like a charm no with different file path.

2012/12/5 Tomas Vondra <tv(at)fuzzy(dot)cz>:
> The file is opened from a
> PostgreSQL backend process, not using your regular user.

Thanks for the hint. Did'nt think of that - and I agree with this
implementation decision.
You are referring to RTFM below: May I dare to say that this is not
mentioned in the - otherwise good - docs?

> 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.

Ack. But let me object that from a readers view the sentence from the
docs "Data files must be in a format that can be read by COPY FROM;
see COPY for details." refers to the format of the file - not to the
syntax of the parameters (strictly speaking :->).

Yours, S.

2012/12/5 Tomas Vondra <tv(at)fuzzy(dot)cz>:
> 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
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general

In response to

Browse pgsql-general by date

  From Date Subject
Next Message ERR ORR 2012-12-05 11:59:20 Re: Table with million rows - and PostgreSQL 9.1 is not using the index
Previous Message Albe Laurenz 2012-12-05 09:19:59 Re: Database schema