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

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Aleksander Alekseev <aleksander(at)timescale(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: proposal: enhancing plpgsql debug API - returns text value of variable content
Date: 2021-07-22 04:12:57
Message-ID: CAFj8pRAKsrJ__BR_zXdCvPZy86nodn_aNFDdpQBJmgLjjs=nAQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

st 21. 7. 2021 v 22:23 odesílatel Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
napsal:

> Hi
>
> pá 16. 7. 2021 v 18:40 odesílatel Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
> napsal:
>
>> Hi
>>
>> pá 16. 7. 2021 v 15:05 odesílatel Aleksander Alekseev <
>> aleksander(at)timescale(dot)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
>>
>
> I am sending an enhanced patch about the regress test for plpgsql's debug
> API.
>

with modified Makefile to force use option
-I$(top_srcdir)/src/pl/plpgsql/src

override CPPFLAGS := $(CPPFLAGS) -I$(top_srcdir)/src/pl/plpgsql/src

> Regards
>
> Pavel
>
>
>>
>>
>>> --
>>> Best regards,
>>> Aleksander Alekseev
>>>
>>

Attachment Content-Type Size
enhancing-plpgsql-dbgapi-20210722.patch text/x-patch 39.0 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message vignesh C 2021-07-22 05:07:12 Re: alter table set TABLE ACCESS METHOD
Previous Message Greg Nancarrow 2021-07-22 04:07:47 Re: Added schema level support for publication.