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
