On Mon, Mar 25, 2024 at 6:32 PM Jelte Fennema-Nio <postg...@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