public inbox for [email protected]  

help / color / mirror / Atom feed

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

* [pgAdmin][RESQL]: Fix for column RESQL test cases.
@ 2020-12-29 08:52  Nikhil Mohite <[email protected]>
  0 siblings, 1 reply; 2+ messages in thread

From: Nikhil Mohite @ 2020-12-29 08:52 UTC (permalink / raw)
  To: pgadmin-hackers

Hi Team,

Please find the attached patch to fix the RESQL test case for the column.



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


Attachments:

  [application/octet-stream] RESQL_fix_for_column_acl.patch (933B, 3-RESQL_fix_for_column_acl.patch)
  download | inline diff:
diff --git a/web/pgadmin/browser/server_groups/servers/databases/schemas/tables/templates/columns/sql/9.1_plus/acl.sql b/web/pgadmin/browser/server_groups/servers/databases/schemas/tables/templates/columns/sql/9.1_plus/acl.sql
index 152a784..19a65a6 100644
--- a/web/pgadmin/browser/server_groups/servers/databases/schemas/tables/templates/columns/sql/9.1_plus/acl.sql
+++ b/web/pgadmin/browser/server_groups/servers/databases/schemas/tables/templates/columns/sql/9.1_plus/acl.sql
@@ -1,4 +1,8 @@
-SELECT 'attacl' as deftype, COALESCE(gt.rolname, 'PUBLIC') grantee, g.rolname grantor, array_agg(privilege_type) as privileges, array_agg(is_grantable) as grantable
+SELECT 'attacl' as deftype,
+    COALESCE(gt.rolname, 'PUBLIC') grantee,
+    g.rolname grantor,
+    array_agg(privilege_type order by privilege_type) as privileges,
+    array_agg(is_grantable) as grantable
 FROM
   (SELECT
     d.grantee, d.grantor, d.is_grantable,


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

* Re: [pgAdmin][RESQL]: Fix for column RESQL test cases.
@ 2020-12-30 06:55  Akshay Joshi <[email protected]>
  parent: Nikhil Mohite <[email protected]>
  0 siblings, 0 replies; 2+ messages in thread

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

Thanks, patch applied.

On Tue, Dec 29, 2020 at 2:22 PM Nikhil Mohite <
[email protected]> wrote:

> Hi Team,
>
> Please find the attached patch to fix the RESQL test case for the column.
>
>
>
> --
> *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-30 06:55 UTC | newest]

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