MIME-Version: 1.0
References: <CADN1ADdP5QrUqkMUDQAANnnajZkusp8+EEo-U8d8qto9=iv=vQ@mail.gmail.com>
In-Reply-To: <CADN1ADdP5QrUqkMUDQAANnnajZkusp8+EEo-U8d8qto9=iv=vQ@mail.gmail.com>
From: Pavel Stehule <pavel.stehule@gmail.com>
Date: Thu, 8 Aug 2024 19:40:29 +0200
Message-ID: <CAFj8pRCGzCu_SN45K+wvOs+npAN6nN3qhb5VJW-tqXX-mhVp_w@mail.gmail.com>
Subject: Re: Debugging set up for Postgres?
To: James Creasy <james@buildtrue.io>
Cc: pgsql-general@postgresql.org
Content-Type: multipart/alternative; boundary="000000000000077643061f2f8845"
Archived-At: <https://www.postgresql.org/message-id/CAFj8pRCGzCu_SN45K%2BwvOs%2BnpAN6nN3qhb5VJW-tqXX-mhVp_w%40mail.gmail.com>
Precedence: bulk

--000000000000077643061f2f8845
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hi

=C4=8Dt 8. 8. 2024 v 19:16 odes=C3=ADlatel James Creasy <james@buildtrue.io=
> napsal:

> 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 i=
t
> exits a function, PGAdmin crashes ("error when executing continue") and h=
as
> 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 Valu=
e
> field.
>
> My question is: is there a way to effectively step debug psql functions i=
n
> Postgres 16 and how?
>

Do you think plpgsql functions?

There should not be any change if I know - you need to use PLdebugger
extension, and then you can use plpgsql debugger.

Maybe you use more extensions that use plpgsql debug API in one moment -
plprofiler, or plpgsql_check. This is not supported (plpgsql_check is
exception, but it should be loaded last).

Regards

Pavel


>
> Thanks for reading,
>
> James
>

--000000000000077643061f2f8845
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>Hi<br></div><br><div class=3D"gmail_quote"><div dir=
=3D"ltr" class=3D"gmail_attr">=C4=8Dt 8. 8. 2024 v=C2=A019:16 odes=C3=ADlat=
el James Creasy &lt;<a href=3D"mailto:james@buildtrue.io">james@buildtrue.i=
o</a>&gt; napsal:<br></div><blockquote class=3D"gmail_quote" style=3D"margi=
n:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex=
"><div dir=3D"ltr">Hi all,<div><br></div><div>We&#39;ve spent about 12 hour=
s trying to set up a working debugger for psql functions without success, t=
rying both PGAdmin 4 v8.3 and DBeaver.=C2=A0</div><div><br></div><div>The o=
nline searches turn up multiple instructions for Postgres 12 or older, howe=
ver we are using 16. Our extensions include PostGIS and supporting extensio=
ns like SFCGAL.=C2=A0</div><div><br></div><div>We can get the PGAdmin debug=
ger to stop at a breakpoint, but as soon as it exits a function, PGAdmin cr=
ashes (&quot;error when executing continue&quot;) and has to be restarted.=
=C2=A0</div><div><br></div><div>We also tried direct debugging, but the inp=
uts to our functions are often json objects, and there isn&#39;t a way to p=
aste such an object into the Value field.</div><div><br></div><div>My quest=
ion is: is there a way to effectively step debug psql functions in Postgres=
 16 and how?=C2=A0</div></div></blockquote><div><br></div><div>Do you think=
 plpgsql functions?</div><div><br></div><div>There should not be any change=
 if I know - you need to use PLdebugger extension, and then you can use plp=
gsql debugger.</div><div><br></div><div>Maybe you use more extensions that =
use plpgsql debug API in one moment - plprofiler, or plpgsql_check. This is=
 not supported (plpgsql_check is exception, but it should be loaded last).<=
/div><div><br></div><div>Regards</div><div><br></div><div>Pavel<br></div><d=
iv><br></div><div>=C2=A0<br></div><blockquote class=3D"gmail_quote" style=
=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding=
-left:1ex"><div dir=3D"ltr"><div><br></div><div>Thanks for reading,</div><d=
iv><br></div><div>James</div></div>
</blockquote></div></div>

--000000000000077643061f2f8845--