pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Re: use of arrow keys to traverse history
7+ messages / 5 participants
[nested] [flat]

* use of arrow keys to traverse history
@ 2001-04-25 18:42 ` Peter J. Schoenster <borg@errorcode.com>
  2001-04-25 18:13   ` Re: use of arrow keys to traverse history Andrew Perrin <andrew_perrin@unc.edu>
  2001-04-25 22:08   ` Re: use of arrow keys to traverse history Grant <grant@conprojan.com.au>
  1 sibling, 2 replies; 7+ messages in thread

From: Peter J. Schoenster @ 2001-04-25 18:42 UTC (permalink / raw)
  To: pgsql-sql

Hi,

Not sure where this question belongs ... I thought postgresql was 
running under the bash shell where I can use up and down arrow 
keys to traverse my command history. I can do this in mysql but 
oddly not in oracle or postgresql.  

/home/postgres

-rw-r--r--   1 postgres postgres     1422 Feb 16 15:50 .Xdefaults
-rw-------   1 postgres postgres      458 Feb 17 16:59 .bash_history
-rw-r--r--   1 postgres postgres       24 Feb 16 15:50 .bash_logout
-rw-r--r--   1 postgres postgres      230 Feb 16 15:50 .bash_profile
-rw-r--r--   1 postgres postgres      313 Feb 17 16:36 .bashrc

Which in my ignorance leads me to believe that postgres will run in 
the bash shell and so I expect the use of arrow keys or command 
history.

Clues appreciated.

Peter

---------------------------
"Reality is that which, when you stop believing in it, doesn't go
away".
                -- Philip K. Dick



^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: use of arrow keys to traverse history
  2001-04-25 18:42 ` use of arrow keys to traverse history Peter J. Schoenster <borg@errorcode.com>
@ 2001-04-25 18:13   ` Andrew Perrin <andrew_perrin@unc.edu>
  1 sibling, 0 replies; 7+ messages in thread

From: Andrew Perrin @ 2001-04-25 18:13 UTC (permalink / raw)
  To: borg@errorcode.com; +Cc: pgsql-sql

These do suggest (although not require) that the *user* postgres will be
running bash when logged in. To check for sure, do:

finger postgres

which will give you the current shell among other things.

However, this doesn't speak to what I think you're asking, which is
command history and completion within psql (the program), not postgres
(the user).  If that's what you want, you have to compile psql with gnu
readline support, which means you also have to have the gnu readline
libraries available on your machine.

Andy Perrin

"Peter J. Schoenster" wrote:
> 
> Hi,
> 
> Not sure where this question belongs ... I thought postgresql was
> running under the bash shell where I can use up and down arrow
> keys to traverse my command history. I can do this in mysql but
> oddly not in oracle or postgresql.
> 
> /home/postgres
> 
> -rw-r--r--   1 postgres postgres     1422 Feb 16 15:50 .Xdefaults
> -rw-------   1 postgres postgres      458 Feb 17 16:59 .bash_history
> -rw-r--r--   1 postgres postgres       24 Feb 16 15:50 .bash_logout
> -rw-r--r--   1 postgres postgres      230 Feb 16 15:50 .bash_profile
> -rw-r--r--   1 postgres postgres      313 Feb 17 16:36 .bashrc
> 
> Which in my ignorance leads me to believe that postgres will run in
> the bash shell and so I expect the use of arrow keys or command
> history.
> 
> Clues appreciated.
> 
> Peter
> 
> ---------------------------
> "Reality is that which, when you stop believing in it, doesn't go
> away".
>                 -- Philip K. Dick
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

-- 
--------------------------------------------------------------
Andrew J. Perrin - Programmer/Analyst, Desktop Support
Children's Primary Care Research Group, UNC - Chapel Hill
(919)966-9394 * andrew_perrin@unc.edu



^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: use of arrow keys to traverse history
  2001-04-25 18:42 ` use of arrow keys to traverse history Peter J. Schoenster <borg@errorcode.com>
@ 2001-04-25 22:08   ` Grant <grant@conprojan.com.au>
  2001-04-25 16:12     ` Re: use of arrow keys to traverse history Martín Marqués <martin@bugs.unl.edu.ar>
  1 sibling, 1 reply; 7+ messages in thread

From: Grant @ 2001-04-25 22:08 UTC (permalink / raw)
  To: pgsql-sql

I am finding that I can't use the cursor keys at all in psql after I
upgraded to v7.1. I have installed v7.1 on redhat 7.1, mandrake 7.2,
redhat 6.2 and none of them allow me to use the cursors keys, where as
v7.0.3 did. I haven't changed anything on the system except upgrade
postgresql to v7.1. Any ideas?

Thanks.

On Wed, 25 Apr 2001, Peter J. Schoenster wrote:

> Hi,
> 
> Not sure where this question belongs ... I thought postgresql was 
> running under the bash shell where I can use up and down arrow 
> keys to traverse my command history. I can do this in mysql but 
> oddly not in oracle or postgresql.  
> 
> /home/postgres
> 
> -rw-r--r--   1 postgres postgres     1422 Feb 16 15:50 .Xdefaults
> -rw-------   1 postgres postgres      458 Feb 17 16:59 .bash_history
> -rw-r--r--   1 postgres postgres       24 Feb 16 15:50 .bash_logout
> -rw-r--r--   1 postgres postgres      230 Feb 16 15:50 .bash_profile
> -rw-r--r--   1 postgres postgres      313 Feb 17 16:36 .bashrc
> 
> Which in my ignorance leads me to believe that postgres will run in 
> the bash shell and so I expect the use of arrow keys or command 
> history.
> 
> Clues appreciated.
> 
> Peter




^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: use of arrow keys to traverse history
  2001-04-25 18:42 ` use of arrow keys to traverse history Peter J. Schoenster <borg@errorcode.com>
  2001-04-25 22:08   ` Re: use of arrow keys to traverse history Grant <grant@conprojan.com.au>
@ 2001-04-25 16:12     ` Martín Marqués <martin@bugs.unl.edu.ar>
  2001-04-25 22:16       ` Re: use of arrow keys to traverse history Grant <grant@conprojan.com.au>
  0 siblings, 1 reply; 7+ messages in thread

From: Martín Marqués @ 2001-04-25 16:12 UTC (permalink / raw)
  To: Grant <grant@conprojan.com.au>; pgsql-sql

On Jue 26 Abr 2001 01:08, Grant wrote:
> I am finding that I can't use the cursor keys at all in psql after I
> upgraded to v7.1. I have installed v7.1 on redhat 7.1, mandrake 7.2,
> redhat 6.2 and none of them allow me to use the cursors keys, where as
> v7.0.3 did. I haven't changed anything on the system except upgrade
> postgresql to v7.1. Any ideas?

That's because your version (talking about binaries) are not compiled with 
readline support. :-)

Saludos... :-)

-- 
El mejor sistema operativo es aquel que te da de comer.
Cuida tu dieta.
-----------------------------------------------------------------
Martin Marques                  |        mmarques@unl.edu.ar
Programador, Administrador      |       Centro de Telematica
                       Universidad Nacional
                            del Litoral
-----------------------------------------------------------------



^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: use of arrow keys to traverse history
  2001-04-25 18:42 ` use of arrow keys to traverse history Peter J. Schoenster <borg@errorcode.com>
  2001-04-25 22:08   ` Re: use of arrow keys to traverse history Grant <grant@conprojan.com.au>
  2001-04-25 16:12     ` Re: use of arrow keys to traverse history Martín Marqués <martin@bugs.unl.edu.ar>
@ 2001-04-25 22:16       ` Grant <grant@conprojan.com.au>
  2001-04-26 13:50         ` Re: use of arrow keys to traverse history Martín Marqués <martin@bugs.unl.edu.ar>
  0 siblings, 1 reply; 7+ messages in thread

From: Grant @ 2001-04-25 22:16 UTC (permalink / raw)
  To: pgsql-sql

> That's because your version (talking about binaries) are not compiled with 
> readline support. :-)

Which binaries are not compiled with readline support? 

Why did this change from 7.0.3 -> 7.1?

Thanks.




^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: use of arrow keys to traverse history
  2001-04-25 18:42 ` use of arrow keys to traverse history Peter J. Schoenster <borg@errorcode.com>
  2001-04-25 22:08   ` Re: use of arrow keys to traverse history Grant <grant@conprojan.com.au>
  2001-04-25 16:12     ` Re: use of arrow keys to traverse history Martín Marqués <martin@bugs.unl.edu.ar>
  2001-04-25 22:16       ` Re: use of arrow keys to traverse history Grant <grant@conprojan.com.au>
@ 2001-04-26 13:50         ` Martín Marqués <martin@bugs.unl.edu.ar>
  0 siblings, 0 replies; 7+ messages in thread

From: Martín Marqués @ 2001-04-26 13:50 UTC (permalink / raw)
  To: pgsql-sql

On Jue 26 Abr 2001 01:16, Grant wrote:
> > That's because your version (talking about binaries) are not compiled
> > with readline support. :-)
>
> Which binaries are not compiled with readline support?
>
> Why did this change from 7.0.3 -> 7.1?

I don't have the slightest idea.
Are you on rpms? If so, download the src.rpm and check the SPEC file for the 
config options, and then compile with rpm --rebuild <package>

Saludos... :-)

-- 
El mejor sistema operativo es aquel que te da de comer.
Cuida tu dieta.
-----------------------------------------------------------------
Martin Marques                  |        mmarques@unl.edu.ar
Programador, Administrador      |       Centro de Telematica
                       Universidad Nacional
                            del Litoral
-----------------------------------------------------------------



^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: use of arrow keys to traverse history
@ 2001-04-25 19:17 ` Dorin Grunberg <dorin@visgen.com>
  1 sibling, 0 replies; 7+ messages in thread

From: Dorin Grunberg @ 2001-04-25 19:17 UTC (permalink / raw)
  To: borg@errorcode.com; pgsql-sql

You need to install Readline library. I know I used readline 4.1 and it 
works great.

Dorin


At 12:42 PM 4/25/2001 -0600, Peter J. Schoenster wrote:
>Hi,
>
>Not sure where this question belongs ... I thought postgresql was
>running under the bash shell where I can use up and down arrow
>keys to traverse my command history. I can do this in mysql but
>oddly not in oracle or postgresql.
>
>/home/postgres
>
>-rw-r--r--   1 postgres postgres     1422 Feb 16 15:50 .Xdefaults
>-rw-------   1 postgres postgres      458 Feb 17 16:59 .bash_history
>-rw-r--r--   1 postgres postgres       24 Feb 16 15:50 .bash_logout
>-rw-r--r--   1 postgres postgres      230 Feb 16 15:50 .bash_profile
>-rw-r--r--   1 postgres postgres      313 Feb 17 16:36 .bashrc
>
>Which in my ignorance leads me to believe that postgres will run in
>the bash shell and so I expect the use of arrow keys or command
>history.
>
>Clues appreciated.
>
>Peter
>
>---------------------------
>"Reality is that which, when you stop believing in it, doesn't go
>away".
>                 -- Philip K. Dick
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org




^ permalink  raw  reply  [nested|flat] 7+ messages in thread


end of thread, other threads:[~2001-04-26 13:50 UTC | newest]

Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-04-25 18:42 ` Peter J. Schoenster <borg@errorcode.com>
2001-04-25 18:13   ` Andrew Perrin <andrew_perrin@unc.edu>
2001-04-25 22:08   ` Grant <grant@conprojan.com.au>
2001-04-25 16:12     ` Martín Marqués <martin@bugs.unl.edu.ar>
2001-04-25 22:16       ` Grant <grant@conprojan.com.au>
2001-04-26 13:50         ` Martín Marqués <martin@bugs.unl.edu.ar>
2001-04-25 19:17 ` Dorin Grunberg <dorin@visgen.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox