Re: psql FETCH_COUNT feature does not work with combined queries

From: Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>
To: PostgreSQL Developers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: psql FETCH_COUNT feature does not work with combined queries
Date: 2019-07-26 16:13:23
Message-ID: alpine.DEB.2.21.1907261608270.327@lancre
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


> 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:

https://www.postgresql.org/message-id/flat/a0a854b6-563c-4a11-bf1c-d6c6f924004d%40manitou-mail.org

Given the points of view expressed on this thread, especially Tom's view
against improving the lexer used by psql to known where query ends, it
looks that my documentation patch is the way to go in the short term, and
that if the "always show query results" patch is committed, it might
simplify a bit solving this issue as the PQexec call is turned into
PQsendQuery.

--
Fabien.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Ryan Lambert 2019-07-26 16:20:34 Re: Built-in connection pooler
Previous Message Masahiko Sawada 2019-07-26 15:27:58 Re: [Proposal] Table-level Transparent Data Encryption (TDE) and Key Management Service (KMS)