| From: | Corey Huinker <corey(dot)huinker(at)gmail(dot)com> |
|---|---|
| To: | Craig Ringer <craig(dot)ringer(at)2ndquadrant(dot)com> |
| Cc: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp> |
| Subject: | Re: Let file_fdw access COPY FROM PROGRAM |
| Date: | 2016-09-07 03:21:20 |
| Message-ID: | CADkLM=fXRcCxVduC8ntLFkRLkqUkzN5vTiWMc_iEzBqdPkhT+w@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Tue, Sep 6, 2016 at 6:53 PM, Craig Ringer <craig(dot)ringer(at)2ndquadrant(dot)com>
wrote:
> On 7 Sep. 2016 02:14, "Corey Huinker" <corey(dot)huinker(at)gmail(dot)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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Haribabu Kommi | 2016-09-07 03:22:37 | Re: [sqlsmith] Failed assertion in joinrels.c |
| Previous Message | Masahiko Sawada | 2016-09-07 03:13:15 | Re: Optimization for lazy_scan_heap |