Re: [GENERAL] Permission denied in file_fdw (Windows)

2012-12-05 Thread Stefan Keller
Hi Thomas Works like a charm no with different file path. 2012/12/5 Tomas Vondra : > 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: Ma

Re: [GENERAL] Permission denied in file_fdw (Windows)

2012-12-04 Thread Tomas Vondra
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 P

Re: [GENERAL] Permission denied in file_fdw (Windows)

2012-12-04 Thread Raymond O'Donnell
On 04/12/2012 23: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). > > And http://www.postgresql.org/docs/9.1/static/file-fdw.html is not > really verbose :-> > At least following format options should b