Thread: Cancelling a command.
I am using Postgres 7.2 shipped with redhat 8.0. THe problem is whenever i try to cancel a SQL command by Ctrl + C, the terminal window in which I am working stops responding. And, eventually, I have to force close the terminal window... Any suggestions ? Hargobind Singh --------------------------
On Tuesday 06 May 2003 11:09 am, Hargobind Singh wrote: > I am using Postgres 7.2 shipped with redhat 8.0. THe problem is whenever i > try to cancel a SQL command by Ctrl + C, the terminal window in which I am > working stops responding. And, eventually, I have to force close the > terminal window... Any suggestions ? Which terminal window are we talking about - console, rxvt, gnome, kde? Try a "pstree" or "ps aux" command to see a list of processes. -- Richard Huxton
On Tuesday 06 May 2003 2:49 pm, Hargobind Singh wrote: Please use "reply all" to make sure messages go to the list too - you'll get quicker responses that way. > I have tried on KDE, and GNOME both.. they behave the same. Very odd. Do you get the msg: Cancel request sent ERROR: Query was cancelled. or does the window freeze before this? I'm running RH8 here without any issues, although I'm not using the shipped version of PG. There are three things I can think of: 1. There is a Ctrl-S occurring which is pausing output (use Ctrl-Q to unpause) 2. Something about your locale/font/keyboard settings is confusing RedHat 3. There is a bug in psql Does the problem occur if you're at a text console (the Ctrl-Alt-F1 one)? That should rule out #3. > On Tuesday 06 May 2003 11:09 am, Hargobind Singh wrote: > > I am using Postgres 7.2 shipped with redhat 8.0. THe problem is whenever > > i try to cancel a SQL command by Ctrl + C, the terminal window in which I > > am working stops responding. And, eventually, I have to force close the > > terminal window... Any suggestions ? > > Which terminal window are we talking about - console, rxvt, gnome, kde? Try > a > "pstree" or "ps aux" command to see a list of processes. -- Richard Huxton
The window freezes, and i get no message at all. Hargobind Singh -------------------------- ----- Original Message ----- From: "Richard Huxton" <dev@archonet.com> To: "Hargobind Singh" <hgs@acplexports.com> Cc: <pgsql-general@postgresql.org> Sent: Wednesday, May 07, 2003 12:18 PM Subject: Re: [GENERAL] Cancelling a command. On Tuesday 06 May 2003 2:49 pm, Hargobind Singh wrote: Please use "reply all" to make sure messages go to the list too - you'll get quicker responses that way. > I have tried on KDE, and GNOME both.. they behave the same. Very odd. Do you get the msg: Cancel request sent ERROR: Query was cancelled. or does the window freeze before this? I'm running RH8 here without any issues, although I'm not using the shipped version of PG. There are three things I can think of: 1. There is a Ctrl-S occurring which is pausing output (use Ctrl-Q to unpause) 2. Something about your locale/font/keyboard settings is confusing RedHat 3. There is a bug in psql Does the problem occur if you're at a text console (the Ctrl-Alt-F1 one)? That should rule out #3. > On Tuesday 06 May 2003 11:09 am, Hargobind Singh wrote: > > I am using Postgres 7.2 shipped with redhat 8.0. THe problem is whenever > > i try to cancel a SQL command by Ctrl + C, the terminal window in which I > > am working stops responding. And, eventually, I have to force close the > > terminal window... Any suggestions ? > > Which terminal window are we talking about - console, rxvt, gnome, kde? Try > a > "pstree" or "ps aux" command to see a list of processes. -- Richard Huxton
On Wednesday 07 May 2003 9:01 am, Hargobind Singh wrote: > The window freezes, and i get no message at all. And I'm right in thinking it does this only with psql, not top/man/less etc? How about from the text-only console? It's 11am here, I'll try installing 7.2 rpms on my RH8 machine this afternoon and see if I can reproduce it unless someone comes up with any ideas. -- Richard Huxton