Re: Extra Paranthesis on joins on saving a view

From: Aditya Toshniwal <aditya(dot)toshniwal(at)enterprisedb(dot)com>
To: Alex Williams <valenceshell(at)protonmail(dot)com>
Cc: Pgadmin Support <pgadmin-support(at)lists(dot)postgresql(dot)org>
Subject: Re: Extra Paranthesis on joins on saving a view
Date: 2020-12-03 05:50:18
Message-ID: CAM9w-_kfpphzQgMnKyxCzxcZLQf+sHNHoMDVCkrTVy3aZCwVcA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi Alex,

On Thu, Dec 3, 2020 at 7:14 AM Alex Williams <valenceshell(at)protonmail(dot)com>
wrote:

> Hi,
>
> I'm not sure if this is something new but in previous versions of pgadmin
> (currently using 4.27 where this is happening,) when creating a view, more
> or less, my original sql was maintained, but now it's mangling the joins
> like MS Access does with the Jet database with lots of parenthesis's (yes,
> I still use Access 2000.) Is there a way to disable this? I find it very
> difficult to parse and wind up removing them all only to have come back
> when saved when I'm done modifying / saving the view.
>
Can you please log the request here -
https://redmine.postgresql.org/projects/pgadmin4/issues/new with sample DDL
so we can work on it ?

>
> Also, can you:
> 1. Allow renaming tables/functions/etc... without having to invoke
> properties....it's very slow sometimes to bring up that dialog....and
> sometimes I use rename just to copy a object name, not to rename it.
>
You can drag the object directly to query tool, it will copy the object
name and paste it.

>
> 2. When running View/Edit->First 100 Rows, can you not lock it, i.e., it's
> a convenient way to have the select statement written without typing and
> then you add the predicates/joins.
>
Yes there is a similar request logged, and will be considered for a future
release.

>
> 3. When creating a table, can you please allow rearranging of the columns.
>
Rearranging columns is not traditionally supported by PostgreSQL. One needs
to create a new table with new column order, copy the data to the new
table, drop the old table and rename the new one. pgAdmin does not want to
go in this complexity as it is prone to error and might cause user data
loss. Unfortunately, this request cannot be completed as of now.

>
> Thanks,
>
> Alex
>
>
>
>

--
Thanks,
Aditya Toshniwal
pgAdmin hacker | Sr. Software Engineer | *edbpostgres.com*
<http://edbpostgres.com>
"Don't Complain about Heat, Plant a TREE"

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message richard coleman 2020-12-03 13:54:59 Re: Extra Paranthesis on joins on saving a view
Previous Message Alex Williams 2020-12-03 01:44:02 Re: Extra Paranthesis on joins on saving a view