GNU logs - #47357, boring messages

Message sent to bug-gnu-emacs@HIDDEN:

Subject: bug#47357: 28.0.50; sql-list-tables: Executing SQL command... takes indefinite time after creation of new table
Resent-From: Jean Louis <bugs@HIDDEN>
Original-Sender: "Debbugs-submit" <debbugs-submit-bounces <at> debbugs.gnu.org>
Resent-CC: bug-gnu-emacs@HIDDEN
Resent-Date: Wed, 24 Mar 2021 08:00:02 +0000
Resent-Message-ID: <handler.47357.B.161657276221313 <at> debbugs.gnu.org>
Resent-Sender: help-debbugs@HIDDEN
To: 47357 <at> debbugs.gnu.org
From: Jean Louis <bugs@HIDDEN>
Date: Wed, 24 Mar 2021 10:58:30 +0300
Message-ID: <867dlxnftl.fsf@HIDDEN>
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@HIDDEN; 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-BeenThere: debbugs-submit <at> debbugs.gnu.org
X-Mailman-Version: 2.1.18
Precedence: list
List-Id: <debbugs-submit.debbugs.gnu.org>
List-Unsubscribe: <https://debbugs.gnu.org/cgi-bin/mailman/options/debbugs-submit>, 
 <mailto:debbugs-submit-request <at> debbugs.gnu.org?subject=unsubscribe>
List-Archive: <https://debbugs.gnu.org/cgi-bin/mailman/private/debbugs-submit/>
List-Post: <mailto:debbugs-submit <at> debbugs.gnu.org>
List-Help: <mailto:debbugs-submit-request <at> debbugs.gnu.org?subject=help>
List-Subscribe: <https://debbugs.gnu.org/cgi-bin/mailman/listinfo/debbugs-submit>, 
 <mailto:debbugs-submit-request <at> debbugs.gnu.org?subject=subscribe>
Errors-To: debbugs-submit-bounces <at> debbugs.gnu.org
Sender: "Debbugs-submit" <debbugs-submit-bounces <at> debbugs.gnu.org>
X-Spam-Score: -2.1 (--)

I have noticed, but have not researched why, is that function
`sql-list-tables' takes indefinite time without completing or giving
result when I do following:

- M-x sql-postgres RET and more entries until I get into the SQL buffer

- create new table

- C-c C-l t with new table name is then taking indefinite time.

Maybe the library is reading tables only at initializations, I may be
wrong. In SQL buffer there is no problem to inspect the table, but C-c
C-l t does not allow it for new table created.

This may all be wrong and related to some other bug there, I do not
know. I was interrupting the indefinite message with C-g.

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:
(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 56355 6695)
 (symbols 48 7105 0)
 (strings 32 20372 1235)
 (string-bytes 1 656059)
 (vectors 16 14408)
 (vector-slots 8 192257 13655)
 (floats 8 23 38)
 (intervals 56 251 0)
 (buffers 992 12))

--=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

Message sent:

Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0
X-Mailer: MIME-tools 5.505 (Entity 5.505)
Content-Type: text/plain; charset=utf-8
X-Loop: help-debbugs@HIDDEN
From: help-debbugs@HIDDEN (GNU bug Tracking System)
To: Jean Louis <bugs@HIDDEN>
Subject: bug#47357: Acknowledgement (28.0.50; sql-list-tables: Executing
 SQL command... takes indefinite time after creation of new table)
Message-ID: <handler.47357.B.161657276221313.ack <at> debbugs.gnu.org>
References: <867dlxnftl.fsf@HIDDEN>
X-Gnu-PR-Message: ack 47357
X-Gnu-PR-Package: emacs
Reply-To: 47357 <at> debbugs.gnu.org
Date: Wed, 24 Mar 2021 08:00:02 +0000

Thank you for filing a new bug report with debbugs.gnu.org.

This is an automatically generated reply to let you know your message
has been received.

Your message is being forwarded to the package maintainers and other
interested parties for their attention; they will reply in due course.

Your message has been sent to the package maintainer(s):
 bug-gnu-emacs@HIDDEN

If you wish to submit further information on this problem, please
send it to 47357 <at> debbugs.gnu.org.

Please do not send mail to help-debbugs@HIDDEN unless you wish
to report a problem with the Bug-tracking system.

--=20
47357: http://debbugs.gnu.org/cgi/bugreport.cgi?bug=3D47357
GNU Bug Tracking System
Contact help-debbugs@HIDDEN with problems

Message sent to bug-gnu-emacs@HIDDEN:

Subject: bug#47357: 28.0.50; sql-list-tables: Executing SQL command... takes indefinite time after creation of new table
Resent-From: Stefan Kangas <stefan@HIDDEN>
Original-Sender: "Debbugs-submit" <debbugs-submit-bounces <at> debbugs.gnu.org>
Resent-CC: bug-gnu-emacs@HIDDEN
Resent-Date: Thu, 21 Oct 2021 21:04:02 +0000
Resent-Message-ID: <handler.47357.B47357.163485018521766 <at> debbugs.gnu.org>
Resent-Sender: help-debbugs@HIDDEN
To: Jean Louis <bugs@HIDDEN>
Cc: 47357 <at> debbugs.gnu.org, Michael Mauger <mmauger@HIDDEN>
From: Stefan Kangas <stefan@HIDDEN>
In-Reply-To: <867dlxnftl.fsf@HIDDEN> (Jean Louis's message of
 "Wed, 24 Mar 2021 10:58:30 +0300")
References: <867dlxnftl.fsf@HIDDEN>
User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/29.0.50 (gnu/linux)
MIME-Version: 1.0
Date: Thu, 21 Oct 2021 14:02:57 -0700
Message-ID: <CADwFkmmPqv=9vRhC604u1=_w7ahEDX9cQMRNV4+sTujBbbFvDg@HIDDEN>
Content-Type: text/plain; charset="UTF-8"
Precedence: list
Errors-To: debbugs-submit-bounces <at> debbugs.gnu.org
Sender: "Debbugs-submit" <debbugs-submit-bounces <at> debbugs.gnu.org>

Jean Louis <bugs@HIDDEN> writes:

> I have noticed, but have not researched why, is that function
> `sql-list-tables' takes indefinite time without completing or giving
> result when I do following:
>
> - M-x sql-postgres RET and more entries until I get into the SQL buffer
>
> - create new table
>
> - C-c C-l t with new table name is then taking indefinite time.
>
> Maybe the library is reading tables only at initializations, I may be
> wrong. In SQL buffer there is no problem to inspect the table, but C-c
> C-l t does not allow it for new table created.
>
> This may all be wrong and related to some other bug there, I do not
> know. I was interrupting the indefinite message with C-g.

I'm copying in the sql.el maintainer here.  Michael, could you please
take a look at the above bug report?

Message sent to bug-gnu-emacs@HIDDEN:

Subject: bug#47357: 28.0.50; sql-list-tables: Executing SQL command... takes indefinite time after creation of new table
Resent-From: Michael Mauger <mmauger@HIDDEN>
Original-Sender: "Debbugs-submit" <debbugs-submit-bounces <at> debbugs.gnu.org>
Resent-CC: bug-gnu-emacs@HIDDEN
Resent-Date: Sun, 24 Oct 2021 22:06:02 +0000
Resent-Message-ID: <handler.47357.B47357.163511315824652 <at> debbugs.gnu.org>
Resent-Sender: help-debbugs@HIDDEN
To: Stefan Kangas <stefan@HIDDEN>
Cc: 47357 <at> debbugs.gnu.org, Jean Louis <bugs@HIDDEN>
Reply-To: Michael Mauger <mmauger@HIDDEN>
Date: Sun, 24 Oct 2021 22:05:41 +0000
From: Michael Mauger <mmauger@HIDDEN>
Message-ID: <YRSc2gcENmen53NtFLaITx-RFSlZPc2YlP08C188MGgEEub9HHfH7K08HLgk5AHAGiEL4uHBpGLs8G-z-3gUyCu5xbyZISpTaVlr5sFuSYY=@protonmail.com>
In-Reply-To: <CADwFkmmPqv=9vRhC604u1=_w7ahEDX9cQMRNV4+sTujBbbFvDg@HIDDEN>
References: <867dlxnftl.fsf@HIDDEN>
 <CADwFkmmPqv=9vRhC604u1=_w7ahEDX9cQMRNV4+sTujBbbFvDg@HIDDEN>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
Precedence: list
Errors-To: debbugs-submit-bounces <at> debbugs.gnu.org
Sender: "Debbugs-submit" <debbugs-submit-bounces <at> debbugs.gnu.org>

On Thursday, October 21st, 2021 at 5:02 PM, Stefan Kangas <stefan@HIDDEN=
e> wrote:
> Jean Louis bugs@HIDDEN writes:
>
> > I have noticed, but have not researched why, is that function
> > `sql-list-tables' takes indefinite time without completing or giving
> > result when I do following:
> >
> > -   M-x sql-postgres RET and more entries until I get into the SQL buff=
er
> > -   create new table
> > -   C-c C-l t with new table name is then taking indefinite time.
> >
> > Maybe the library is reading tables only at initializations, I may be
> > wrong. In SQL buffer there is no problem to inspect the table, but C-c
> > C-l t does not allow it for new table created.
> >
> > This may all be wrong and related to some other bug there, I do not
> > know. I was interrupting the indefinite message with C-g.
>
> I'm copying in the sql.el maintainer here. Michael, could you please
> take a look at the above bug report?

The problem here is that the `sql-list-tables' feature uses the
`comint-redirect-send-command-to-process' procedure to capture the SQL
interpreter response and that relies upon the `comint-prompt-regexp'
variable to be set appropriately. Comint Mode itself no longer relies
upon the regexp to spot the prompt but the redirect logic does.

The default prompt regexp for Postgres in sql.el is not correct and a
fix will be made for Emacs 28 and master for that.

I will also add a function to sql.el to verify the prompt as best I can
to Emacs-28 so at least an error message or workaround can be provided.

On master, I'll submit a similar change to comint.el to protect all
Comint derived modes if they use the redirect logic and prevent the
hanging behavior.

I was aware of the bad prompt regexp but had forgotten to commit that
change. I'll go ahead and do that now.
--
MICHAEL@HIDDEN // FSF and EFF member // GNU Emacs sql.el maintainer

Message sent to bug-gnu-emacs@HIDDEN:

X-Loop: help-debbugs@HIDDEN
Subject: bug#47357: 28.0.50; sql-list-tables: Executing SQL command... takes indefinite time after creation of new table
Resent-From: Stefan Kangas <stefan@HIDDEN>
Original-Sender: "Debbugs-submit" <debbugs-submit-bounces <at> debbugs.gnu.org>
Resent-CC: bug-gnu-emacs@HIDDEN
Resent-Date: Sun, 24 Oct 2021 22:25:02 +0000
Resent-Message-ID: <handler.47357.B47357.16351142892486 <at> debbugs.gnu.org>
Resent-Sender: help-debbugs@HIDDEN
X-GNU-PR-Message: followup 47357
X-GNU-PR-Package: emacs
X-GNU-PR-Keywords: 
To: Michael Mauger <mmauger@HIDDEN>
Cc: 47357 <at> debbugs.gnu.org, Jean Louis <bugs@HIDDEN>
Received: via spool by 47357-submit <at> debbugs.gnu.org id=B47357.16351142892486
          (code B ref 47357); Sun, 24 Oct 2021 22:25:02 +0000
Received: (at 47357) by debbugs.gnu.org; 24 Oct 2021 22:24:49 +0000
Received: from localhost ([127.0.0.1]:41209 helo=debbugs.gnu.org)
	by debbugs.gnu.org with esmtp (Exim 4.84_2)
	(envelope-from <debbugs-submit-bounces <at> debbugs.gnu.org>)
	id 1melv6-0000e1-Qr
	for submit <at> debbugs.gnu.org; Sun, 24 Oct 2021 18:24:48 -0400
Received: from mail-pf1-f173.google.com ([209.85.210.173]:45774)
 by debbugs.gnu.org with esmtp (Exim 4.84_2)
 (envelope-from <stefankangas@HIDDEN>) id 1melv4-0000dm-VH
 for 47357 <at> debbugs.gnu.org; Sun, 24 Oct 2021 18:24:47 -0400
Received: by mail-pf1-f173.google.com with SMTP id f11so8876137pfc.12
 for <47357 <at> debbugs.gnu.org>; Sun, 24 Oct 2021 15:24:46 -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:mime-version:date
 :message-id:subject:to:cc;
 bh=lhE2iQPY69Z9kX7TnsPMVKZjRjzLqHlzYHZBlWOD0jY=;
 b=f///nXUryO9DaOmbld7Aqh9e0cXPQ/LsondwhY+NJ5+Bz76bFDa1qAyLXosRE9SV3W
 y1Ca07bV17/Dhiia/HRKwj5f4mR+F2+fYTNAdvcIzIdz15WP3C7yZkY2vTLAECmgi7zF
 x+LzYdzvzT1qVqJyb3gJpIIm+jnp2h/ZiDz1Jh/4lACzWv54bqoI5QNu3rVwPsOeW5F5
 s1VyntKY4Nwkf7jPz8/ETBIcYjMgualorqvMgxRjaSyimbrtA5eD1QFCuxoRB2n+2ahd
 zJcgDR7G/0ltGHAk3oCfMZzm9WC7A1IQc2N26bMoKG6K142nCTY5VqMH3lr10PYdQjCn
 COsQ==
X-Gm-Message-State: AOAM530whHZIZheNSWMRTZqh5d0NznpjXbzcjA6VxmvuxupII6bU3BOK
 qQtBynWgIpKqhD0xRF4yy4AMCiqsldWQen3Vgbo=
X-Google-Smtp-Source: ABdhPJzcPhEYFIJ56TFoUkbSBPqUp/uyQww0XI9RlxVqG7n9REQ2Lo5YIInprt78fl1prjRnBkfr9qIyDRHTMQixdpY=
X-Received: by 2002:a05:6a00:244d:b0:44d:c279:5155 with SMTP id
 d13-20020a056a00244d00b0044dc2795155mr14527284pfj.0.1635114281091; Sun, 24
 Oct 2021 15:24:41 -0700 (PDT)
Received: from 753933720722 named unknown by gmailapi.google.com with
 HTTPREST; Sun, 24 Oct 2021 15:24:40 -0700
From: Stefan Kangas <stefan@HIDDEN>
In-Reply-To: <YRSc2gcENmen53NtFLaITx-RFSlZPc2YlP08C188MGgEEub9HHfH7K08HLgk5AHAGiEL4uHBpGLs8G-z-3gUyCu5xbyZISpTaVlr5sFuSYY=@protonmail.com>
References: <867dlxnftl.fsf@HIDDEN>
 <CADwFkmmPqv=9vRhC604u1=_w7ahEDX9cQMRNV4+sTujBbbFvDg@HIDDEN>
 <YRSc2gcENmen53NtFLaITx-RFSlZPc2YlP08C188MGgEEub9HHfH7K08HLgk5AHAGiEL4uHBpGLs8G-z-3gUyCu5xbyZISpTaVlr5sFuSYY=@protonmail.com>
MIME-Version: 1.0
Date: Sun, 24 Oct 2021 15:24:40 -0700
Message-ID: <CADwFkmmNNY0iNM5mw0VrbEBC7q2Zt6QdTACrJUbYPba3ZR6PRQ@HIDDEN>
Content-Type: text/plain; charset="UTF-8"
X-Spam-Score: 0.5 (/)
X-BeenThere: debbugs-submit <at> debbugs.gnu.org
X-Mailman-Version: 2.1.18
Precedence: list
List-Id: <debbugs-submit.debbugs.gnu.org>
List-Unsubscribe: <https://debbugs.gnu.org/cgi-bin/mailman/options/debbugs-submit>, 
 <mailto:debbugs-submit-request <at> debbugs.gnu.org?subject=unsubscribe>
List-Archive: <https://debbugs.gnu.org/cgi-bin/mailman/private/debbugs-submit/>
List-Post: <mailto:debbugs-submit <at> debbugs.gnu.org>
List-Help: <mailto:debbugs-submit-request <at> debbugs.gnu.org?subject=help>
List-Subscribe: <https://debbugs.gnu.org/cgi-bin/mailman/listinfo/debbugs-submit>, 
 <mailto:debbugs-submit-request <at> debbugs.gnu.org?subject=subscribe>
Errors-To: debbugs-submit-bounces <at> debbugs.gnu.org
Sender: "Debbugs-submit" <debbugs-submit-bounces <at> debbugs.gnu.org>
X-Spam-Score: -0.5 (/)

Michael Mauger <mmauger@HIDDEN> writes:

> I was aware of the bad prompt regexp but had forgotten to commit that
> change. I'll go ahead and do that now.

Thank you for looking into this.  I think these fixes will be much
appreciated by our postgres users out there.

Message sent to bug-gnu-emacs@HIDDEN:

X-Loop: help-debbugs@HIDDEN
Subject: bug#47357: 28.0.50; sql-list-tables: Executing SQL command... takes indefinite time after creation of new table
Resent-From: Lars Ingebrigtsen <larsi@HIDDEN>
Original-Sender: "Debbugs-submit" <debbugs-submit-bounces <at> debbugs.gnu.org>
Resent-CC: bug-gnu-emacs@HIDDEN
Resent-Date: Sun, 26 Jun 2022 18:33:02 +0000
Resent-Message-ID: <handler.47357.B47357.165626837315347 <at> debbugs.gnu.org>
Resent-Sender: help-debbugs@HIDDEN
X-GNU-PR-Message: followup 47357
X-GNU-PR-Package: emacs
X-GNU-PR-Keywords: 
To: Michael Mauger <mmauger@HIDDEN>
Cc: 47357 <at> debbugs.gnu.org, Stefan Kangas <stefan@HIDDEN>, Jean Louis <bugs@HIDDEN>
Received: via spool by 47357-submit <at> debbugs.gnu.org id=B47357.165626837315347
          (code B ref 47357); Sun, 26 Jun 2022 18:33:02 +0000
Received: (at 47357) by debbugs.gnu.org; 26 Jun 2022 18:32:53 +0000
Received: from localhost ([127.0.0.1]:48998 helo=debbugs.gnu.org)
	by debbugs.gnu.org with esmtp (Exim 4.84_2)
	(envelope-from <debbugs-submit-bounces <at> debbugs.gnu.org>)
	id 1o5X41-0003zT-H5
	for submit <at> debbugs.gnu.org; Sun, 26 Jun 2022 14:32:53 -0400
Received: from quimby.gnus.org ([95.216.78.240]:57142)
 by debbugs.gnu.org with esmtp (Exim 4.84_2)
 (envelope-from <larsi@HIDDEN>) id 1o5X3x-0003z9-3f
 for 47357 <at> debbugs.gnu.org; Sun, 26 Jun 2022 14:32:52 -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=qD45QR7gHaQNDrg6XgEbEXAfPBejk01Vj/+ItcZXJV8=; b=WuPbxWNgTAPfcHGN+oOz8rt5Zi
 tjeEgZf2zBC5hvy3fRtn+a7Yh9d2heuHFNYdaUpQNVlzn48csphYr7AvJ5QNg6TeUac+BQ44cfWIA
 HY2mvJ7jRDDj9Jd7JyBwN80KXo2t01tV7nkH7hlngrD+uSZgvXEzpGZJ7db6wAIKAxPQ=;
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 <larsi@HIDDEN>)
 id 1o5X3n-0004sS-EV; Sun, 26 Jun 2022 20:32:41 +0200
From: Lars Ingebrigtsen <larsi@HIDDEN>
References: <867dlxnftl.fsf@HIDDEN>
 <CADwFkmmPqv=9vRhC604u1=_w7ahEDX9cQMRNV4+sTujBbbFvDg@HIDDEN>
 <YRSc2gcENmen53NtFLaITx-RFSlZPc2YlP08C188MGgEEub9HHfH7K08HLgk5AHAGiEL4uHBpGLs8G-z-3gUyCu5xbyZISpTaVlr5sFuSYY=@protonmail.com>
Date: Sun, 26 Jun 2022 20:32:38 +0200
In-Reply-To: <YRSc2gcENmen53NtFLaITx-RFSlZPc2YlP08C188MGgEEub9HHfH7K08HLgk5AHAGiEL4uHBpGLs8G-z-3gUyCu5xbyZISpTaVlr5sFuSYY=@protonmail.com>
 (Michael Mauger's message of "Sun, 24 Oct 2021 22:05:41 +0000")
Message-ID: <87wnd39sxl.fsf@HIDDEN>
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: Michael Mauger <mmauger@HIDDEN> writes: > The default
 prompt regexp for Postgres in sql.el is not correct and a > fix will be made
 for Emacs 28 and master for that. > > I will also add a function to sql.el
 to verify the prompt as best I can [...] 
 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-BeenThere: debbugs-submit <at> debbugs.gnu.org
X-Mailman-Version: 2.1.18
Precedence: list
List-Id: <debbugs-submit.debbugs.gnu.org>
List-Unsubscribe: <https://debbugs.gnu.org/cgi-bin/mailman/options/debbugs-submit>, 
 <mailto:debbugs-submit-request <at> debbugs.gnu.org?subject=unsubscribe>
List-Archive: <https://debbugs.gnu.org/cgi-bin/mailman/private/debbugs-submit/>
List-Post: <mailto:debbugs-submit <at> debbugs.gnu.org>
List-Help: <mailto:debbugs-submit-request <at> debbugs.gnu.org?subject=help>
List-Subscribe: <https://debbugs.gnu.org/cgi-bin/mailman/listinfo/debbugs-submit>, 
 <mailto:debbugs-submit-request <at> debbugs.gnu.org?subject=subscribe>
Errors-To: debbugs-submit-bounces <at> debbugs.gnu.org
Sender: "Debbugs-submit" <debbugs-submit-bounces <at> debbugs.gnu.org>
X-Spam-Score: -3.3 (---)

Michael Mauger <mmauger@HIDDEN> writes:

> The default prompt regexp for Postgres in sql.el is not correct and a
> fix will be made for Emacs 28 and master for that.
>
> I will also add a function to sql.el to verify the prompt as best I can
> to Emacs-28 so at least an error message or workaround can be provided.
>
> On master, I'll submit a similar change to comint.el to protect all
> Comint derived modes if they use the redirect logic and prevent the
> hanging behavior.
>
> I was aware of the bad prompt regexp but had forgotten to commit that
> change. I'll go ahead and do that now.

(I'm going through old bug reports that unfortunately weren't resolved
at the time.)

This was some months ago, and I had a look at the commit log for sql.el
now, but it doesn't look like this change was pushed?  (But I may be
looking for the wrong thing here.)

-- 
(domestic pets only, the antidote for overdose, milk.)
   bloggy blog: http://lars.ingebrigtsen.no

Message sent to bug-gnu-emacs@HIDDEN:

X-Loop: help-debbugs@HIDDEN
Subject: bug#47357: 28.0.50; sql-list-tables: Executing SQL command... takes indefinite time after creation of new table
Resent-From: Michael Mauger <mmauger@HIDDEN>
Original-Sender: "Debbugs-submit" <debbugs-submit-bounces <at> debbugs.gnu.org>
Resent-CC: bug-gnu-emacs@HIDDEN
Resent-Date: Tue, 05 Jul 2022 00:40:02 +0000
Resent-Message-ID: <handler.47357.B47357.165698159227849 <at> debbugs.gnu.org>
Resent-Sender: help-debbugs@HIDDEN
X-GNU-PR-Message: followup 47357
X-GNU-PR-Package: emacs
X-GNU-PR-Keywords: 
To: Lars Ingebrigtsen <larsi@HIDDEN>
Cc: 47357 <at> debbugs.gnu.org, Stefan Kangas <stefan@HIDDEN>, Jean Louis <bugs@HIDDEN>
Reply-To: Michael Mauger <mmauger@HIDDEN>
Received: via spool by 47357-submit <at> debbugs.gnu.org id=B47357.165698159227849
          (code B ref 47357); Tue, 05 Jul 2022 00:40:02 +0000
Received: (at 47357) by debbugs.gnu.org; 5 Jul 2022 00:39:52 +0000
Received: from localhost ([127.0.0.1]:48851 helo=debbugs.gnu.org)
	by debbugs.gnu.org with esmtp (Exim 4.84_2)
	(envelope-from <debbugs-submit-bounces <at> debbugs.gnu.org>)
	id 1o8WbY-0007F7-9f
	for submit <at> debbugs.gnu.org; Mon, 04 Jul 2022 20:39:52 -0400
Received: from mail-4322.protonmail.ch ([185.70.43.22]:21909)
 by debbugs.gnu.org with esmtp (Exim 4.84_2)
 (envelope-from <mmauger@HIDDEN>) id 1o8WbU-0007Er-Lg
 for 47357 <at> debbugs.gnu.org; Mon, 04 Jul 2022 20:39:50 -0400
Date: Tue, 05 Jul 2022 00:39:38 +0000
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=protonmail.com;
 s=protonmail3; t=1656981582; x=1657240782;
 bh=9pS+GvkyCB6qzO7q8IgJQSIZphKVQ4hqtzZIS6SwIcw=;
 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=H4eBp2HYhK9lfMXhq4UjAgXgs4/Q7PYwR9cdZT/BIemN8t7LWiFiJJPoYYi2isXFI
 3VHdTqkmxmMnNvc+FUh4kuiIzMyFZ64Kxay2Q3jXj5Vyw+I7w9mTPBzudBfqtrCChw
 CeOlR4DKY74Eli6/oP+1yC3D+O9OubYp1c9WqXEBVciJeArXT8JlULqhFye8FK+vZ8
 thro3geEHvdI/gaNzmuHoQB4XkZk1VtDc7gViAQI15cK5vCSAbLsfRU+5RLSYrAHLq
 qJnWusYMQHv5guQdGg+LhvN3opNYmEeNJWKIBUlWLVPBnGj5Z3gek73zWteU5vqL8o
 Hqkmhg+jLgYDA==
From: Michael Mauger <mmauger@HIDDEN>
Message-ID: <Feg69hIG-tBkM8JglkcpXFCDeSN9VBgs-pd76O0HHBzqBhhCA49N1hf6m6cs8lGv5DNVsFlhXR9ykh6BqCNUtyvGNOzjySlcsWWHpYe1VBU=@protonmail.com>
In-Reply-To: <87wnd39sxl.fsf@HIDDEN>
References: <867dlxnftl.fsf@HIDDEN>
 <CADwFkmmPqv=9vRhC604u1=_w7ahEDX9cQMRNV4+sTujBbbFvDg@HIDDEN>
 <YRSc2gcENmen53NtFLaITx-RFSlZPc2YlP08C188MGgEEub9HHfH7K08HLgk5AHAGiEL4uHBpGLs8G-z-3gUyCu5xbyZISpTaVlr5sFuSYY=@protonmail.com>
 <87wnd39sxl.fsf@HIDDEN>
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-BeenThere: debbugs-submit <at> debbugs.gnu.org
X-Mailman-Version: 2.1.18
Precedence: list
List-Id: <debbugs-submit.debbugs.gnu.org>
List-Unsubscribe: <https://debbugs.gnu.org/cgi-bin/mailman/options/debbugs-submit>, 
 <mailto:debbugs-submit-request <at> debbugs.gnu.org?subject=unsubscribe>
List-Archive: <https://debbugs.gnu.org/cgi-bin/mailman/private/debbugs-submit/>
List-Post: <mailto:debbugs-submit <at> debbugs.gnu.org>
List-Help: <mailto:debbugs-submit-request <at> debbugs.gnu.org?subject=help>
List-Subscribe: <https://debbugs.gnu.org/cgi-bin/mailman/listinfo/debbugs-submit>, 
 <mailto:debbugs-submit-request <at> debbugs.gnu.org?subject=subscribe>
Errors-To: debbugs-submit-bounces <at> debbugs.gnu.org
Sender: "Debbugs-submit" <debbugs-submit-bounces <at> debbugs.gnu.org>
X-Spam-Score: -1.0 (-)

I think the fix got pushed to 27 but I never cherry-picked it for 28.  (It'=
s been a tough Spring, hopefully settling down now)

However, this with the `sql-interactive-remove-continuation-prompt`changes =
seem to have caused some issues which I am debugging.

--
MICHAEL@HIDDEN // FSF and SFConservancy // GNU Emacs sql.el maintainer

------- Original Message -------
On Sunday, June 26th, 2022 at 2:32 PM, Lars Ingebrigtsen <larsi@HIDDEN> w=
rote:


> Michael Mauger mmauger@HIDDEN writes:
>
> > The default prompt regexp for Postgres in sql.el is not correct and a
> > fix will be made for Emacs 28 and master for that.
> >
> > I will also add a function to sql.el to verify the prompt as best I can
> > to Emacs-28 so at least an error message or workaround can be provided.
> >
> > On master, I'll submit a similar change to comint.el to protect all
> > Comint derived modes if they use the redirect logic and prevent the
> > hanging behavior.
> >
> > I was aware of the bad prompt regexp but had forgotten to commit that
> > change. I'll go ahead and do that now.
>
>
> (I'm going through old bug reports that unfortunately weren't resolved
> at the time.)
>
> This was some months ago, and I had a look at the commit log for sql.el
> now, but it doesn't look like this change was pushed? (But I may be
> looking for the wrong thing here.)
>
> --
> (domestic pets only, the antidote for overdose, milk.)
> bloggy blog: http://lars.ingebrigtsen.no

Message sent to bug-gnu-emacs@HIDDEN:

X-Loop: help-debbugs@HIDDEN
Subject: bug#47357: 28.0.50; sql-list-tables: Executing SQL command... takes indefinite time after creation of new table
Resent-From: Lars Ingebrigtsen <larsi@HIDDEN>
Original-Sender: "Debbugs-submit" <debbugs-submit-bounces <at> debbugs.gnu.org>
Resent-CC: bug-gnu-emacs@HIDDEN
Resent-Date: Tue, 05 Jul 2022 11:17:01 +0000
Resent-Message-ID: <handler.47357.B47357.16570198164713 <at> debbugs.gnu.org>
Resent-Sender: help-debbugs@HIDDEN
X-GNU-PR-Message: followup 47357
X-GNU-PR-Package: emacs
X-GNU-PR-Keywords: 
To: Michael Mauger <mmauger@HIDDEN>
Cc: 47357 <at> debbugs.gnu.org, Stefan Kangas <stefan@HIDDEN>, Jean Louis <bugs@HIDDEN>
Received: via spool by 47357-submit <at> debbugs.gnu.org id=B47357.16570198164713
          (code B ref 47357); Tue, 05 Jul 2022 11:17:01 +0000
Received: (at 47357) by debbugs.gnu.org; 5 Jul 2022 11:16:56 +0000
Received: from localhost ([127.0.0.1]:49419 helo=debbugs.gnu.org)
	by debbugs.gnu.org with esmtp (Exim 4.84_2)
	(envelope-from <debbugs-submit-bounces <at> debbugs.gnu.org>)
	id 1o8gY4-0001Dx-4T
	for submit <at> debbugs.gnu.org; Tue, 05 Jul 2022 07:16:56 -0400
Received: from quimby.gnus.org ([95.216.78.240]:42764)
 by debbugs.gnu.org with esmtp (Exim 4.84_2)
 (envelope-from <larsi@HIDDEN>) id 1o8gY2-0001Dk-Kj
 for 47357 <at> debbugs.gnu.org; Tue, 05 Jul 2022 07:16:55 -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:Date:References:
 In-Reply-To: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=iEaBJcOte0TQxi1CQUxdye0xVvwW0IHEg0bwm/2Xjg8=; b=COr/8ILDSA8pAQW9jh9trdl0WV
 hXuYi4LLOBJqeZfw3fas3TN3OUOZv2wiSbzyPyliVuOP1B30a+8AN14SrUcVFTEhJRzv+IAFgk98N
 /3xcFgq5sxiKFNdsRWFqGwxEotDH9ttVhZem4inmjGwbKGJystu/tN5CsVzN2dXL50Ig=;
Received: from [84.212.220.105] (helo=joga)
 by quimby.gnus.org with esmtpsa (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
 (Exim 4.92) (envelope-from <larsi@HIDDEN>)
 id 1o8gXt-0000tQ-9M; Tue, 05 Jul 2022 13:16:48 +0200
From: Lars Ingebrigtsen <larsi@HIDDEN>
In-Reply-To: <Feg69hIG-tBkM8JglkcpXFCDeSN9VBgs-pd76O0HHBzqBhhCA49N1hf6m6cs8lGv5DNVsFlhXR9ykh6BqCNUtyvGNOzjySlcsWWHpYe1VBU=@protonmail.com>
 (Michael Mauger's message of "Tue, 05 Jul 2022 00:39:38 +0000")
References: <867dlxnftl.fsf@HIDDEN>
 <CADwFkmmPqv=9vRhC604u1=_w7ahEDX9cQMRNV4+sTujBbbFvDg@HIDDEN>
 <YRSc2gcENmen53NtFLaITx-RFSlZPc2YlP08C188MGgEEub9HHfH7K08HLgk5AHAGiEL4uHBpGLs8G-z-3gUyCu5xbyZISpTaVlr5sFuSYY=@protonmail.com>
 <87wnd39sxl.fsf@HIDDEN>
 <Feg69hIG-tBkM8JglkcpXFCDeSN9VBgs-pd76O0HHBzqBhhCA49N1hf6m6cs8lGv5DNVsFlhXR9ykh6BqCNUtyvGNOzjySlcsWWHpYe1VBU=@protonmail.com>
Face: iVBORw0KGgoAAAANSUhEUgAAADAAAAAwBAMAAAClLOS0AAAABGdBTUEAALGPC/xhBQAAACBj
 SFJNAAB6JgAAgIQAAPoAAACA6AAAdTAAAOpgAAA6mAAAF3CculE8AAAAFVBMVEUyJSqZZV+wgnnL
 pp/x29L9+/n///+noQVCAAAAAWJLR0QGYWa4fQAAAAd0SU1FB+YHAwo5HyJHJFgAAAGiSURBVDjL
 lZRbdoQgDIYJMwswOH0XnL5XoAtoxRUU9r+VJtxG7cxD4zkc5DPwJyQK8W8DRIThCUBjjNKY7cDN
 7MiMRkPPHtBqCIGQM4o8AAYonoFtC6tz+uAgPK+nQOSkgEFKMTidX+X8IaRbaKbuWyKw2uIAoITE
 iaejZ5dV17AmOWiVgRgdoeogQKMEXb9CAssjEQqmqu9Gqj6aGDUabOCdTm8AII/l5XMH8mZtxnq/
 NHQy1YlMDOpnktS1FFwZ/BR96CY6oJIbg8iBoLI5AnycTcmyg2pBFnBJxaKdrSkOeQRfQbJ0Z7wh
 lJuctwboGku+C+jrlGHlVxzAmOEMNFK9zEWZSGlPlJ1dLZY9SMFzURTVWzqi1dbw/oIaZngJthfA
 n4DrZdFSEotiZ9p1yOoSs2+ryJ52Am7jI9zUwXuLm4q1lypf/VtPiCcH3Y9YPxtYxtXZ3m+X4HsI
 aHbdI8O9rG8xLMr0nQS4cStqQ/pG3LUb5kDigrcYTm04hshtcKXxCIjYPAZ7AiKX2oWjEE+MysPR
 XpBr+ECoy0z5qyjEXx1Skfhmv1qVAAAAJXRFWHRkYXRlOmNyZWF0ZQAyMDIyLTA3LTAzVDEwOjU3
 OjMxKzAwOjAwZ0bK0QAAACV0RVh0ZGF0ZTptb2RpZnkAMjAyMi0wNy0wM1QxMDo1NzozMSswMDow
 MBYbcm0AAAAASUVORK5CYII=
X-Now-Playing: Eurythmics's _1984 (For The Love Of Big Brother)_:
 "Doubleplusgood"
Date: Tue, 05 Jul 2022 13:16:44 +0200
Message-ID: <87let76c83.fsf@HIDDEN>
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:  Michael Mauger <mmauger@HIDDEN> writes: > I think
 the fix got pushed to 27 but I never cherry-picked it for 28. I think all
 fixes to Emacs 27 should have been included in Emacs 28 automatically... 
 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-BeenThere: debbugs-submit <at> debbugs.gnu.org
X-Mailman-Version: 2.1.18
Precedence: list
List-Id: <debbugs-submit.debbugs.gnu.org>
List-Unsubscribe: <https://debbugs.gnu.org/cgi-bin/mailman/options/debbugs-submit>, 
 <mailto:debbugs-submit-request <at> debbugs.gnu.org?subject=unsubscribe>
List-Archive: <https://debbugs.gnu.org/cgi-bin/mailman/private/debbugs-submit/>
List-Post: <mailto:debbugs-submit <at> debbugs.gnu.org>
List-Help: <mailto:debbugs-submit-request <at> debbugs.gnu.org?subject=help>
List-Subscribe: <https://debbugs.gnu.org/cgi-bin/mailman/listinfo/debbugs-submit>, 
 <mailto:debbugs-submit-request <at> debbugs.gnu.org?subject=subscribe>
Errors-To: debbugs-submit-bounces <at> debbugs.gnu.org
Sender: "Debbugs-submit" <debbugs-submit-bounces <at> debbugs.gnu.org>
X-Spam-Score: -3.3 (---)

Michael Mauger <mmauger@HIDDEN> writes:

> I think the fix got pushed to 27 but I never cherry-picked it for 28.

I think all fixes to Emacs 27 should have been included in Emacs 28
automatically... 

-- 
(domestic pets only, the antidote for overdose, milk.)
   bloggy blog: http://lars.ingebrigtsen.no

Last modified: Tue, 5 Jul 2022 11:30:02 UTC

GNU bug tracking system
Copyright (C) 1999 Darren O. Benham, 1997 nCipher Corporation Ltd, 1994-97 Ian Jackson.