public inbox for [email protected]  

help / color / mirror / Atom feed

[pgAdmin][RM6986]: Can't debug function with timestamp parameter
2+ messages / 2 participants
[nested] [flat]

* [pgAdmin][RM6986]: Can't debug function with timestamp parameter
@ 2021-11-17 07:06  Pradip Parkale <[email protected]>
  0 siblings, 1 reply; 2+ messages in thread

From: Pradip Parkale @ 2021-11-17 07:06 UTC (permalink / raw)
  To: pgadmin-hackers

Hi Hackers,

Please find the attached patch for #6986 Can't debug function with
timestamp parameter.

-- 
Thanks & Regards,
Pradip Parkale
Software Engineer | EnterpriseDB Corporation


Attachments:

  [application/octet-stream] RM6986.patch (996B, 3-RM6986.patch)
  download | inline diff:
diff --git a/web/pgadmin/tools/debugger/templates/debugger/sql/execute_plpgsql.sql b/web/pgadmin/tools/debugger/templates/debugger/sql/execute_plpgsql.sql
index 2295f9446..6e90ef83d 100644
--- a/web/pgadmin/tools/debugger/templates/debugger/sql/execute_plpgsql.sql
+++ b/web/pgadmin/tools/debugger/templates/debugger/sql/execute_plpgsql.sql
@@ -11,9 +11,9 @@
 {% if data %}
 {% for dict_item in data %}
 {% if 'type' in dict_item and 'value' in dict_item %}
-{% if dict_item['value'] != 'NULL' and '[]' not in dict_item['type'] %}
+{% if ('NULL:' not in dict_item['value']|string and dict_item['value'] != 'NULL' and '[]' not in dict_item['type']) %}
 {{ dict_item['value']|qtLiteral }}::{{ dict_item['type'] }}{% if not loop.last %}, {% endif %}
-{% elif dict_item['value'] == 'NULL' %}
+{% elif dict_item['value'] == 'NULL' or 'NULL:' in dict_item['value'] %}
 {{ dict_item['value'] }}::{{ dict_item['type'] }}{% if not loop.last %}, {% endif %}
 {% else %}
 {% if '[]' in dict_item['type'] %}


^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: [pgAdmin][RM6986]: Can't debug function with timestamp parameter
@ 2021-11-18 07:07  Akshay Joshi <[email protected]>
  parent: Pradip Parkale <[email protected]>
  0 siblings, 0 replies; 2+ messages in thread

From: Akshay Joshi @ 2021-11-18 07:07 UTC (permalink / raw)
  To: Pradip Parkale <[email protected]>; +Cc: pgadmin-hackers

Thanks, the patch applied.

On Wed, Nov 17, 2021 at 12:37 PM Pradip Parkale <
[email protected]> wrote:

> Hi Hackers,
>
> Please find the attached patch for #6986 Can't debug function with
> timestamp parameter.
>
> --
> Thanks & Regards,
> Pradip Parkale
> Software Engineer | EnterpriseDB Corporation
>


-- 
*Thanks & Regards*
*Akshay Joshi*
*pgAdmin Hacker | Principal Software Architect*
*EDB Postgres <http://edbpostgres.com>*

*Mobile: +91 976-788-8246*


^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2021-11-18 07:07 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-11-17 07:06 [pgAdmin][RM6986]: Can't debug function with timestamp parameter Pradip Parkale <[email protected]>
2021-11-18 07:07 ` Akshay Joshi <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox