Horton

Re: proposal: enhancing plpgsql debug API - returns text value of variable content

Pavel Stehule <pavel.stehule@gmail.com>

View thread View on postgr.es
From: Pavel Stehule <pavel.stehule@gmail.com>
To: Aleksander Alekseev <aleksander@timescale.com>
Cc: PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2021-07-16T16:40:38Z
Lists: pgsql-hackers 
Hi

pá 16. 7. 2021 v 15:05 odesílatel Aleksander Alekseev <
aleksander@timescale.com> napsal:

> Hi Pavel,
>
> > I would like to print content of variables - and now, I have to go some
> > deeper than I would like. I need to separate between scalar, row, and
> > record variables. PLpgSQL has code for it - but it is private.
> > [...]
>
> The patch seems OK, but I wonder - would it be possible to write a test on
> it?
>

 Sure, it is possible - unfortunately - the size of this test will be
significantly bigger than patch self.

I'll try to write it some simply tracer, where this API can be used



> --
> Best regards,
> Aleksander Alekseev
>

Commits

  1. Expose a few more PL/pgSQL functions to debugger plugins.