pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jonathan M. Gardner <jgardner@jonathangardner.net>
To: Jander <jander@tecsoft.com.br>
Cc: pgsql-sql@postgresql.org
Subject: Re: Break a report in Run Time
Date: Thu, 11 Mar 2004 08:22:01 -0800
Message-ID: <200403110822.06241.jgardner@jonathangardner.net> (raw)
In-Reply-To: <001701c4078b$dccbaa40$7a02a8c0@local.tecsoft.com.br>
References: <002c01c406cc$be329ea0$7a02a8c0@local.tecsoft.com.br>
	<200403101409.08124.jgardner@jonathangardner.net>
	<001701c4078b$dccbaa40$7a02a8c0@local.tecsoft.com.br>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Thursday 11 March 2004 9:11 am, Jander wrote:
>              I need to abort the SQL process running in DB Server.
>

If you are in psql, you can cancel any query with CTRL-C. Otherwise, you 
can kill the process running the query using the "kill" command. If that 
doesn't work you can kill (but not -9!) the backend process handling your 
query.

>
> ----- Original Message -----
> From: "Jonathan Gardner" <jgardner@jonathangardner.net>
> To: "Jander" <jander@tecsoft.com.br>
> Cc: <pgsql-sql@postgresql.org>
> Sent: Wednesday, March 10, 2004 6:09 PM
> Subject: Re: [SQL] Break a report in Run Time
>
> > On Wednesday 10 March 2004 10:23 am, Jander wrote:
> > >                I have a application with a lof of reports. I need
> > > to break a report in Run Time. How can I do this?
> >
> > Could you clarify what you mean by "break a report in run time"?
> >
> > --
> > Jonathan Gardner
> > jgardner@jonathangardner.net
> >
> > ---------------------------(end of
> > broadcast)--------------------------- TIP 4: Don't 'kill -9' the
> > postmaster

- -- 
Jonathan Gardner
jgardner@jonathangardner.net
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (GNU/Linux)

iD8DBQFAUJIpqp6r/MVGlwwRAi8eAJ4q9UHzimQtlR3I+XdGICvfF8ZfbgCdHU6q
77RNJ+5WBwAwrZ1pbD+7meg=
=BsCQ
-----END PGP SIGNATURE-----



view thread (5+ messages)  latest in thread

Message-ID: <200403110822.06241.jgardner@jonathangardner.net>
Permalink:  ../200403110822.06241.jgardner@jonathangardner.net/
Also on:    postgresql.org/message-id/200403110822.06241.jgardner@jonathangardner.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: jgardner@jonathangardner.net, jander@tecsoft.com.br
  Subject: Re: Break a report in Run Time
  In-Reply-To: <200403110822.06241.jgardner@jonathangardner.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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