public inbox for [email protected]  

help / color / mirror / Atom feed

From: Pradip Parkale <[email protected]>
To: pgadmin-hackers <[email protected]>
Subject: [pgAdmin][RM6986]: Can't debug function with timestamp parameter
Date: Wed, 17 Nov 2021 12:36:53 +0530
Message-ID: <CAJ9T6StsDRNjxCOp6j75QYKgfhM-gxpnL3qP4fgVL0P1dPt3SQ@mail.gmail.com> (raw)

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'] %}

view thread (2+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected]
  Subject: Re: [pgAdmin][RM6986]: Can't debug function with timestamp parameter
  In-Reply-To: <CAJ9T6StsDRNjxCOp6j75QYKgfhM-gxpnL3qP4fgVL0P1dPt3SQ@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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