Re: file_fdw vs relative paths - Mailing list pgsql-hackers

From Magnus Hagander
Subject Re: file_fdw vs relative paths
Date
Msg-id CABUevExDnwCm=xnXAwqdYYRyCZ=z00ijy_WkkhQPan6NO0=djg@mail.gmail.com
Whole thread Raw
In response to Re: file_fdw vs relative paths  (Ian Barwick <ian.barwick@2ndquadrant.com>)
List pgsql-hackers
On Wed, Sep 9, 2020 at 3:39 AM Ian Barwick <ian.barwick@2ndquadrant.com> wrote:
Hi

On 2020/09/07 2:31, Magnus Hagander wrote:
> On Mon, Aug 31, 2020 at 5:03 PM Bruce Momjian <bruce@momjian.us <mailto:bruce@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 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
>      > change the example to point to the data/log directory which is likely to exist
>      > in a lot more of the cases. I keep getting people who ask "who is josh" based
>      > on the /home/josh path. Not that it's that important, but...
>
>     Thanks, and agreed.
>
>
> Thanks, applied. I backpacked to 13 but didn't bother with the rest as it's not technically *wrong* before..

It's missing the leading single quote from the filename parameter:

     diff --git a/doc/src/sgml/file-fdw.sgml b/doc/src/sgml/file-fdw.sgml
     (...)
     -OPTIONS ( filename '/home/josh/data/log/pglog.csv', format 'csv' );
     +OPTIONS ( filename log/pglog.csv', format 'csv' );
     (...)

GAH.

Thanks!

 
--

pgsql-hackers by date:

Previous
From: "Andrey M. Borodin"
Date:
Subject: Re: Yet another fast GiST build
Next
From: Alexey Kondratov
Date:
Subject: Re: Global snapshots