Thread: Cancelling a command.

Cancelling a command.

From
"Hargobind Singh"
Date:
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
--------------------------


Re: Cancelling a command.

From
Richard Huxton
Date:
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


Re: Cancelling a command.

From
Richard Huxton
Date:
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


Re: Cancelling a command.

From
"Hargobind Singh"
Date:
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


Re: Cancelling a command.

From
Richard Huxton
Date:
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