Обсуждение: Enhancement Request - Query Tool - Run non-contiguous highlighted code

Поиск
Список
Период
Сортировка

Enhancement Request - Query Tool - Run non-contiguous highlighted code

От
Christopher Maurer
Дата:
PGADMIN4's Query Tool will run only the highlighted SQL when a section of the SQL window is highlighted.  In the Windows operating system, this same window allows the highlighting of non-contiguous areas using ctrl-click&drag on the mouse, but executing such multi-region highlighted code fails because only the bottom-most highlighted region is executed.

Note that this could be VERY useful when you have coded a CTE (common table expression), as this code is at the top of the SQL and its utilization may occur significantly below its definition.

Re: Enhancement Request - Query Tool - Run non-contiguous highlighted code

От
Aditya Toshniwal
Дата:
Hi Christopher,

Can you please report this here - https://github.com/pgadmin-org/pgadmin4/issues/new? Additionally, please also add some screenshots or screen recording to help us understand the issue better.

On Sun, Mar 17, 2024 at 10:12 PM Christopher Maurer <chrismaurer52@gmail.com> wrote:
PGADMIN4's Query Tool will run only the highlighted SQL when a section of the SQL window is highlighted.  In the Windows operating system, this same window allows the highlighting of non-contiguous areas using ctrl-click&drag on the mouse, but executing such multi-region highlighted code fails because only the bottom-most highlighted region is executed.

Note that this could be VERY useful when you have coded a CTE (common table expression), as this code is at the top of the SQL and its utilization may occur significantly below its definition.


--
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Sr. Software Architect | enterprisedb.com
"Don't Complain about Heat, Plant a TREE"