public inbox for [email protected]  

help / color / mirror / Atom feed

[pgAdmin][RESQL]: Fix for schema RESQL test cases.
2+ messages / 2 participants
[nested] [flat]

* [pgAdmin][RESQL]: Fix for schema RESQL test cases.
@ 2020-12-31 06:44 Nikhil Mohite <[email protected]>
  2020-12-31 08:25 ` Re: [pgAdmin][RESQL]: Fix for schema RESQL test cases. Akshay Joshi <[email protected]>
  0 siblings, 1 reply; 2+ messages in thread

From: Nikhil Mohite @ 2020-12-31 06:44 UTC (permalink / raw)
  To: pgadmin-hackers

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,


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

* Re: [pgAdmin][RESQL]: Fix for schema RESQL test cases.
  2020-12-31 06:44 [pgAdmin][RESQL]: Fix for schema RESQL test cases. Nikhil Mohite <[email protected]>
@ 2020-12-31 08:25 ` Akshay Joshi <[email protected]>
  0 siblings, 0 replies; 2+ messages in thread

From: Akshay Joshi @ 2020-12-31 08:25 UTC (permalink / raw)
  To: Nikhil Mohite <[email protected]>; +Cc: pgadmin-hackers

Thanks, patch applied.

On Thu, Dec 31, 2020 at 12:14 PM Nikhil Mohite <
[email protected]> wrote:

> 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.*
>


-- 
*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:[~2020-12-31 08:25 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-12-31 06:44 [pgAdmin][RESQL]: Fix for schema RESQL test cases. Nikhil Mohite <[email protected]>
2020-12-31 08:25 ` 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