X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id 7C38BD1C9ED
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 11 Mar 2004 20:18:41 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 43878-03
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 11 Mar 2004 16:18:39 -0400 (AST)
Received: from dervish.jonathangardner.net (dervish.jonathangardner.net
	[66.92.192.241])
	by svr1.postgresql.org (Postfix) with ESMTP id DDFEFD1B445
	for <pgsql-sql@postgresql.org>; Thu, 11 Mar 2004 16:18:31 -0400 (AST)
Received: from jonagard.desktop.amazon.com (207-171-180-101.amazon.com
	[207.171.180.101]) (authenticated bits=0)
	by dervish.jonathangardner.net (8.12.10/8.12.10) with ESMTP id
	i2BKIfxJ000560
	(version=TLSv1/SSLv3 cipher=RC4-MD5 bits=128 verify=NO);
	Thu, 11 Mar 2004 12:18:41 -0800
From: Jonathan Gardner <jgardner@jonathangardner.net>
To: "Jander" <jander@tecsoft.com.br>
Subject: Re: Break a report in Run Time
Date: Thu, 11 Mar 2004 12:14:45 -0800
User-Agent: KMail/1.6
Cc: pgsql-sql@postgresql.org
References: <002c01c406cc$be329ea0$7a02a8c0@local.tecsoft.com.br>
	<200403110822.06241.jgardner@jonathangardner.net>
	<003201c40793$eb332100$7a02a8c0@local.tecsoft.com.br>
In-Reply-To: <003201c40793$eb332100$7a02a8c0@local.tecsoft.com.br>
MIME-Version: 1.0
Content-Disposition: inline
Content-Type: text/plain;
  charset="windows-1252"
Content-Transfer-Encoding: 7bit
Message-Id: <200403111214.45762.jgardner@jonathangardner.net>
Received-SPF: pass (dervish.jonathangardner.net: sender at 207.171.180.101 was
	authenticated)
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200403/138
X-Sequence-Number: 17237

On Thursday 11 March 2004 10:08 am, Jander wrote:
> I need to abort the SQL process inside my application developed in Kylix.
>

Go read the documentation for Kylix. I don't know the environment at all. I 
do know that if you are calling the query in a blocking manner then the 
only way to stop it is to kill the entire process, or set a timeout or 
something.

> ----- Original Message -----
> From: "Jonathan M. Gardner" <jgardner@jonathangardner.net>
> To: "Jander" <jander@tecsoft.com.br>
> Cc: <pgsql-sql@postgresql.org>
> Sent: Thursday, March 11, 2004 12:22 PM
> Subject: Re: [SQL] Break a report in Run Time
>
> > -----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-----

-- 
Jonathan Gardner
jgardner@jonathangardner.net