From unknown Fri Jun 13 11:43:42 2025 X-Loop: help-debbugs@gnu.org Subject: bug#29105: 25.2; sqli postgres missing prompts with underscore Resent-From: Felipe Ochoa Original-Sender: "Debbugs-submit" Resent-CC: bug-gnu-emacs@gnu.org Resent-Date: Wed, 01 Nov 2017 14:11:01 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: report 29105 X-GNU-PR-Package: emacs X-GNU-PR-Keywords: To: 29105@debbugs.gnu.org X-Debbugs-Original-To: bug-gnu-emacs@gnu.org Received: via spool by submit@debbugs.gnu.org id=B.150954540524560 (code B ref -1); Wed, 01 Nov 2017 14:11:01 +0000 Received: (at submit) by debbugs.gnu.org; 1 Nov 2017 14:10:05 +0000 Received: from localhost ([127.0.0.1]:46058 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1e9tiX-0006O4-GB for submit@debbugs.gnu.org; Wed, 01 Nov 2017 10:10:05 -0400 Received: from eggs.gnu.org ([208.118.235.92]:39982) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1e9tiV-0006N5-DL for submit@debbugs.gnu.org; Wed, 01 Nov 2017 10:10:03 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1e9tiL-0002mq-Kd for submit@debbugs.gnu.org; Wed, 01 Nov 2017 10:09:58 -0400 X-Spam-Checker-Version: SpamAssassin 3.3.2 (2011-06-06) on eggs.gnu.org X-Spam-Level: X-Spam-Status: No, score=0.8 required=5.0 tests=BAYES_50,FREEMAIL_FROM, T_DKIM_INVALID autolearn=disabled version=3.3.2 Received: from lists.gnu.org ([2001:4830:134:3::11]:33025) by eggs.gnu.org with esmtps (TLS1.0:RSA_AES_256_CBC_SHA1:32) (Exim 4.71) (envelope-from ) id 1e9tiL-0002mX-94 for submit@debbugs.gnu.org; Wed, 01 Nov 2017 10:09:53 -0400 Received: from eggs.gnu.org ([2001:4830:134:3::10]:59150) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1e9tiK-00012l-3w for bug-gnu-emacs@gnu.org; Wed, 01 Nov 2017 10:09:53 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1e9tiF-0002et-6W for bug-gnu-emacs@gnu.org; Wed, 01 Nov 2017 10:09:52 -0400 Received: from mail-vk0-x230.google.com ([2607:f8b0:400c:c05::230]:54624) by eggs.gnu.org with esmtps (TLS1.0:RSA_AES_128_CBC_SHA1:16) (Exim 4.71) (envelope-from ) id 1e9tiE-0002eS-SY for bug-gnu-emacs@gnu.org; Wed, 01 Nov 2017 10:09:46 -0400 Received: by mail-vk0-x230.google.com with SMTP id n70so1470262vkf.11 for ; Wed, 01 Nov 2017 07:09:46 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=from:to:subject:date:message-id:mime-version; bh=DZhjrDfVZe5v1o2HiSaE8J/y4F2cWyxQbFiaepmgN/0=; b=EhjZLmyvpzGNsAgC+giNG7e1jAgG+CvW1OlA/3bsJFBHka7YZzViIIqgdZnR7t/ezE jeQ3wFlZELW1nso2oR1fmIZpKpldbqs9jWvtr/GxDJ+0Fj3vKfGnqOYjjPdIJQMiV/Qt 859FMSrcnvpQ+l/DhXXuDB07Ui3MP8EVRmNucc9wHLxyAV2ZWPrie/R/gkQdZvjhUHuj KFWYyzci3mcn6WfxGbKDQudWo59XBxH/kWjjBIQG5B8gJP0CFrtPub2gbg0CmFxW0k0Y SazFdrkYh+B/eQnUziWuhjBnGNtw2fKUvXn8atqoqA7FmgNpB3xAQMyPpmks+5yM7T1H zxKQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:from:to:subject:date:message-id:mime-version; bh=DZhjrDfVZe5v1o2HiSaE8J/y4F2cWyxQbFiaepmgN/0=; b=o/IaXnEQeJc8cl2xOxDTVBwxvnAfdSvIhcYhtKojy9/Q270uKq3uBHMSIZaGmv4DmC 9Rpv6RiwU+UaFIXhM1PdfTlUbMef7yQp4G6S53p5PYf/At4BkTONFquZfQh8TeWifZtH QnyUfOMq+5IsnvoIaG8T8nV6WtMGdTuFXYOhCTV83FAbLDGfD5UkQkIXo0+RCnCXBosb 8BikpIHL6RKLDeojngUSfhX2tfguqTgJqt9aU4oYIOYHH89H6jIItYT1IHEiYd9CqBVM hx3EjB3XwtMfCGBi3awPZPOVc0Ss9a2m0KLbZuG20NyOjgmh1q7rBvblhI+Wnz5SEpqy /AYA== X-Gm-Message-State: AJaThX4ljq8bSgcROocTlhfTgy1tAurFbh0vtDALjMHeX7gSbNJ3CfK9 cDFMug6ziwvokwCqeDcPJIzgVzf1 X-Google-Smtp-Source: ABhQp+SKzbxosGmQCR2CmiFqeR9AIbQZx/Tt+b25JwdCs+EzeFaM1zX8TDHQdUubC2s3CojqSvVVWA== X-Received: by 10.31.234.131 with SMTP id i125mr4258915vkh.149.1509545385782; Wed, 01 Nov 2017 07:09:45 -0700 (PDT) Received: from x1-ubuntu ([181.60.234.59]) by smtp.gmail.com with ESMTPSA id c5sm200527vka.11.2017.11.01.07.09.44 for (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Wed, 01 Nov 2017 07:09:45 -0700 (PDT) From: Felipe Ochoa Date: Wed, 01 Nov 2017 09:09:41 -0500 Message-ID: <87mv46t7iy.fsf@gmail.com> MIME-Version: 1.0 Content-Type: text/plain X-detected-operating-system: by eggs.gnu.org: Genre and OS details not recognized. X-detected-operating-system: by eggs.gnu.org: GNU/Linux 2.6.x X-Received-From: 2001:4830:134:3::11 X-Spam-Score: -4.0 (----) 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: -4.0 (----) Tables with underscores in their names (e.g., as generated by Django) have their prompts removed from the buffer by the process filter, resulting in something like the following psql (9.6.5, server 9.5.5) You are now connected to database "app_model" as user "user". SELECT ... I'm not sure how exactly it's happening, but I think it's in `sql-interactive-remove-continuation-prompt'. At any rate, the problem can be fixed by changing the postgres `:prompt-regexp' and `:prompt-cont-regexp' to "^\\(?:[[:word:]]\\|\\s_\\)*=[#>] " and "^\\(?:[[:word:]]\\|\\s_\\)*[-(][#>] " respectively to allow symbols in table names. If that seems too lax, we could also special-case underscore, since I think it's the most common symbol used in table names. -Felipe In GNU Emacs 25.2.1 (x86_64-unknown-linux-gnu, GTK+ Version 3.18.9) of 2017-07-19 built on x1-ubuntu Windowing system distributor 'The X.Org Foundation', version 11.0.11804000 System Description: Ubuntu 16.04.3 LTS Configured using: 'configure --without-cairo --with-xwidgets --with-x-toolkit=gtk3 --with-modules' Configured features: XPM JPEG TIFF GIF PNG RSVG IMAGEMAGICK SOUND GPM DBUS GCONF GSETTINGS NOTIFY ACL GNUTLS LIBXML2 FREETYPE M17N_FLT LIBOTF XFT ZLIB TOOLKIT_SCROLL_BARS GTK3 X11 MODULES XWIDGETS Important settings: value of $LC_MONETARY: en_US.UTF-8 value of $LC_NUMERIC: en_US.UTF-8 value of $LC_TIME: en_US.UTF-8 value of $LANG: en_US.UTF8 value of $XMODIFIERS: @im=ibus locale-coding-system: utf-8-unix From debbugs-submit-bounces@debbugs.gnu.org Sun Apr 21 02:02:58 2019 Received: (at control) by debbugs.gnu.org; 21 Apr 2019 06:02:58 +0000 Received: from localhost ([127.0.0.1]:47300 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1hI5Z4-0001aM-Bd for submit@debbugs.gnu.org; Sun, 21 Apr 2019 02:02:58 -0400 Received: from mail4.protonmail.ch ([185.70.40.27]:41959) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1hI5Z1-0001a6-IV for control@debbugs.gnu.org; Sun, 21 Apr 2019 02:02:57 -0400 Date: Sun, 21 Apr 2019 06:02:46 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=protonmail.com; s=default; t=1555826568; bh=nAoozreqsFDRnjPpR3zIY1QLcg0pc9ym4j0YiqefP9o=; h=Date:To:From:Reply-To:Subject:Feedback-ID:From; b=NegChC/naIyUpeMpXwRhcLVQX1DxnDxELsnkP7lo5q1VqkkIY0xNaNjShB0SOEFvi rhCZMbDhZY8a3BVPq6dPClG4W+onXW0BfnWWL7ER3V5h53CeTVntOmYvALo9a/5OKV aONEc0sYx4BKdY667eVGk43MezP2orkRizMpjVOo= To: "control@debbugs.gnu.org" From: Michael Mauger Subject: Close bugs Message-ID: Feedback-ID: b6CpL0MxcIA6fpHRkn3ZHzWS0Hoqxbtv_SrHfEzC9D85cLvnRsVk4rKaAOJUw48iy20W0W1VX4whjBYFluIX0w==:Ext:ProtonMail MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-Spam-Status: No, score=-1.2 required=7.0 tests=ALL_TRUSTED,DKIM_SIGNED, DKIM_VALID,DKIM_VALID_AU,DKIM_VALID_EF,FREEMAIL_FROM autolearn=ham autolearn_force=no version=3.4.2 X-Spam-Checker-Version: SpamAssassin 3.4.2 (2018-09-13) on mail.protonmail.ch X-Spam-Score: -0.7 (/) X-Debbugs-Envelope-To: control 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.7 (-) # placeholder close 11481 27.0.50 # missing prompt-cont-regexp handling close 24483 27.0.50 # postgres password prompt tag 18066 + unreproducible moreinfo tag 18240 + unreproducible moreinfo tag 20288 + unreproducible moreinfo tag 20289 + unreproducible moreinfo notabug tag 23063 + unreproducible moreinfo tag 29105 + unreproducible moreinfo tag 3569 + notabug close 3569 close 14759 26.1 tag 15202 + notabug tag 22016 + unreproducible moreinfo close 22106 26.1 close 30247 27.0.50 thank you -- MICHAEL@MAUGER.COM // FSF and EFF member // GNU Emacs sql.el maintainer From unknown Fri Jun 13 11:43:42 2025 MIME-Version: 1.0 X-Mailer: MIME-tools 5.505 (Entity 5.505) X-Loop: help-debbugs@gnu.org From: help-debbugs@gnu.org (GNU bug Tracking System) To: Felipe Ochoa Subject: bug#29105: closed (Re: Close bugs) Message-ID: References: <87mv46t7iy.fsf@gmail.com> X-Gnu-PR-Message: they-closed 29105 X-Gnu-PR-Package: emacs X-Gnu-PR-Keywords: unreproducible moreinfo Reply-To: 29105@debbugs.gnu.org Date: Mon, 10 Aug 2020 16:37:01 +0000 Content-Type: multipart/mixed; boundary="----------=_1597077421-6477-1" This is a multi-part message in MIME format... ------------=_1597077421-6477-1 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset="utf-8" Your bug report #29105: 25.2; sqli postgres missing prompts with underscore which was filed against the emacs package, has been closed. The explanation is attached below, along with your original report. If you require more details, please reply to 29105@debbugs.gnu.org. --=20 29105: http://debbugs.gnu.org/cgi/bugreport.cgi?bug=3D29105 GNU Bug Tracking System Contact help-debbugs@gnu.org with problems ------------=_1597077421-6477-1 Content-Type: message/rfc822 Content-Disposition: inline Content-Transfer-Encoding: 7bit Received: (at 29105-done) by debbugs.gnu.org; 10 Aug 2020 16:36:32 +0000 Received: from localhost ([127.0.0.1]:37342 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1k5Amm-0001fi-BH for submit@debbugs.gnu.org; Mon, 10 Aug 2020 12:36:32 -0400 Received: from mail-yb1-f195.google.com ([209.85.219.195]:34555) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1k5Amk-0001fO-21 for 29105-done@debbugs.gnu.org; Mon, 10 Aug 2020 12:36:30 -0400 Received: by mail-yb1-f195.google.com with SMTP id c9so3949541ybq.1 for <29105-done@debbugs.gnu.org>; Mon, 10 Aug 2020 09:36:30 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:from:in-reply-to:references:user-agent :mime-version:date:message-id:subject:to:cc; bh=edsvM0Kj+bA13Qooa9wmteGtqkYZ/hu2N+W4pp8drIw=; b=DA4cyN2pwayfxxXQuJy4bVTfLK5PJZWpv1vrvmensIpl3Iu/m7Rgcxl+I5QT0iT3Fi wc8xS+PlIJUtfVrubYsdmC0Bl0H3oNN3iCOoyw2cntEKtID1fOzUpppzHXDbXJD3D5Zt /ldrtLJwto27szku6UPvdsJbHNzbVcNhQGC56YO/pMoKA9QqvIFh7hhNDZLEHxVpCCOq KL1rL2EINca8umAJ6SsJwdmyXK+ALdeop/1YLt08mROhsdkz5RzrrU4VFokfPcPFw4Ct WIoskEtcCMpuli3SF+Nn1e9lgakWddYeNrQ6EdSPt7Y4j0UmgqcmRMZDXDmNqAFrKotD dkHQ== X-Gm-Message-State: AOAM531p4aAj5TtDGF9/+jKq2+MGIg5Oj9yJx4SMTaZ+Btq4xLSdygzQ nH2lgCl8wUisHRPH915e1SuigIK8a+K3HlEQXuA= X-Google-Smtp-Source: ABdhPJwpTxLVqO3OFpFbFDtzxeh6XznLLdDmLl1PwbJaNpfmIVVj8/3Xbz0tzJgAfo4xURwnJdgNOkCoLKCW9l1ck8Q= X-Received: by 2002:a25:9843:: with SMTP id k3mr41431718ybo.466.1597077383040; Mon, 10 Aug 2020 09:36:23 -0700 (PDT) Received: from 753933720722 named unknown by gmailapi.google.com with HTTPREST; Mon, 10 Aug 2020 09:36:22 -0700 From: Stefan Kangas In-Reply-To: (Michael Mauger's message of "Sun, 21 Apr 2019 06:02:46 +0000") References: User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/28.0.50 (gnu/linux) MIME-Version: 1.0 Date: Mon, 10 Aug 2020 09:36:22 -0700 Message-ID: Subject: Re: Close bugs To: Michael Mauger Content-Type: text/plain; charset="UTF-8" X-Spam-Score: 0.0 (/) X-Debbugs-Envelope-To: 29105-done Cc: 29105-done@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: -1.0 (-) The intention below seems to have been to close this bug, so I'm doing that now. If this conclusion is incorrect, please reply to this email (use "Reply to all" in your email client) and we can reopen the bug report. Best regards, Stefan Kangas Michael Mauger writes: > # placeholder > close 11481 27.0.50 > # missing prompt-cont-regexp handling > close 24483 27.0.50 > # postgres password prompt > tag 18066 + unreproducible moreinfo > tag 18240 + unreproducible moreinfo > tag 20288 + unreproducible moreinfo > tag 20289 + unreproducible moreinfo notabug > tag 23063 + unreproducible moreinfo > tag 29105 + unreproducible moreinfo > > tag 3569 + notabug > close 3569 > > close 14759 26.1 > > tag 15202 + notabug > > tag 22016 + unreproducible moreinfo > close 22106 26.1 > > close 30247 27.0.50 > > thank you > > -- > MICHAEL@MAUGER.COM // FSF and EFF member // GNU Emacs sql.el maintainer ------------=_1597077421-6477-1 Content-Type: message/rfc822 Content-Disposition: inline Content-Transfer-Encoding: 7bit Received: (at submit) by debbugs.gnu.org; 1 Nov 2017 14:10:05 +0000 Received: from localhost ([127.0.0.1]:46058 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1e9tiX-0006O4-GB for submit@debbugs.gnu.org; Wed, 01 Nov 2017 10:10:05 -0400 Received: from eggs.gnu.org ([208.118.235.92]:39982) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1e9tiV-0006N5-DL for submit@debbugs.gnu.org; Wed, 01 Nov 2017 10:10:03 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1e9tiL-0002mq-Kd for submit@debbugs.gnu.org; Wed, 01 Nov 2017 10:09:58 -0400 X-Spam-Checker-Version: SpamAssassin 3.3.2 (2011-06-06) on eggs.gnu.org X-Spam-Level: X-Spam-Status: No, score=0.8 required=5.0 tests=BAYES_50,FREEMAIL_FROM, T_DKIM_INVALID autolearn=disabled version=3.3.2 Received: from lists.gnu.org ([2001:4830:134:3::11]:33025) by eggs.gnu.org with esmtps (TLS1.0:RSA_AES_256_CBC_SHA1:32) (Exim 4.71) (envelope-from ) id 1e9tiL-0002mX-94 for submit@debbugs.gnu.org; Wed, 01 Nov 2017 10:09:53 -0400 Received: from eggs.gnu.org ([2001:4830:134:3::10]:59150) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1e9tiK-00012l-3w for bug-gnu-emacs@gnu.org; Wed, 01 Nov 2017 10:09:53 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1e9tiF-0002et-6W for bug-gnu-emacs@gnu.org; Wed, 01 Nov 2017 10:09:52 -0400 Received: from mail-vk0-x230.google.com ([2607:f8b0:400c:c05::230]:54624) by eggs.gnu.org with esmtps (TLS1.0:RSA_AES_128_CBC_SHA1:16) (Exim 4.71) (envelope-from ) id 1e9tiE-0002eS-SY for bug-gnu-emacs@gnu.org; Wed, 01 Nov 2017 10:09:46 -0400 Received: by mail-vk0-x230.google.com with SMTP id n70so1470262vkf.11 for ; Wed, 01 Nov 2017 07:09:46 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=from:to:subject:date:message-id:mime-version; bh=DZhjrDfVZe5v1o2HiSaE8J/y4F2cWyxQbFiaepmgN/0=; b=EhjZLmyvpzGNsAgC+giNG7e1jAgG+CvW1OlA/3bsJFBHka7YZzViIIqgdZnR7t/ezE jeQ3wFlZELW1nso2oR1fmIZpKpldbqs9jWvtr/GxDJ+0Fj3vKfGnqOYjjPdIJQMiV/Qt 859FMSrcnvpQ+l/DhXXuDB07Ui3MP8EVRmNucc9wHLxyAV2ZWPrie/R/gkQdZvjhUHuj KFWYyzci3mcn6WfxGbKDQudWo59XBxH/kWjjBIQG5B8gJP0CFrtPub2gbg0CmFxW0k0Y SazFdrkYh+B/eQnUziWuhjBnGNtw2fKUvXn8atqoqA7FmgNpB3xAQMyPpmks+5yM7T1H zxKQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:from:to:subject:date:message-id:mime-version; bh=DZhjrDfVZe5v1o2HiSaE8J/y4F2cWyxQbFiaepmgN/0=; b=o/IaXnEQeJc8cl2xOxDTVBwxvnAfdSvIhcYhtKojy9/Q270uKq3uBHMSIZaGmv4DmC 9Rpv6RiwU+UaFIXhM1PdfTlUbMef7yQp4G6S53p5PYf/At4BkTONFquZfQh8TeWifZtH QnyUfOMq+5IsnvoIaG8T8nV6WtMGdTuFXYOhCTV83FAbLDGfD5UkQkIXo0+RCnCXBosb 8BikpIHL6RKLDeojngUSfhX2tfguqTgJqt9aU4oYIOYHH89H6jIItYT1IHEiYd9CqBVM hx3EjB3XwtMfCGBi3awPZPOVc0Ss9a2m0KLbZuG20NyOjgmh1q7rBvblhI+Wnz5SEpqy /AYA== X-Gm-Message-State: AJaThX4ljq8bSgcROocTlhfTgy1tAurFbh0vtDALjMHeX7gSbNJ3CfK9 cDFMug6ziwvokwCqeDcPJIzgVzf1 X-Google-Smtp-Source: ABhQp+SKzbxosGmQCR2CmiFqeR9AIbQZx/Tt+b25JwdCs+EzeFaM1zX8TDHQdUubC2s3CojqSvVVWA== X-Received: by 10.31.234.131 with SMTP id i125mr4258915vkh.149.1509545385782; Wed, 01 Nov 2017 07:09:45 -0700 (PDT) Received: from x1-ubuntu ([181.60.234.59]) by smtp.gmail.com with ESMTPSA id c5sm200527vka.11.2017.11.01.07.09.44 for (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Wed, 01 Nov 2017 07:09:45 -0700 (PDT) From: Felipe Ochoa To: bug-gnu-emacs@gnu.org Subject: 25.2; sqli postgres missing prompts with underscore Date: Wed, 01 Nov 2017 09:09:41 -0500 Message-ID: <87mv46t7iy.fsf@gmail.com> MIME-Version: 1.0 Content-Type: text/plain X-detected-operating-system: by eggs.gnu.org: Genre and OS details not recognized. X-detected-operating-system: by eggs.gnu.org: GNU/Linux 2.6.x X-Received-From: 2001:4830:134:3::11 X-Spam-Score: -4.0 (----) 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: -4.0 (----) Tables with underscores in their names (e.g., as generated by Django) have their prompts removed from the buffer by the process filter, resulting in something like the following psql (9.6.5, server 9.5.5) You are now connected to database "app_model" as user "user". SELECT ... I'm not sure how exactly it's happening, but I think it's in `sql-interactive-remove-continuation-prompt'. At any rate, the problem can be fixed by changing the postgres `:prompt-regexp' and `:prompt-cont-regexp' to "^\\(?:[[:word:]]\\|\\s_\\)*=[#>] " and "^\\(?:[[:word:]]\\|\\s_\\)*[-(][#>] " respectively to allow symbols in table names. If that seems too lax, we could also special-case underscore, since I think it's the most common symbol used in table names. -Felipe In GNU Emacs 25.2.1 (x86_64-unknown-linux-gnu, GTK+ Version 3.18.9) of 2017-07-19 built on x1-ubuntu Windowing system distributor 'The X.Org Foundation', version 11.0.11804000 System Description: Ubuntu 16.04.3 LTS Configured using: 'configure --without-cairo --with-xwidgets --with-x-toolkit=gtk3 --with-modules' Configured features: XPM JPEG TIFF GIF PNG RSVG IMAGEMAGICK SOUND GPM DBUS GCONF GSETTINGS NOTIFY ACL GNUTLS LIBXML2 FREETYPE M17N_FLT LIBOTF XFT ZLIB TOOLKIT_SCROLL_BARS GTK3 X11 MODULES XWIDGETS Important settings: value of $LC_MONETARY: en_US.UTF-8 value of $LC_NUMERIC: en_US.UTF-8 value of $LC_TIME: en_US.UTF-8 value of $LANG: en_US.UTF8 value of $XMODIFIERS: @im=ibus locale-coding-system: utf-8-unix ------------=_1597077421-6477-1--