Re: BUG #16096: psql (non-interactive mode) SQL multi-request commandsdon't report all feedback ?! - Mailing list pgsql-bugs

From Fabien COELHO
Subject Re: BUG #16096: psql (non-interactive mode) SQL multi-request commandsdon't report all feedback ?!
Date
Msg-id alpine.DEB.2.21.1911061226320.21586@lancre
Whole thread Raw
In response to BUG #16096: psql (non-interactive mode) SQL multi-request commands don't report all feedback ?!  (PG Bug reporting form <noreply@postgresql.org>)
List pgsql-bugs
Bonjour Alain,

> When performing one INSERT SQL command in non-interactive mode I get a
> feedback about the number of line inserted. OK
> When performing the INSERT command SQL request following by for example a
> select ; I don't get any feedback of the insert command !!??

This is because -c passes the string as ONE sql command, and for 
multi-statement commands psql only reports about the last one.

The equivalent in interactive mode is to use \; between SQL commands.

ISTM that this is the documented behavior, so it is not a bug.

There is a submitted patch to change it to show all results:

     https://commitfest.postgresql.org/25/2096/

-- 
Fabien.



pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #16096: psql (non-interactive mode) SQL multi-request commands don't report all feedback ?!
Next
From: Thomas Butz
Date:
Subject: Re: BUG #16095: Segfault while executing trigger