From unknown Thu Sep 18 21:17:03 2025 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-Mailer: MIME-tools 5.509 (Entity 5.509) Content-Type: text/plain; charset=utf-8 From: bug#47358 <47358@debbugs.gnu.org> To: bug#47358 <47358@debbugs.gnu.org> Subject: Status: 28.0.50; sql-list-tables: quotes are cumbersome, no need for it; include history Reply-To: bug#47358 <47358@debbugs.gnu.org> Date: Fri, 19 Sep 2025 04:17:03 +0000 retitle 47358 28.0.50; sql-list-tables: quotes are cumbersome, no need for = it; include history reassign 47358 emacs submitter 47358 Jean Louis severity 47358 wishlist thanks From debbugs-submit-bounces@debbugs.gnu.org Wed Mar 24 04:03:55 2021 Received: (at submit) by debbugs.gnu.org; 24 Mar 2021 08:03:55 +0000 Received: from localhost ([127.0.0.1]:33854 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1lOyUd-0005g5-0v for submit@debbugs.gnu.org; Wed, 24 Mar 2021 04:03:55 -0400 Received: from lists.gnu.org ([209.51.188.17]:55728) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1lOyUZ-0005fw-2x for submit@debbugs.gnu.org; Wed, 24 Mar 2021 04:03:53 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:56652) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1lOyUY-00067B-TI for bug-gnu-emacs@gnu.org; Wed, 24 Mar 2021 04:03:50 -0400 Received: from stw1.rcdrun.com ([217.170.207.13]:49365) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1lOyUX-00072U-0N for bug-gnu-emacs@gnu.org; Wed, 24 Mar 2021 04:03:50 -0400 Received: from localhost ([::ffff:41.202.241.53]) (AUTH: PLAIN securesender, TLS: TLS1.3,256bits,ECDHE_RSA_AES_256_GCM_SHA384) by stw1.rcdrun.com with ESMTPSA id 000000000001E0AB.00000000605AF261.00003F25; Wed, 24 Mar 2021 01:03:44 -0700 From: Jean Louis To: bug-gnu-emacs@gnu.org Subject: 28.0.50; sql-list-tables: quotes are cumbersome, no need for it; include history Date: Wed, 24 Mar 2021 11:01:46 +0300 Message-ID: <864kh1nfo5.fsf@protected.rcdrun.com> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Received-SPF: pass client-ip=217.170.207.13; envelope-from=admin@protected.rcdrun.com; helo=stw1.rcdrun.com X-Spam_score_int: -16 X-Spam_score: -1.7 X-Spam_bar: - X-Spam_report: (-1.7 / 5.0 requ) BAYES_00=-1.9, HEADER_FROM_DIFFERENT_DOMAINS=0.249, SPF_HELO_PASS=-0.001, SPF_PASS=-0.001 autolearn=no autolearn_force=no X-Spam_action: no action X-Spam-Score: -1.1 (-) X-Debbugs-Envelope-To: submit X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -2.1 (--) When executing C-c C-l t in sql-interactive-mode then tables are completed with quotes like "activities" instead of just activities. It would be good not to use quotes, it is more usable that way. Internally the table could require quotes to be called, but for user to complete a string or name of table should not be necessary. Additionally I propose to include history for the function sql-list-tables as calling tables' definitions may be frequent with some users, and other mini buffer entries are not relevant to it. In GNU Emacs 28.0.50 (build 2, x86_64-pc-linux-gnu, X toolkit, cairo versio= n 1.17.4, Xaw scroll bars) of 2021-03-22 built on protected.rcdrun.com Repository revision: cb5d1fe1aa9f280d60fcb33b58fc83ace3d95081 Repository branch: master Windowing system distributor 'The X.Org Foundation', version 11.0.12010000 Configured using: 'configure --with-x-toolkit=3Dlucid' Configured features: ACL CAIRO DBUS FREETYPE GIF GLIB GMP GNUTLS GPM GSETTINGS HARFBUZZ JPEG JSON LCMS2 LIBOTF LIBSYSTEMD LIBXML2 M17N_FLT MODULES NOTIFY INOTIFY PDUMPER PNG RSVG SOUND THREADS TIFF TOOLKIT_SCROLL_BARS X11 XDBE XIM XPM LUCID ZLIB Important settings: value of $LC_ALL: en_US.UTF-8 value of $LANG: de_DE.UTF-8 value of $XMODIFIERS: @im=3Dexwm-xim locale-coding-system: utf-8-unix Major mode: Lisp Interaction Minor modes in effect: tooltip-mode: t global-eldoc-mode: t eldoc-mode: t electric-indent-mode: t mouse-wheel-mode: t tool-bar-mode: t menu-bar-mode: t file-name-shadow-mode: t global-font-lock-mode: t font-lock-mode: t blink-cursor-mode: t auto-composition-mode: t auto-encryption-mode: t auto-compression-mode: t line-number-mode: t transient-mark-mode: t Load-path shadows: None found. Features: (qp sql view thingatpt comint ansi-color ring help-mode pp shadow sort mail-extr emacsbug message rmc puny dired dired-loaddefs rfc822 mml mml-sec epa derived epg epg-config gnus-util rmail rmail-loaddefs auth-source cl-seq eieio eieio-core cl-macs eieio-loaddefs password-cache json map text-property-search time-date subr-x seq byte-opt gv bytecomp byte-compile cconv mm-decode mm-bodies mm-encode mail-parse rfc2231 mailabbrev gmm-utils mailheader cl-loaddefs cl-lib sendmail rfc2047 rfc2045 ietf-drums mm-util mail-prsvr mail-utils iso-transl tooltip eldoc electric uniquify ediff-hook vc-hooks lisp-float-type mwheel term/x-win x-win term/common-win x-dnd tool-bar dnd fontset image regexp-opt fringe tabulated-list replace newcomment text-mode elisp-mode lisp-mode prog-mode register page tab-bar menu-bar rfn-eshadow isearch easymenu timer select scroll-bar mouse jit-lock font-lock syntax font-core term/tty-colors frame minibuffer cl-generic cham georgian utf-8-lang misc-lang vietnamese tibetan thai tai-viet lao korean japanese eucjp-ms cp51932 hebrew greek romanian slovak czech european ethiopic indian cyrillic chinese composite charscript charprop case-table epa-hook jka-cmpr-hook help simple abbrev obarray cl-preloaded nadvice button loaddefs faces cus-face macroexp files window text-properties overlay sha1 md5 base64 format env code-pages mule custom widget hashtable-print-readable backquote threads dbusbind inotify lcms2 dynamic-setting system-font-setting font-render-setting cairo x-toolkit x multi-tty make-network-process emacs) Memory information: ((conses 16 84154 15485) (symbols 48 7968 0) (strings 32 24332 1708) (string-bytes 1 815850) (vectors 16 21618) (vector-slots 8 944822 223378) (floats 8 32 62) (intervals 56 5201 26) (buffers 992 17)) --=20 Thanks, Jean Louis =E2=8E=94 =CE=BB =F0=9F=84=AF =F0=9D=8D=84 =F0=9D=8C=A1 =F0=9D=8C=9A From debbugs-submit-bounces@debbugs.gnu.org Thu Oct 21 17:03:21 2021 Received: (at 47358) by debbugs.gnu.org; 21 Oct 2021 21:03:21 +0000 Received: from localhost ([127.0.0.1]:58762 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1mdfDV-0005fN-LB for submit@debbugs.gnu.org; Thu, 21 Oct 2021 17:03:21 -0400 Received: from mail-pf1-f174.google.com ([209.85.210.174]:37874) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1mdfDT-0005fA-PW for 47358@debbugs.gnu.org; Thu, 21 Oct 2021 17:03:12 -0400 Received: by mail-pf1-f174.google.com with SMTP id q19so1764087pfl.4 for <47358@debbugs.gnu.org>; Thu, 21 Oct 2021 14:03:11 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:from:in-reply-to:references:user-agent :mime-version:date:message-id:subject:to:cc; bh=xwTIcxYyDkfX1YeuuuxSYkLUMzGqnFSnmYRS2GACNek=; b=aE9U9gH7jffbu2fw36kI2F9VJg44yPYu2w8GDg6mORRjgVY2q7uGKHzNxxJzltInZp /9V7p9OzqPqB8hFEPNnyCmE3v6Ae7m4SiSfnZpgkE7JEDWX4pmG+o5E8+nkejr/YkEw+ so2F3SIbaPfvLV33tlQwOVWQSUWNgpHTOkXfDlP7lcyiQGuocJkPRFEENp2sMZJlshcN n9dhnwjKa1DczB47FiZMzcRpRCANztVfyJOUNN+uYVP+8h55SG7/FcpKtEfr5CeTYJx1 /4siziDT+rFHWZr5HwXzoZX5iTMA4x745rRfRw0m4W0veyIRP00GKJj1uWQCqNMbMLV0 Iqmg== X-Gm-Message-State: AOAM532L+n5L1dGco1zFzVDX/fO3RjwiQgsNdkgqaMvr85mh7ZpuZf++ Y4LOMUNwSGxDn4dMs+eF2V9ivionfY9pXPETbHY= X-Google-Smtp-Source: ABdhPJwnFJ8sRcdOW61VPft/9Nz3qpt8rFbZHQz9J7YbvFfB94yHmPuUjghYPXRwHkNY5pu2jEndOxSkIu6vZ9qMKX0= X-Received: by 2002:a63:9d06:: with SMTP id i6mr6169841pgd.42.1634850186188; Thu, 21 Oct 2021 14:03:06 -0700 (PDT) Received: from 753933720722 named unknown by gmailapi.google.com with HTTPREST; Thu, 21 Oct 2021 14:03:05 -0700 From: Stefan Kangas In-Reply-To: <864kh1nfo5.fsf@protected.rcdrun.com> (Jean Louis's message of "Wed, 24 Mar 2021 11:01:46 +0300") References: <864kh1nfo5.fsf@protected.rcdrun.com> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/29.0.50 (gnu/linux) MIME-Version: 1.0 Date: Thu, 21 Oct 2021 14:03:05 -0700 Message-ID: Subject: Re: bug#47358: 28.0.50; sql-list-tables: quotes are cumbersome, no need for it; include history To: Jean Louis Content-Type: text/plain; charset="UTF-8" X-Spam-Score: 0.5 (/) X-Debbugs-Envelope-To: 47358 Cc: Michael Mauger , 47358@debbugs.gnu.org X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -0.5 (/) Jean Louis writes: > When executing C-c C-l t in sql-interactive-mode then tables are > completed with quotes like "activities" instead of just activities. > > It would be good not to use quotes, it is more usable that > way. Internally the table could require quotes to be called, but for > user to complete a string or name of table should not be necessary. > > Additionally I propose to include history for the function > sql-list-tables as calling tables' definitions may be frequent with some > users, and other mini buffer entries are not relevant to it. I'm copying in the sql.el maintainer here. Michael, could you please take a look at the above feature request? From debbugs-submit-bounces@debbugs.gnu.org Sun Jun 26 14:38:45 2022 Received: (at 47358) by debbugs.gnu.org; 26 Jun 2022 18:38:45 +0000 Received: from localhost ([127.0.0.1]:49014 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1o5X9h-00048X-Cr for submit@debbugs.gnu.org; Sun, 26 Jun 2022 14:38:45 -0400 Received: from quimby.gnus.org ([95.216.78.240]:57244) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1o5X9e-00048J-QS for 47358@debbugs.gnu.org; Sun, 26 Jun 2022 14:38:43 -0400 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=gnus.org; s=20200322; h=Content-Type:MIME-Version:Message-ID:In-Reply-To:Date: References:Subject:Cc:To:From:Sender:Reply-To:Content-Transfer-Encoding: Content-ID:Content-Description:Resent-Date:Resent-From:Resent-Sender: Resent-To:Resent-Cc:Resent-Message-ID:List-Id:List-Help:List-Unsubscribe: List-Subscribe:List-Post:List-Owner:List-Archive; bh=4sZtHaSOeVZh6S0W2tBj63d4gC+q6u1YV3YV9az2js0=; b=IoTsSQqkFNWvn+lkdnhZAPc2xb wyCyo2eR1L7lyA3dDD4SnOpA4X6Z43FGNg3g5luwMNPIGg1OnaznLVJI/QkkJLMRbxM8/bko6fMbm cYFcYooWqy/FhcqW1OLsuWZ+73wfBC4EGJ0EEtfwH59zceEsgmUl60P3H/DFLYZdHhck=; Received: from [84.212.220.105] (helo=xo) by quimby.gnus.org with esmtpsa (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1o5X9V-0004wq-2o; Sun, 26 Jun 2022 20:38:35 +0200 From: Lars Ingebrigtsen To: Stefan Kangas Subject: Re: bug#47358: 28.0.50; sql-list-tables: quotes are cumbersome, no need for it; include history References: <864kh1nfo5.fsf@protected.rcdrun.com> Date: Sun, 26 Jun 2022 20:38:32 +0200 In-Reply-To: (Stefan Kangas's message of "Thu, 21 Oct 2021 14:03:05 -0700") Message-ID: <87sfnr9snr.fsf@gnus.org> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/29.0.50 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain X-Spam-Report: Spam detection software, running on the system "quimby.gnus.org", has NOT identified this incoming email as spam. The original message has been attached to this so you can view it or label similar future email. If you have any questions, see @@CONTACT_ADDRESS@@ for details. Content preview: Stefan Kangas writes: > Jean Louis writes: > >> When executing C-c C-l t in sql-interactive-mode then tables are >> completed with quotes like "activities" instead of just activities. >> >> It would be g [...] Content analysis details: (-2.9 points, 5.0 required) pts rule name description ---- ---------------------- -------------------------------------------------- -1.0 ALL_TRUSTED Passed through trusted hosts only via SMTP -1.9 BAYES_00 BODY: Bayes spam probability is 0 to 1% [score: 0.0000] X-Spam-Score: -2.3 (--) X-Debbugs-Envelope-To: 47358 Cc: Michael Mauger , 47358@debbugs.gnu.org, Jean Louis X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -3.3 (---) Stefan Kangas writes: > Jean Louis writes: > >> When executing C-c C-l t in sql-interactive-mode then tables are >> completed with quotes like "activities" instead of just activities. >> >> It would be good not to use quotes, it is more usable that >> way. Internally the table could require quotes to be called, but for >> user to complete a string or name of table should not be necessary. >> >> Additionally I propose to include history for the function >> sql-list-tables as calling tables' definitions may be frequent with some >> users, and other mini buffer entries are not relevant to it. > > I'm copying in the sql.el maintainer here. Michael, could you please take a > look at the above feature request? I'm not very familiar with sql.el, but if I read the code correctly, `C-c C-l t' just outputs the data the SQL server spits back at us? So if you're using PostgreSQL, I guess that means that that's how PostgreSQL formats the CREATE TABLE statement. But I may be mistaken -- perhaps Michael has some comments here. -- (domestic pets only, the antidote for overdose, milk.) bloggy blog: http://lars.ingebrigtsen.no From debbugs-submit-bounces@debbugs.gnu.org Mon Jul 04 21:18:21 2022 Received: (at 47358) by debbugs.gnu.org; 5 Jul 2022 01:18:21 +0000 Received: from localhost ([127.0.0.1]:48860 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1o8XCi-0008Fe-HL for submit@debbugs.gnu.org; Mon, 04 Jul 2022 21:18:21 -0400 Received: from mail-40133.protonmail.ch ([185.70.40.133]:28342) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1o8XCf-0008FM-5f for 47358@debbugs.gnu.org; Mon, 04 Jul 2022 21:18:14 -0400 Date: Tue, 05 Jul 2022 01:17:59 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=protonmail.com; s=protonmail3; t=1656983883; x=1657243083; bh=j55dbG7O0EpTiy35LtRUG5os/ap6lrN9dv0Nqyi+eE0=; h=Date:To:From:Cc:Reply-To:Subject:Message-ID:In-Reply-To: References:Feedback-ID:From:To:Cc:Date:Subject:Reply-To: Feedback-ID:Message-ID; b=kjUtCPCC1+bzMsJHIs73A7nN72/mQJMCvSh7AI9uQ3/ZIq4If7MkotMhgnrdcCOJq xRoIrdernPaFQTWmbbnHtKdXTqcXC4craYTA/Gbhn+co6bS/w++Q2EmZy+D3BLrzhb XxbmvWbBqFdo3dknAqqgD0ePbYOvO3CnfJM3GyznxcVD7/oB/0Opj+03A3ImUiebCz wg2AzIClwYL3Vr7gqwCDd8x+GNV8qLrqb9Ee4VxxrOMhJZbp0i5BVjDqm/jUMrjz3j dPpwi+u0MTAcfiUpu5hCNdjePBd2/eJaIHTqjyzAAkY6vDO0K5wazzaY6/dVGL35wU ncD2OL59mTymg== To: Lars Ingebrigtsen From: Michael Mauger Subject: Re: bug#47358: 28.0.50; sql-list-tables: quotes are cumbersome, no need for it; include history Message-ID: In-Reply-To: <87sfnr9snr.fsf@gnus.org> References: <864kh1nfo5.fsf@protected.rcdrun.com> <87sfnr9snr.fsf@gnus.org> Feedback-ID: 119932:user:proton MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-Spam-Score: -0.0 (/) X-Debbugs-Envelope-To: 47358 Cc: Stefan Kangas , 47358@debbugs.gnu.org, Jean Louis X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Reply-To: Michael Mauger Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -1.0 (-) Lars, your analysis was correct--they value is merely inserted into whateve= r command the dialect uses to display the table structure and relies upon t= he underlying command interpreter's rules. I understand the desire to not = make typing of the double quotes required even if they are required in the = underlying command then being consistent with what the underlying parser re= quires is not particularly onerous. The handling of the double quotes becom= es a challenge when the underlying cli does not accept the same table-name = syntax as the "list tables" command requires. I am playing around with completion (and the insertion of enclosing dquotes= when required) in code and in the minibuffer but that'll be a little while= before that is ready. I'll take a look at the smaller bugs first and move = on to this. I do use sql-mode every day (I was a predominantly Oracle user = for many years, but PostgreSQL and a little MS SQL Server and SQLite have b= ecome my current emphasis). -- MICHAEL@MAUGER.COM // FSF and SFConservancy // GNU Emacs sql.el maintainer ------- Original Message ------- On Sunday, June 26th, 2022 at 2:38 PM, Lars Ingebrigtsen w= rote: > Stefan Kangas stefan@marxist.se writes: > > > Jean Louis bugs@gnu.support writes: > > > > > When executing C-c C-l t in sql-interactive-mode then tables are > > > completed with quotes like "activities" instead of just activities. > > > > > > It would be good not to use quotes, it is more usable that > > > way. Internally the table could require quotes to be called, but for > > > user to complete a string or name of table should not be necessary. > > > > > > Additionally I propose to include history for the function > > > sql-list-tables as calling tables' definitions may be frequent with s= ome > > > users, and other mini buffer entries are not relevant to it. > > > > I'm copying in the sql.el maintainer here. Michael, could you please ta= ke a > > look at the above feature request? > > > I'm not very familiar with sql.el, but if I read the code correctly, > `C-c C-l t' just outputs the data the SQL server spits back at us? So > if you're using PostgreSQL, I guess that means that that's how > PostgreSQL formats the CREATE TABLE statement. > > But I may be mistaken -- perhaps Michael has some comments here. > > -- > (domestic pets only, the antidote for overdose, milk.) > bloggy blog: http://lars.ingebrigtsen.no