Re: unexpected psql "feature"

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: unexpected psql "feature"
Дата
Msg-id CAKFQuwaADV-WyLtpB455J_MZ6bT8A6Ld6SU1Zya+Zajejm1JtQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: unexpected psql "feature"  (Fabien COELHO <coelho@cri.ensmp.fr>)
Ответы Re: unexpected psql "feature"  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список pgsql-hackers
On Wed, Jul 13, 2016 at 5:44 PM, Fabien COELHO <coelho@cri.ensmp.fr> wrote:

Hello Tom,

Although "\;" behavior is not documented, I would have expected both
results to be shown one after the other, or having a an error, but not a
quiet discard.

See the documentation for PQexec(): all but the last query result is
discarded.

Sure. That is developer-level answer to "why", although it does not really say why the developer chose PQexex over PQsendQuery. At the user-level the behavior is still pretty surprising.

​Lets try putting it this way...

As a psql user I want some way to choose whether I send my query via "PQexec" or "PQsendQuery".  I'm not sure why the "PQexec" access point is undocumented but this "\;" syntax, vis-a-vis ";" provides me that choice.

David J.

В списке pgsql-hackers по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: unexpected psql "feature"
Следующее
От: Tom Lane
Дата:
Сообщение: Upcoming PG release schedule