Is pgAdmin the only front-end to PostgreSQL debugger ? And is "a working pl/pgsql debugger" something core should care to maintain ? - Mailing list pgsql-hackers

From Hannu Krosing
Subject Is pgAdmin the only front-end to PostgreSQL debugger ? And is "a working pl/pgsql debugger" something core should care to maintain ?
Date
Msg-id CAMT0RQQ19QZ9VfeepC5spbLWj5OOY-7u0aPVgWFWGcMUkr5+8A@mail.gmail.com
Whole thread Raw
Responses Re: Is pgAdmin the only front-end to PostgreSQL debugger ? And is "a working pl/pgsql debugger" something core should care to maintain ?
List pgsql-hackers
Hallo PostgreSQL Hackers,


We recently discovered an error where pgAdmin fails when stepping into
nested function calls (
https://github.com/pgadmin-org/pgadmin4/issues/8443 ).

So while waiting for this to be fixed I would want to know if there
are other debugger front-ends that could be used to do basic debugging
of pl/pgsql code ?

And would these need a separate debugging extension, or is "debugging"
meant to be a generic PostgreSQL server feature that has a
well-defined API ?

I know there used to be another debugger as part of OmniDB which had
its own server-side extension as well, but wanted to know what is the
general thinking on this.

Is debugging pl/pgsq a generic feature of PostgreSQL core considering
that pl/pgsql itself kind of is ?

Should there be something similar for debugging plain SQL and possibly
other PL languages?

Should there perhaps be debugging support in psql ?

------
Hannu



pgsql-hackers by date:

Previous
From: Ranier Vilela
Date:
Subject: Re: pg17.3 PQescapeIdentifier() ignores len
Next
From: Sami Imseih
Date:
Subject: Re: Proposal - Allow extensions to set a Plan Identifier