From: Phil Sainty <psainty@orcon.net.nz>
To: 22016@debbugs.gnu.org
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 [thread overview]
Message-ID: <5656D63C.5090402@orcon.net.nz> (raw)
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))
next reply other threads:[~2015-11-26 9:51 UTC|newest]
Thread overview: 3+ messages / expand[flat|nested] mbox.gz Atom feed top
2015-11-26 9:51 Phil Sainty [this message]
2019-10-09 5:22 ` bug#22016: 25.0.50; sql-interactive-mode prompts and header alignment in query output Lars Ingebrigtsen
2019-10-09 21:50 ` Phil Sainty
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
Avoid top-posting and favor interleaved quoting:
https://en.wikipedia.org/wiki/Posting_style#Interleaved_style
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=5656D63C.5090402@orcon.net.nz \
--to=psainty@orcon.net.nz \
--cc=22016@debbugs.gnu.org \
/path/to/YOUR_REPLY
https://kernel.org/pub/software/scm/git/docs/git-send-email.html
* If your mail client supports setting the In-Reply-To header
via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line
before the message body.
Code repositories for project(s) associated with this external index
https://git.savannah.gnu.org/cgit/emacs.git
https://git.savannah.gnu.org/cgit/emacs/org-mode.git
This is an external index of several public inboxes,
see mirroring instructions on how to clone and mirror
all data and code used by this external index.