From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.org!not-for-mail From: Phil Sainty Newsgroups: gmane.emacs.bugs Subject: bug#22016: 25.0.50; sql-interactive-mode prompts and header alignment in query output Date: Thu, 26 Nov 2015 22:51:56 +1300 Message-ID: <5656D63C.5090402@orcon.net.nz> NNTP-Posting-Host: plane.gmane.org Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit X-Trace: ger.gmane.org 1448533470 20498 80.91.229.3 (26 Nov 2015 10:24:30 GMT) X-Complaints-To: usenet@ger.gmane.org NNTP-Posting-Date: Thu, 26 Nov 2015 10:24:30 +0000 (UTC) To: 22016@debbugs.gnu.org Original-X-From: bug-gnu-emacs-bounces+geb-bug-gnu-emacs=m.gmane.org@gnu.org Thu Nov 26 11:24:16 2015 Return-path: Envelope-to: geb-bug-gnu-emacs@m.gmane.org Original-Received: from lists.gnu.org ([208.118.235.17]) by plane.gmane.org with esmtp (Exim 4.69) (envelope-from ) id 1a1tij-0002QE-OO for geb-bug-gnu-emacs@m.gmane.org; Thu, 26 Nov 2015 11:24:10 +0100 Original-Received: from localhost ([::1]:50279 helo=lists.gnu.org) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1a1til-0006DK-Qr for geb-bug-gnu-emacs@m.gmane.org; Thu, 26 Nov 2015 05:24:11 -0500 Original-Received: from eggs.gnu.org ([2001:4830:134:3::10]:33853) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1a1tig-0006AK-Ez for bug-gnu-emacs@gnu.org; Thu, 26 Nov 2015 05:24:07 -0500 Original-Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1a1tic-0006ZG-DR for bug-gnu-emacs@gnu.org; Thu, 26 Nov 2015 05:24:06 -0500 Original-Received: from debbugs.gnu.org ([208.118.235.43]:35501) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1a1tic-0006ZC-9t for bug-gnu-emacs@gnu.org; Thu, 26 Nov 2015 05:24:02 -0500 Original-Received: from Debian-debbugs by debbugs.gnu.org with local (Exim 4.80) (envelope-from ) id 1a1tic-0005MV-0U for bug-gnu-emacs@gnu.org; Thu, 26 Nov 2015 05:24:02 -0500 X-Loop: help-debbugs@gnu.org Resent-From: Phil Sainty Original-Sender: "Debbugs-submit" Resent-CC: bug-gnu-emacs@gnu.org Resent-Date: Thu, 26 Nov 2015 10:24:01 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: report 22016 X-GNU-PR-Package: emacs X-GNU-PR-Keywords: X-Debbugs-Original-To: bug-gnu-emacs@gnu.org Original-Received: via spool by submit@debbugs.gnu.org id=B.144853340420567 (code B ref -1); Thu, 26 Nov 2015 10:24:01 +0000 Original-Received: (at submit) by debbugs.gnu.org; 26 Nov 2015 10:23:24 +0000 Original-Received: from localhost ([127.0.0.1]:53442 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.80) (envelope-from ) id 1a1thz-0005Lc-Av for submit@debbugs.gnu.org; Thu, 26 Nov 2015 05:23:23 -0500 Original-Received: from eggs.gnu.org ([208.118.235.92]:51802) by debbugs.gnu.org with esmtp (Exim 4.80) (envelope-from ) id 1a1thw-0005LN-RK for submit@debbugs.gnu.org; Thu, 26 Nov 2015 05:23:21 -0500 Original-Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1a1thv-000616-HT for submit@debbugs.gnu.org; Thu, 26 Nov 2015 05:23:20 -0500 Original-Received: from lists.gnu.org ([2001:4830:134:3::11]:41100) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1a1thv-00060y-E2 for submit@debbugs.gnu.org; Thu, 26 Nov 2015 05:23:19 -0500 Original-Received: from eggs.gnu.org ([2001:4830:134:3::10]:33569) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1a1thu-0005OY-25 for bug-gnu-emacs@gnu.org; Thu, 26 Nov 2015 05:23:19 -0500 Original-Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1a1thq-0005zj-0A for bug-gnu-emacs@gnu.org; Thu, 26 Nov 2015 05:23:18 -0500 Original-Received: from [219.88.242.22] (port=44767 helo=mail.orcon.net.nz) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1a1thp-0005z9-Ff for bug-gnu-emacs@gnu.org; Thu, 26 Nov 2015 05:23:13 -0500 Original-Received: from [10.1.1.2] (202-150-104-7.bng1.avl.orcon.net.nz [202.150.104.7] (may be forged)) (authenticated bits=0) by mail.orcon.net.nz (8.14.3/8.14.3/Debian-9.4) with ESMTP id tAQ9puc0025647 for ; Thu, 26 Nov 2015 22:51:57 +1300 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:38.0) Gecko/20100101 Thunderbird/38.3.0 X-Bayes-Prob: 0.0001 (Score 0: No Bayes scoring rules defined, tokens from: outbound) X-CanIt-Geo: ip=202.150.104.7; country=NZ; region=Wellington; city=Paraparaumu; latitude=-40.9165; longitude=175.0055; http://maps.google.com/maps?q=-40.9165,175.0055&z=6 X-CanItPRO-Stream: base:outbound X-Canit-Stats-ID: 02PK9PU0E - 3841a60e1b03 - 20151126 X-Scanned-By: CanIt (www . roaringpenguin . com) X-detected-operating-system: by eggs.gnu.org: GNU/Linux 3.x X-detected-operating-system: by eggs.gnu.org: Error: Malformed IPv6 address (bad octet value). X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.15 Precedence: list X-detected-operating-system: by eggs.gnu.org: GNU/Linux 3.x X-Received-From: 208.118.235.43 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.org@gnu.org Original-Sender: bug-gnu-emacs-bounces+geb-bug-gnu-emacs=m.gmane.org@gnu.org Xref: news.gmane.org gmane.emacs.bugs:109280 Archived-At: Regarding the following Question and Answer: http://emacs.stackexchange.com/q/13315 http://emacs.stackexchange.com/a/18403 In which multi-line SQL queries can result in output like so: select a, b, c from table1 where a < 10; mydb=> mydb=> mydb-> mydb-> mydb-> a | b | c ----------+--------------+------- 1 | 2015-01-05 | 59120 7 | 2015-01-06 | 59121 3 | 2015-01-07 | 59122 (3 rows) i.e. we get multiple prompts all on a single line (continuations due to the multi-line query), and then the header row for the output is on that same line as well, which means that the column headers don't line up with their data. I'm not sure whether this issue is product-specific. Both parties are using Postgres in this instance. I've hacked together a workaround for both issues in the above-linked answer, and that's doing the trick for me, but it would be great if sql-interaction-mode handled this by default. -Phil In GNU Emacs 25.0.50.1 (x86_64-unknown-linux-gnu, X toolkit, Xaw3d scroll bars) of 2015-10-10 Repository revision: bb7c182fdaf8553ffdc9162f322177ae2f7fa0c2 Windowing system distributor 'The X.Org Foundation', version 11.0.11701000 System Description: Ubuntu 15.04 Configured using: 'configure --prefix=/home/phil/emacs/trunk/usr/local --with-x-toolkit=lucid --without-sound' Configured features: XAW3D XPM JPEG TIFF GIF PNG RSVG IMAGEMAGICK DBUS GSETTINGS NOTIFY GNUTLS LIBXML2 FREETYPE XFT ZLIB TOOLKIT_SCROLL_BARS LUCID X11 Important settings: value of $LANG: en_NZ.UTF-8 value of $XMODIFIERS: @im=ibus locale-coding-system: utf-8-unix Major mode: Lisp Interaction Minor modes in effect: tooltip-mode: t global-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 Recent messages: For information about GNU Emacs and the GNU system, type C-h C-a. funcall-interactively: End of buffer Load-path shadows: None found. Features: (shadow sort gnus-util mail-extr emacsbug message dired format-spec rfc822 mml mml-sec mm-decode mm-bodies mm-encode mail-parse rfc2231 mailabbrev gmm-utils mailheader sendmail rfc2047 rfc2045 ietf-drums mm-util help-fns help-mode easymenu cl-loaddefs pcase cl-lib mail-prsvr mail-utils time-date mule-util tooltip eldoc electric uniquify ediff-hook vc-hooks lisp-float-type mwheel x-win term/common-win x-dnd tool-bar dnd fontset image regexp-opt fringe tabulated-list newcomment elisp-mode lisp-mode prog-mode register page menu-bar rfn-eshadow timer select scroll-bar mouse jit-lock font-lock syntax facemenu font-core frame 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 charscript case-table epa-hook jka-cmpr-hook help simple abbrev minibuffer cl-preloaded nadvice loaddefs button faces cus-face macroexp files text-properties overlay sha1 md5 base64 format env code-pages mule custom widget hashtable-print-readable backquote dbusbind inotify dynamic-setting system-font-setting font-render-setting x-toolkit x multi-tty make-network-process emacs) Memory information: ((conses 16 80193 6352) (symbols 48 18983 0) (miscs 40 40 125) (strings 32 13139 4407) (string-bytes 1 375848) (vectors 16 10590) (vector-slots 8 411879 8564) (floats 8 135 112) (intervals 56 232 0) (buffers 976 11) (heap 1024 24529 988))