public inbox for [email protected]  

help / color / mirror / Atom feed

From: Pradip Parkale <[email protected]>
To: pgadmin-hackers <[email protected]>
Subject: [pgAdmin][RM6981]: SQL for index shows same column multiple times
Date: Mon, 15 Nov 2021 15:29:25 +0530
Message-ID: <CAJ9T6SsCuzEO09SW6GuJr3AssrZXqkFHRAnZ4YfUKB7CvOug_Q@mail.gmail.com> (raw)

Hi Akshay,

Please find the attached patch for #6981 SQL for index shows same column
multiple times.

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


Attachments:

  [application/octet-stream] RM6981.patch (894B, 3-RM6981.patch)
  download | inline diff:
diff --git a/web/pgadmin/browser/server_groups/servers/databases/schemas/tables/indexes/utils.py b/web/pgadmin/browser/server_groups/servers/databases/schemas/tables/indexes/utils.py
index 09ef2f9dc..cd8679d3d 100644
--- a/web/pgadmin/browser/server_groups/servers/databases/schemas/tables/indexes/utils.py
+++ b/web/pgadmin/browser/server_groups/servers/databases/schemas/tables/indexes/utils.py
@@ -99,6 +99,9 @@ def get_column_details(conn, idx, data, mode='properties', template_path=None):
         "/".join([template_path, 'column_details.sql']), idx=idx
     )
     status, rset = conn.execute_2darray(SQL)
+    # Remove column if duplicate column is present in list.
+    rset['rows'] = [i for n, i in enumerate(rset['rows']) if
+                    i not in rset['rows'][n + 1:]]
     if not status:
         return internal_server_error(errormsg=rset)
 
* Unmerged path web/yarn.lock

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][RM6981]: SQL for index shows same column multiple times
  In-Reply-To: <CAJ9T6SsCuzEO09SW6GuJr3AssrZXqkFHRAnZ4YfUKB7CvOug_Q@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