public inbox for [email protected]  

help / color / mirror / Atom feed

From: Nikhil Mohite <[email protected]>
To: pgadmin-hackers <[email protected]>
Subject: [pgAdmin][RESQL]: Fix for schema RESQL test cases.
Date: Thu, 31 Dec 2020 12:14:10 +0530
Message-ID: <CAOBg0AMaLHo4uv7V5Jnw-v7DN0Kx9r31iRHQYzq8nniap5-QpA@mail.gmail.com> (raw)

Hi Team,

Please find the attached patch to fix the RESQL test cases for the schema.


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


Attachments:

  [application/octet-stream] RESQL_fix_for_schema.patch (1.0K, 3-RESQL_fix_for_schema.patch)
  download | inline diff:
diff --git a/web/pgadmin/browser/server_groups/servers/databases/schemas/templates/schemas/ppas/9.2_plus/sql/defacl.sql b/web/pgadmin/browser/server_groups/servers/databases/schemas/templates/schemas/ppas/9.2_plus/sql/defacl.sql
index 91c3085..6dabab0 100644
--- a/web/pgadmin/browser/server_groups/servers/databases/schemas/templates/schemas/ppas/9.2_plus/sql/defacl.sql
+++ b/web/pgadmin/browser/server_groups/servers/databases/schemas/templates/schemas/ppas/9.2_plus/sql/defacl.sql
@@ -6,7 +6,10 @@ SELECT
     WHEN 'T' THEN 'deftypeacl'
     ELSE 'UNKNOWN - ' || a.deftype
     END AS deftype,
-    COALESCE(gt.rolname, 'PUBLIC') grantee, g.rolname grantor, array_agg(a.privilege_type) as privileges, array_agg(a.is_grantable) as grantable
+    COALESCE(gt.rolname, 'PUBLIC') grantee,
+    g.rolname grantor,
+    array_agg(a.privilege_type order by a.privilege_type) as privileges,
+    array_agg(a.is_grantable) as grantable
 FROM
     (SELECT
         (acl).grantee as grantee, (acl).grantor AS grantor, (acl).is_grantable AS is_grantable,

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][RESQL]: Fix for schema RESQL test cases.
  In-Reply-To: <CAOBg0AMaLHo4uv7V5Jnw-v7DN0Kx9r31iRHQYzq8nniap5-QpA@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