Extra brackets when viewing SQL.

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Extra brackets when viewing SQL.

Joe Tailleur-2

Joe Tailleur <[hidden email]>

8:47 AM (2 hours ago)
to pgadmin-support
Hi all,

In version 4.27 when I viewed my SQL (sql tab when highlighting an item).

For example: 
CREATE OR REPLACE VIEW asap.view_assignment
 AS
 SELECT pa.assign_id,
    pa.proj_id,
    pa.date_assigned,
    pa.time_assigned,
    au.user_name AS assigned_to,
    pa.assigned_level,
    pa.note,
    eb.user_name AS assigned_by
   FROM proj_assign pa
     JOIN asap_users au ON au.user_uid = pa.assigned_to_user
     LEFT JOIN asap_users eb ON eb.user_uid = pa.assigned_by_user;


In version 4.28 (and 4.29)
CREATE OR REPLACE VIEW asap.view_assignment
 AS
 SELECT pa.assign_id,
    pa.proj_id,
    pa.date_assigned,
    pa.time_assigned,
    au.user_name AS assigned_to,
    pa.assigned_level,
    pa.note,
    eb.user_name AS assigned_by
   FROM ((proj_assign pa
     JOIN asap_users au ON ((au.user_uid = pa.assigned_to_user)))
     LEFT JOIN asap_users eb ON ((eb.user_uid = pa.assigned_by_user)));

I really don't like the extra brackets that are being placed around the FROM and JOINs, and they show up as well in CASE statements within SELECT and other sections as well.  It gets really difficult when a complex statement might involve 10 joins; and brackets are all over the place.  They are making my more complex queries difficult to read when I look at them in the SQL tab.

Can I somehow disable this?  It's a real pain in the butt. It was similar a few versions ago; and then was corrected; but now it's back.  
 

Joe.
Reply | Threaded
Open this post in threaded view
|

Re: Extra brackets when viewing SQL.

Khushboo Vashi
Hi,

This issue is already logged. Please refer: https://redmine.postgresql.org/issues/6061

Thanks,
Khushboo

On Thu, Dec 10, 2020 at 11:54 PM Joe Tailleur <[hidden email]> wrote:

Joe Tailleur <[hidden email]>

8:47 AM (2 hours ago)
to pgadmin-support
Hi all,

In version 4.27 when I viewed my SQL (sql tab when highlighting an item).

For example: 
CREATE OR REPLACE VIEW asap.view_assignment
 AS
 SELECT pa.assign_id,
    pa.proj_id,
    pa.date_assigned,
    pa.time_assigned,
    au.user_name AS assigned_to,
    pa.assigned_level,
    pa.note,
    eb.user_name AS assigned_by
   FROM proj_assign pa
     JOIN asap_users au ON au.user_uid = pa.assigned_to_user
     LEFT JOIN asap_users eb ON eb.user_uid = pa.assigned_by_user;


In version 4.28 (and 4.29)
CREATE OR REPLACE VIEW asap.view_assignment
 AS
 SELECT pa.assign_id,
    pa.proj_id,
    pa.date_assigned,
    pa.time_assigned,
    au.user_name AS assigned_to,
    pa.assigned_level,
    pa.note,
    eb.user_name AS assigned_by
   FROM ((proj_assign pa
     JOIN asap_users au ON ((au.user_uid = pa.assigned_to_user)))
     LEFT JOIN asap_users eb ON ((eb.user_uid = pa.assigned_by_user)));

I really don't like the extra brackets that are being placed around the FROM and JOINs, and they show up as well in CASE statements within SELECT and other sections as well.  It gets really difficult when a complex statement might involve 10 joins; and brackets are all over the place.  They are making my more complex queries difficult to read when I look at them in the SQL tab.

Can I somehow disable this?  It's a real pain in the butt. It was similar a few versions ago; and then was corrected; but now it's back.  
 

Joe.