Re: Copy query from a query tab

From: Dave Page <dpage(at)pgadmin(dot)org>
To: Cyril Jouve <jv(dot)cyril(at)gmail(dot)com>
Cc: pgAdmin Support <pgadmin-support(at)postgresql(dot)org>
Subject: Re: Copy query from a query tab
Date: 2017-03-28 02:03:51
Message-ID: CA+OCxowgAU+sQ6--CgODbODiNmmsG_23D41K7RURmLWJMWPzVA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi

On Mon, Mar 27, 2017 at 11:40 AM, Cyril Jouve <jv(dot)cyril(at)gmail(dot)com> wrote:

> Hello,
>
> I'm using pgadmin4 4.3 (ran in a docker container) and I'm browsing it
> using Chromium 56.
>
> If I generate a query in the browser tab (right click > view data > view
> first 100 rows), then a new tab is opened, named Query-X, with the query
> (in the red square) at the top and the result table at the bottom:
> [image: Screenshot_20170327_172110.png]
>
> The query can't be edited and it can't even be copied : ctrl-c is not
> working and the copy option of the contextual menu (right-click on
> selection > copy) is disabled .
>
> Is there some rationale to block the edit functionality and the copy
> functionality or is this a bug ?
>
> Note that edit/copy works fine when creating a query with the top menu
> option (Tools > "query tool").
>
>
Read-only is expected - in View/Edit data mode we cannot allow arbitrary
modifications to the SQL query as we have no straightforward way of knowing
if a given query will result in data that can be updated.

I would like to change this in the long term (and we intend to), but it's a
significant amount of work.

As for the inability copy, that's a bug - please log it at
https://redmine.postgresql.org/projects/pgadmin4/issues/new. I took a quick
look, but removing the normal classes we use to prevent copying of parts of
the UI that really shouldn't be copied didn't help.

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message matshyeq 2017-03-28 08:30:47 Accessing PgAdmin UI (v4.1.3) through web browser
Previous Message Shirley Wang 2017-03-27 17:50:03 Re: Feedback on pgAdmin 'Create Server' workflow