Re: fix of some issues with multi-line query editing - Mailing list pgsql-patches

From Alvaro Herrera
Subject Re: fix of some issues with multi-line query editing
Date
Msg-id 20060313134212.GC8274@surnet.cl
Whole thread Raw
In response to Re: fix of some issues with multi-line query editing  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-patches
Tom Lane wrote:

> I think this patch is seriously broken, and I don't agree with what it's
> trying to accomplish in the first place --- I still haven't found any
> cases where it's an improvement to pull back multiple lines as one
> history entry.  For example, if you made a mistake on the fifth line of
> a ten-line CREATE TABLE command, the current code makes it extremely
> inconvenient to fix that: you have to back-arrow or forward-arrow
> tediously over five lines, where before you could pull back one line at
> a time and just edir the line that needed fixing.

Huh, I find precisely that behavior very difficult to use; you end up
pressing up-arrow ten times to get the first line, ten times to get the
second line, ten more times to get the third line, up to a total of a
hundred times!  And if you press it nine or eleven times instead of ten
and press "enter" before realizing it (a mistake very easily made), you
are hosed and have to start all over.

Instead of waiting for back-arrow I usually use Alt-b and Alt-f.  Or if
I have to go back 20 words, esc-20 alt-b.  This is much quicker.

(I agree that there are still bugs.  But we should correct those, not
remove the useful behavior.)

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-patches by date:

Previous
From: "Jonah H. Harris"
Date:
Subject: Re: CREATE SYNONYM ...
Next
From: Alvaro Herrera
Date:
Subject: Re: [HACKERS] pg_freespacemap question