From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.io!.POSTED.blaine.gmane.org!not-for-mail From: Jean Louis Newsgroups: gmane.emacs.bugs Subject: bug#47357: 28.0.50; sql-list-tables: Executing SQL command... takes indefinite time after creation of new table Date: Wed, 24 Mar 2021 10:58:30 +0300 Message-ID: <867dlxnftl.fsf@protected.rcdrun.com> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Injection-Info: ciao.gmane.io; posting-host="blaine.gmane.org:116.202.254.214"; logging-data="12944"; mail-complaints-to="usenet@ciao.gmane.io" To: 47357@debbugs.gnu.org Original-X-From: bug-gnu-emacs-bounces+geb-bug-gnu-emacs=m.gmane-mx.org@gnu.org Wed Mar 24 09:00:11 2021 Return-path: Envelope-to: geb-bug-gnu-emacs@m.gmane-mx.org Original-Received: from lists.gnu.org ([209.51.188.17]) by ciao.gmane.io with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lOyR1-00039D-8t for geb-bug-gnu-emacs@m.gmane-mx.org; Wed, 24 Mar 2021 09:00:11 +0100 Original-Received: from localhost ([::1]:49452 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1lOyR0-00042z-A3 for geb-bug-gnu-emacs@m.gmane-mx.org; Wed, 24 Mar 2021 04:00:10 -0400 Original-Received: from eggs.gnu.org ([2001:470:142:3::10]:55484) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1lOyQs-00042o-IM for bug-gnu-emacs@gnu.org; Wed, 24 Mar 2021 04:00:02 -0400 Original-Received: from debbugs.gnu.org ([209.51.188.43]:50536) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1lOyQs-0004ox-6k for bug-gnu-emacs@gnu.org; Wed, 24 Mar 2021 04:00:02 -0400 Original-Received: from Debian-debbugs by debbugs.gnu.org with local (Exim 4.84_2) (envelope-from ) id 1lOyQs-0005ZB-4k for bug-gnu-emacs@gnu.org; Wed, 24 Mar 2021 04:00:02 -0400 X-Loop: help-debbugs@gnu.org Resent-From: Jean Louis Original-Sender: "Debbugs-submit" Resent-CC: bug-gnu-emacs@gnu.org Resent-Date: Wed, 24 Mar 2021 08:00:02 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: report 47357 X-GNU-PR-Package: emacs X-Debbugs-Original-To: bug-gnu-emacs@gnu.org Original-Received: via spool by submit@debbugs.gnu.org id=B.161657276221313 (code B ref -1); Wed, 24 Mar 2021 08:00:02 +0000 Original-Received: (at submit) by debbugs.gnu.org; 24 Mar 2021 07:59:22 +0000 Original-Received: from localhost ([127.0.0.1]:33849 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1lOyQE-0005Xg-A1 for submit@debbugs.gnu.org; Wed, 24 Mar 2021 03:59:22 -0400 Original-Received: from lists.gnu.org ([209.51.188.17]:51040) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1lOyQ9-0005XS-VG for submit@debbugs.gnu.org; Wed, 24 Mar 2021 03:59:21 -0400 Original-Received: from eggs.gnu.org ([2001:470:142:3::10]:55330) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1lOyQ9-0003zQ-M4 for bug-gnu-emacs@gnu.org; Wed, 24 Mar 2021 03:59:17 -0400 Original-Received: from stw1.rcdrun.com ([217.170.207.13]:46773) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1lOyQ7-0004Kq-Ln for bug-gnu-emacs@gnu.org; Wed, 24 Mar 2021 03:59:17 -0400 Original-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.00000000605AF13A.00003EB1; Wed, 24 Mar 2021 00:58:49 -0700 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-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list X-BeenThere: bug-gnu-emacs@gnu.org List-Id: "Bug reports for GNU Emacs, the Swiss army knife of text editors" List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: bug-gnu-emacs-bounces+geb-bug-gnu-emacs=m.gmane-mx.org@gnu.org Original-Sender: "bug-gnu-emacs" Xref: news.gmane.io gmane.emacs.bugs:202933 Archived-At: 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