Debugging set up for Postgres?

From: James Creasy <james(at)buildtrue(dot)io>
To: pgsql-general(at)postgresql(dot)org
Subject: Debugging set up for Postgres?
Date: 2024-08-08 17:15:33
Message-ID: CADN1ADdP5QrUqkMUDQAANnnajZkusp8+EEo-U8d8qto9=iv=vQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

We've spent about 12 hours trying to set up a working debugger for psql
functions without success, trying both PGAdmin 4 v8.3 and DBeaver.

The online searches turn up multiple instructions for Postgres 12 or older,
however we are using 16. Our extensions include PostGIS and supporting
extensions like SFCGAL.

We can get the PGAdmin debugger to stop at a breakpoint, but as soon as it
exits a function, PGAdmin crashes ("error when executing continue") and has
to be restarted.

We also tried direct debugging, but the inputs to our functions are often
json objects, and there isn't a way to paste such an object into the Value
field.

My question is: is there a way to effectively step debug psql functions in
Postgres 16 and how?

Thanks for reading,

James

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2024-08-08 17:40:29 Re: Debugging set up for Postgres?
Previous Message Adrian Klaver 2024-08-08 16:56:25 Re: Destination Table - Condition Amount 0