Re: Let file_fdw access COPY FROM PROGRAM - Mailing list pgsql-hackers

From Corey Huinker
Subject Re: Let file_fdw access COPY FROM PROGRAM
Date
Msg-id CADkLM=fXRcCxVduC8ntLFkRLkqUkzN5vTiWMc_iEzBqdPkhT+w@mail.gmail.com
Whole thread
In response to Re: Let file_fdw access COPY FROM PROGRAM  (Craig Ringer <craig.ringer@2ndquadrant.com>)
Responses Re: Let file_fdw access COPY FROM PROGRAM
List pgsql-hackers
On Tue, Sep 6, 2016 at 6:53 PM, Craig Ringer <craig.ringer@2ndquadrant.com> wrote:

On 7 Sep. 2016 02:14, "Corey Huinker" <corey.huinker@gmail.com> wrote:
>

> Having regression tests for this is extremely problematic, because the program invoked would need to be an invokable command on any architecture supported by postgres. I'm pretty sure no such command exists.

Your best bet will be using the TAP framework. There you can use Perl logic.

I'm not sure where to put such a test though. It doesn't really make sense in src/test/recovery/ .


And the TAP test would detect the operating system and know to create an FDW that has the PROGRAM value 'cat test_data.csv' on Unix, 'type test_data.csv' on windows, and 'type test_data.csv;1' on VMS? 

pgsql-hackers by date:

Previous
From: Masahiko Sawada
Date:
Subject: Re: Optimization for lazy_scan_heap
Next
From: Craig Ringer
Date:
Subject: Re: Suggestions for first contribution?