Re: session username in default psql prompt? - Mailing list pgsql-hackers

On Mon, Mar 25, 2024 at 6:32 PM Jelte Fennema-Nio <postgres@jeltef.nl> wrote:
>
> Obviously I meant to put the \n before the %:
> \set PROMPT1 '%n@%~%R\n%# '
>

transaction related information lost.

for example:
jian@src6=
# begin;
BEGIN
jian@src6=
# select 1/0;
2024-03-25 18:37:59.313 CST [15252] ERROR:  division by zero
2024-03-25 18:37:59.313 CST [15252] STATEMENT:  select 1/0;
ERROR:  division by zero
jian@src6=
# rollback ;
ROLLBACK


master behavior:
src6=# begin ;
BEGIN
src6=*# select 1/0;
2024-03-25 18:38:31.997 CST [24688] ERROR:  division by zero
2024-03-25 18:38:31.997 CST [24688] STATEMENT:  select 1/0;
ERROR:  division by zero
src6=!# rollback ;
ROLLBACK