Horton

Re: select limit error in file_fdw

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Erik Rijkers <er@xs4all.nl>
Cc: pgsql-hackers@lists.postgresql.org
Date: 2018-12-16T06:03:07Z
Lists: pgsql-hackers 
Erik Rijkers <er@xs4all.nl> writes:
> I have noticed that since ffa4cbd623, a foreign table that pulls data
> from a PROGRAM (in this case an unzip call) will fail if there is a 
> LIMIT on the SELECT
> (while succeeding without LIMIT). Below is an example.

Um ... this example works for me, in both HEAD and v11 branch tip.
Moreover, the behavior you describe is exactly what ffa4cbd623 was
intended to fix.  Is there any chance that you got 11.1 and v11
branch tip mixed up?

If not, there must be some platform-specific behavior involved.
What are you testing on, exactly?

			regards, tom lane

Commits

  1. Improve detection of child-process SIGPIPE failures.

  2. Handle EPIPE more sanely when we close a pipe reading from a program.