Re: file_fdw vs relative paths

2020-09-09 Thread Magnus Hagander
On Wed, Sep 9, 2020 at 3:39 AM Ian Barwick wrote: > Hi > > On 2020/09/07 2:31, Magnus Hagander wrote: > > On Mon, Aug 31, 2020 at 5:03 PM Bruce Momjian br...@momjian.us>> wrote: > > > > On Mon, Aug 31, 2020 at 01:16:05PM +0200, Magnus Hagander wrote: > > > Bruce, I've applied and

Re: file_fdw vs relative paths

2020-09-08 Thread Ian Barwick
Hi On 2020/09/07 2:31, Magnus Hagander wrote: On Mon, Aug 31, 2020 at 5:03 PM Bruce Momjian mailto:br...@momjian.us>> wrote: On Mon, Aug 31, 2020 at 01:16:05PM +0200, Magnus Hagander wrote: >     Bruce, I've applied and backpatched your docs patch for this. > > Gah, and of

Re: file_fdw vs relative paths

2020-09-06 Thread Magnus Hagander
On Mon, Aug 31, 2020 at 5:03 PM Bruce Momjian wrote: > On Mon, Aug 31, 2020 at 01:16:05PM +0200, Magnus Hagander wrote: > > Bruce, I've applied and backpatched your docs patch for this. > > > > Gah, and of course right after doing that, I remembered I wanted to get a > > second change in :)

Re: file_fdw vs relative paths

2020-08-31 Thread Bruce Momjian
On Mon, Aug 31, 2020 at 01:16:05PM +0200, Magnus Hagander wrote: > Bruce, I've applied and backpatched your docs patch for this. > > Gah, and of course right after doing that, I remembered I wanted to get a > second change in :) To solve the "who's this Josh" question, I suggest we also >

Re: file_fdw vs relative paths

2020-08-31 Thread Magnus Hagander
On Mon, Aug 31, 2020 at 1:10 PM Magnus Hagander wrote: > > > On Tue, Aug 25, 2020 at 9:28 AM Li Japin wrote: > >> >> On Aug 25, 2020, at 8:26 AM, Bruce Momjian wrote: >> >> Yes, I tested back to 9.5 too: >> >> CREATE EXTENSION file_fdw; >> CREATE SERVER pgconf FOREIGN DATA WRAPPER file_fdw; >>

Re: file_fdw vs relative paths

2020-08-31 Thread Magnus Hagander
On Tue, Aug 25, 2020 at 9:28 AM Li Japin wrote: > > On Aug 25, 2020, at 8:26 AM, Bruce Momjian wrote: > > Yes, I tested back to 9.5 too: > > CREATE EXTENSION file_fdw; > CREATE SERVER pgconf FOREIGN DATA WRAPPER file_fdw; > CREATE FOREIGN TABLE pgconf (line TEXT) SERVER pgconf OPTIONS (

Re: file_fdw vs relative paths

2020-08-25 Thread Li Japin
On Aug 25, 2020, at 8:26 AM, Bruce Momjian mailto:br...@momjian.us>> wrote: Yes, I tested back to 9.5 too: CREATE EXTENSION file_fdw; CREATE SERVER pgconf FOREIGN DATA WRAPPER file_fdw; CREATE FOREIGN TABLE pgconf (line TEXT) SERVER pgconf OPTIONS ( filename 'postgresql.conf', format 'text',

Re: file_fdw vs relative paths

2020-08-24 Thread Bruce Momjian
On Wed, Jul 15, 2020 at 01:22:21PM +0200, Magnus Hagander wrote: > According to the documentation, the filename given in file_fdw must be an > absolute path. Hwever, it works perfectly fine with a relative path. > > So either the documentation is wrong, or the code is wrong. It behaves the >

file_fdw vs relative paths

2020-07-15 Thread Magnus Hagander
According to the documentation, the filename given in file_fdw must be an absolute path. Hwever, it works perfectly fine with a relative path. So either the documentation is wrong, or the code is wrong. It behaves the same at least back to 9.5, I did not try it further back than that. I can't