PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID15449
PG Version10.5
OSUbuntu 16.04.2 LTS (Xenial Xerus)
Opened2018-10-22 14:00:50+00
Reported byEric Cyr
StatusOpen

Body of first available message related to this bug follows.

The following bug has been logged on the website:

Bug reference:      15449
Logged by:          Eric Cyr
Email address:      (redacted)
PostgreSQL version: 10.5
Operating system:   Ubuntu 16.04.2 LTS (Xenial Xerus)
Description:        

CREATE FOREIGN TABLE test_file_fdw_program_limit
    (
      message text
    )
    SERVER pg_log_fdw OPTIONS (program 'echo "test"', format 'csv')
;

--

SELECT * FROM test_file_fdw_program_limit;
/*
OK
*/

SELECT * FROM test_file_fdw_program_limit LIMIT 2;
/*
OK
*/

SELECT * FROM test_file_fdw_program_limit LIMIT 0;
/*
[38000] ERROR: program "echo "test"" failed Detail: child process exited
with exit code 1
*/

--

LIMIT 0 is the easiest way we found to reproduce the error, but we
encountered same issue with LIMIT (< file lines) on a program doing an if
exists + file output stream manipulation.

Messages

DateAuthorSubject
2018-10-22 14:00:50+00=?utf-8?q?PG_Bug_reporting_form?=BUG #15449: file_fdw using program cause exit code error when using LIMIT
2018-10-22 17:27:58+00Tom LaneRe: BUG #15449: file_fdw using program cause exit code error when using LIMIT
2018-10-23 12:21:31+00Tom LaneRe: BUG #15449: file_fdw using program cause exit code error when using LIMIT
2018-10-29 06:58:17+00Kyotaro HORIGUCHIRe: BUG #15449: file_fdw using program cause exit code error when using LIMIT
2018-11-02 13:05:36+00Etsuro FujitaRe: BUG #15449: file_fdw using program cause exit code error when using LIMIT
2018-11-06 03:53:04+00Kyotaro HORIGUCHIRe: BUG #15449: file_fdw using program cause exit code error when using LIMIT
2018-11-06 10:50:33+00Thomas MunroRe: BUG #15449: file_fdw using program cause exit code error when using LIMIT
2018-11-06 12:07:37+00Etsuro FujitaRe: BUG #15449: file_fdw using program cause exit code error when using LIMIT
2018-11-07 00:22:45+00Kyotaro HORIGUCHIRe: BUG #15449: file_fdw using program cause exit code error when using LIMIT
2018-11-07 03:44:33+00Etsuro FujitaRe: BUG #15449: file_fdw using program cause exit code error when using LIMIT
2018-11-07 10:03:32+00Etsuro FujitaRe: BUG #15449: file_fdw using program cause exit code error when using LIMIT
2018-11-08 01:50:35+00Thomas MunroRe: BUG #15449: file_fdw using program cause exit code error when using LIMIT
2018-11-08 12:52:31+00Etsuro FujitaRe: BUG #15449: file_fdw using program cause exit code error when using LIMIT
2018-11-09 05:39:31+00Kyotaro HORIGUCHIRe: BUG #15449: file_fdw using program cause exit code error when using LIMIT
2018-11-09 07:32:54+00Thomas MunroRe: BUG #15449: file_fdw using program cause exit code error when using LIMIT
2018-11-09 09:27:09+00Etsuro FujitaRe: BUG #15449: file_fdw using program cause exit code error when using LIMIT
2018-11-12 09:23:51+00Kyotaro HORIGUCHIRe: BUG #15449: file_fdw using program cause exit code error when using LIMIT
2018-11-12 09:52:14+00Kyotaro HORIGUCHIRe: BUG #15449: file_fdw using program cause exit code error when using LIMIT
2018-11-12 11:41:40+00Etsuro FujitaRe: BUG #15449: file_fdw using program cause exit code error when using LIMIT
2018-11-13 09:50:58+00Etsuro FujitaRe: BUG #15449: file_fdw using program cause exit code error when using LIMIT