Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rzFbt-002jsJ-Q0 for pgadmin-hackers@arkaria.postgresql.org; Tue, 23 Apr 2024 12:50:57 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rzFbs-008SRA-H8 for pgadmin-hackers@arkaria.postgresql.org; Tue, 23 Apr 2024 12:50:56 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rzFbs-008SR1-8W for pgadmin-hackers@lists.postgresql.org; Tue, 23 Apr 2024 12:50:56 +0000 Received: from mail-lf1-x12f.google.com ([2a00:1450:4864:20::12f]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rzFbo-002WOM-Ur for pgadmin-hackers@postgresql.org; Tue, 23 Apr 2024 12:50:55 +0000 Received: by mail-lf1-x12f.google.com with SMTP id 2adb3069b0e04-518a3e0d2ecso8430375e87.3 for ; Tue, 23 Apr 2024 05:50:52 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=pgadmin.org; s=google; t=1713876650; x=1714481450; darn=postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=ScHa/dVA/ytqp8y4ZsfgbnSt+uzryPMD01GiCsuStGM=; b=J1gcBbLljIdkT6oAC6fhtzpsBgccxsa/dDQI5YF4MjO/boHwkKoEy2xZPiBUR4YCK5 7S+LnzaedvXJw46X9EmPc3fXwGjLJmIZcBjz1DrEEQV+WeHwGFl+63ulwxpNzADhqyzT 3pdhAuxf3LVext4Kgrlgd01IHGRpj03u8qefcnFfgyUTPrM7jKL77Y6+UWLsqJkTLUR/ AkEYeJhSu/4GWJOM+7HKuSyRuCbMoQ9tOi41xw3tPXsKXDhcT6bsBX4xwuDZJbwlASVU 4IcIsL524qqdluy2tS9sAxurFYKQ69MRopuQEWGy2ujfoPeBgshzpl0RPCcg7EQiPSDg v7kw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1713876650; x=1714481450; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=ScHa/dVA/ytqp8y4ZsfgbnSt+uzryPMD01GiCsuStGM=; b=wahc0PmuigeQ8P7ltuqGZ3Uj7qY9hLzbbbmphuE23ogf8fBLIFhPaiwix0G54hJ/y3 d0RnY4g9oyyQyyi1TfTGTH0X3iW7PXV369MAj/mqvGZMy7dHki10/uR9erFT29fI9eGJ 2wKcqwpDCIZWZyJ6pRogQVIgYBSEH6UiRCgWG+yALlt9xYYkDKA3ZzyQCN+eEdvIccFl 4XbaWbw+Z2E/GSknksK+n5ag5fW+i33cNkKzgztf6iaI94q8Ekfem/xKtmQKPR54Fh+T qX7TriSrd4CBUhJOU6W87wJro0OYZvqL7CTUJQObhE1EbgaqU+uolSYm5M35OOqmssIQ vVJQ== X-Forwarded-Encrypted: i=1; AJvYcCUF8e06u5UjT9HMz3V0l+Y1+UkuS53U3PcEURAfdcuviDHmQAFgb3ZDHkoRUcl7d2WREFQZdsDEX5YzX5wa6DlrTViuPpWrUqsTy0F+hpo= X-Gm-Message-State: AOJu0Yw/dzLC01wTikfpQ8fGJ4tOVZS+wN/pvjX11HUCI/IMJG/Js1GP bd/VWhRfauEAeaXMw/e683p1PTkj8rH2QYZjuuCxFTGEMMoC6QyOngujxTqOPLuXZKdpTHfFi6/ IKk3TicJVPsrGXVm4ouksn/unMBO6R6P+JMgk X-Google-Smtp-Source: AGHT+IG3Ryrs/jQBixSVbE19Dl76he+nWeU8GH7IRoC2z3cqE1TZA1zf0A9jPjW6cHjGv6jkk9afMNJFCkgpPcCcLi0= X-Received: by 2002:a05:6512:1242:b0:51b:3493:81eb with SMTP id fb2-20020a056512124200b0051b349381ebmr5862448lfb.24.1713876650209; Tue, 23 Apr 2024 05:50:50 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Dave Page Date: Tue, 23 Apr 2024 13:50:37 +0100 Message-ID: Subject: Re: Regarding feature #6841 To: Thom Brown Cc: Aditya Toshniwal , Anil Sahoo , pgadmin-hackers Content-Type: multipart/alternative; boundary="000000000000ecd3220616c3007d" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000ecd3220616c3007d Content-Type: text/plain; charset="UTF-8" On Tue, 23 Apr 2024 at 12:03, Thom Brown wrote: > >> You've been able to do the "Select and run" thing for years. If you >> select text in the editor and hit the execute button, only the selected >> text is sent to the server. If nothing is selected, the entire string is >> sent. This feature will complement that for convenience, but for safety >> will have a separate button/shortcut. >> > > Oh, I clearly don't use PgAdmin enough to know this already. > Boo! > > I still find the proposal somewhat unintuitive, but the foot-gun > safeguards that have been suggested sound like any pedal injuries will > solely be the fault of the user. > > I would want to see it tested in a diverse range of scenarios though, > which will require some imagination given what users will no doubt try to > use it on. > Yes, I have made that very clear to the team. Suggestions for test scenarios are welcome of course - a good way to experiment might be to see how the current version of pgAdmin (which uses the new CodeMirror code) manages to mess up syntax highlighting of anything weird. -- Dave Page pgAdmin: https://www.pgadmin.org PostgreSQL: https://www.postgresql.org EDB: https://www.enterprisedb.com --000000000000ecd3220616c3007d Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable


=
On Tue, 23 Apr 2024 at 12:03, Thom Br= own <thom@linux.com> wrote:
=
You've been able to do the "Select and run" thing= for years. If you select text in the editor and hit the execute button, on= ly the selected text is sent to the server. If nothing is selected, the ent= ire string is sent. This feature will complement that for convenience, but = for safety will have a separate button/shortcut.

Oh, I clearly don&#= 39;t use PgAdmin enough to know this already.
=
Boo!
=C2=A0

I still find the proposal s= omewhat unintuitive, but the foot-gun safeguards that have been suggested s= ound like any pedal injuries will solely be the fault of the user.

I would want to see it tested in= a diverse range of scenarios though, which will require some imagination g= iven what users will no doubt try to use it on.

Yes, I have made that very clear to the team. Suggestions = for test scenarios are welcome of course - a good way to experiment might b= e to see how the current version of pgAdmin (which uses the new CodeMirror = code) manages to mess up syntax highlighting of anything weird.=C2=A0
=

--
<= div dir=3D"ltr" class=3D"gmail_signature"> --000000000000ecd3220616c3007d--