From: | "Daniel Verite" <daniel(at)manitou-mail(dot)org> |
---|---|
To: | "Fabien COELHO" <coelho(at)cri(dot)ensmp(dot)fr> |
Cc: | "Iwata, Aya" <iwata(dot)aya(at)jp(dot)fujitsu(dot)com>,"PostgreSQL Developers" <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
Subject: | RE: psql - add SHOW_ALL_RESULTS option |
Date: | 2019-05-15 16:41:32 |
Message-ID: | 710caf32-a5f9-4511-bd9d-736c1a91f4c3@manitou-mail.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Fabien COELHO wrote:
> >> IMHO this new setting should be on by default: few people know about \; so
> >> it would not change anything for most, and I do not see why those who use
> >> it would not be interested by the results of all the queries they asked for.
> > I agree with your opinion.
>
> Ok. I did not yet change the default in the attached version, though.
I'd go further and suggest that there shouldn't be a variable
controlling this. All results that come in should be processed, period.
It's not just about \; If the ability of CALL to produce multiple
resultsets gets implemented (it was posted as a POC during v11
development), this will be needed too.
> This attached version does:
> - ensure that warnings appear just before its
> - add the entry in psql's help
> - redefine the function boundary so that timing is cleaner
> - include somehow improved tests
\errverbose seems to no longer work with the patch:
test=> select 1/0;
psql: ERROR: division by zero
test=> \errverbose
There is no previous error.
as opposed to this output with PG11:
test=> \errverbose
ERROR: 22012: division by zero
LOCATION: int4div, int.c:820
\errverbose has probably no regression tests because its output
includes these ever-changing line numbers; hence `make check`
cannot be used to find this regression.
Best regards,
--
Daniel Vérité
PostgreSQL-powered mailer: http://www.manitou-mail.org
Twitter: @DanielVerite
From | Date | Subject | |
---|---|---|---|
Next Message | Korry Douglas | 2019-05-15 16:55:33 | Parallel Foreign Scans - need advice |
Previous Message | Tomas Vondra | 2019-05-15 16:35:47 | Re: error messages in extended statistics |