public inbox for [email protected]  

help / color / mirror / Atom feed

From: Nikhil Mohite <[email protected]>
To: pgadmin-hackers <[email protected]>
Subject: [pgAdmin][RM-6121]: Unable to see database list in connection window launched from change connection option in query tool
Date: Thu, 7 Jan 2021 17:04:43 +0530
Message-ID: <CAOBg0APQimCHW_reNYF1MHBL4i2v9ScjK59a3L5KyY3=mZXt1w@mail.gmail.com> (raw)

Hi Team,

Please find the attached patch for RM-6121
<https://redmine.postgresql.org/issues/6121;: Unable to see database list
in connection window launched from change connection option in query tool.

-- 
*Thanks & Regards,*
*Nikhil Mohite*
*Software Engineer.*
*EDB Postgres* <https://www.enterprisedb.com/;
*Mob.No: +91-7798364578.*


Attachments:

  [application/octet-stream] RM_6121.patch (677B, 3-RM_6121.patch)
  download | inline diff:
diff --git a/web/pgadmin/browser/server_groups/servers/databases/templates/databases/sql/default/nodes.sql b/web/pgadmin/browser/server_groups/servers/databases/templates/databases/sql/default/nodes.sql
index 7dd63ff7..de93b3d4 100644
--- a/web/pgadmin/browser/server_groups/servers/databases/templates/databases/sql/default/nodes.sql
+++ b/web/pgadmin/browser/server_groups/servers/databases/templates/databases/sql/default/nodes.sql
@@ -14,6 +14,10 @@ AND
 db.datname in ({{db_restrictions}})
 {% endif %}
 
+{% if show_system_objects %}
 AND db.datistemplate in (false, {{show_system_objects}})
+{% else %}
+AND db.datistemplate in (false)
+{% endif %}
 
 ORDER BY datname;

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][RM-6121]: Unable to see database list in connection window launched from change connection option in query tool
  In-Reply-To: <CAOBg0APQimCHW_reNYF1MHBL4i2v9ScjK59a3L5KyY3=mZXt1w@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