Re: select limit error in file_fdw - Mailing list pgsql-hackers

From Tom Lane
Subject Re: select limit error in file_fdw
Date
Msg-id 27400.1544940187@sss.pgh.pa.us
Whole thread Raw
In response to select limit error in file_fdw  (Erik Rijkers <er@xs4all.nl>)
Responses Re: select limit error in file_fdw  (Erik Rijkers <er@xs4all.nl>)
List 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


pgsql-hackers by date:

Previous
From: Erik Rijkers
Date:
Subject: select limit error in file_fdw
Next
From: Michael Paquier
Date:
Subject: Re: [HACKERS] REINDEX CONCURRENTLY 2.0