Raised notices are printed backwards

[jelder]

Description

Messages logged by functions are printed in reverse order, with None between lines.

BEGIN;

CREATE FUNCTION demo() RETURNS VOID AS
$_$
BEGIN 
    RAISE NOTICE 'first';
    RAISE NOTICE 'second';
    RAISE NOTICE 'third';
END;
$_$
LANGUAGE plpgsql;

SELECT demo();

ROLLBACK;

pgcli result:

third
None
second
None
first
None

psql result:

SELECT demo();
NOTICE:  00000: first
LOCATION:  exec_stmt_raise, pl_exec.c:3923
NOTICE:  00000: second
LOCATION:  exec_stmt_raise, pl_exec.c:3923
NOTICE:  00000: third
LOCATION:  exec_stmt_raise, pl_exec.c:3923

Your environment

PostgreSQL 15.3

• Please provide your OS and version information.
  macOS Sonoma 14.1.1
• Please provide your CLI version.
  pgcli 4.0.1
• What is the output of pip freeze command.
  Installed via Homebrew

-bash: /usr/local/bin/pip: cannot execute: required file not found

[ERYoung11]

I don't see the exact error message you do from psql. Here's what I see and I am working to make the output similar to this.

Do you have any idea why your output would look different from mine?

postgres=# BEGIN;
BEGIN
postgres=#
postgres=# CREATE FUNCTION demo() RETURNS VOID AS
postgres-# $_$
postgres$# BEGIN
postgres$# RAISE NOTICE 'first';
postgres$# RAISE NOTICE 'second';
postgres$# RAISE NOTICE 'third';
postgres$# END;
postgres$# $_$
postgres-# LANGUAGE plpgsql;
CREATE FUNCTION
postgres=#
postgres=# SELECT demo();
NOTICE: first
NOTICE: second
NOTICE: third
demo

(1 row)

[ERYoung11]

@jelder The PR has been merged. Does this solve your issue?

[j-bennet]

@jelder The PR has been merged. Does this solve your issue?

I still need to do a release, but for right now pgcli can be installed from main:

pip install git+https://github.com/dbcli/pgcli.git