Re: psql FETCH_COUNT feature does not work with combined queries

2020-09-30 Thread Michael Paquier
On Thu, Jul 16, 2020 at 04:44:47PM -0700, David G. Johnston wrote: > When FETCH_COUNT is non-zero, and you send a multi-statement command > to the server (for example via -c or the \; meta-command), the results > are undefined. This combination is presently allowed for backward > compatibility.

Re: psql FETCH_COUNT feature does not work with combined queries

2020-07-16 Thread David G. Johnston
On Thu, Jul 16, 2020 at 4:24 PM Alvaro Herrera wrote: > On 2020-Jul-16, David Johnston wrote: > > > Instead of a note maybe add a paragraph stating: > > > > "This setting is ignored when multiple statements are sent to the server > as a single command (i.e., via the -c command line option or the

Re: psql FETCH_COUNT feature does not work with combined queries

2020-07-16 Thread Alvaro Herrera
On 2020-Jul-16, David Johnston wrote: > Instead of a note maybe add a paragraph stating: > > "This setting is ignored when multiple statements are sent to the server as a > single command (i.e., via the -c command line option or the \; meta-command). > Additionally, it is possible for certain

Re: psql FETCH_COUNT feature does not work with combined queries

2020-07-16 Thread David Johnston
The following review has been posted through the commitfest application: make installcheck-world: not tested Implements feature: not tested Spec compliant: not tested Documentation:tested, passed Fabien, There is a minor typo (works -> work) but overall I'm not a fan

Re: psql FETCH_COUNT feature does not work with combined queries

2020-03-27 Thread Fabien COELHO
Assuming there's no one willing to fix the behavior (and that seems unlikely given we're in the middle of a 2020-01 commitfest) it makes sense to at least document the behavior. That being said, I think the proposed patch may be a tad too brief. I don't think we need to describe the exact

Re: psql FETCH_COUNT feature does not work with combined queries

2020-03-27 Thread David Steele
Hi Fabien, On 1/6/20 5:20 PM, Tomas Vondra wrote: On Fri, Jul 26, 2019 at 04:13:23PM +, Fabien COELHO wrote: FETCH_COUNT does not work with combined queries, and probably has never worked since 2006. For the record, this bug has already been reported & discussed by Daniel Vérité a few

Re: psql FETCH_COUNT feature does not work with combined queries

2020-01-06 Thread Tomas Vondra
On Fri, Jul 26, 2019 at 04:13:23PM +, Fabien COELHO wrote: FETCH_COUNT does not work with combined queries, and probably has never worked since 2006. For the record, this bug has already been reported & discussed by Daniel Vérité a few months back, see:

Re: psql FETCH_COUNT feature does not work with combined queries

2019-07-26 Thread Fabien COELHO
FETCH_COUNT does not work with combined queries, and probably has never worked since 2006. For the record, this bug has already been reported & discussed by Daniel Vérité a few months back, see: