pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedBreak a Report in Run Time
5+ messages / 4 participants
[nested] [flat]
* Break a Report in Run Time
@ 2004-03-10 14:29 Jander Rebelo Luiz <jander@tecsoft.com.br>
0 siblings, 0 replies; 5+ messages in thread
From: Jander Rebelo Luiz @ 2004-03-10 14:29 UTC (permalink / raw)
To: pgsql-sql
I have a apllication with a lot of reports, where I need to break a
process report in run time. How Can I do this?
Thanks.
Jander.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Break a report in Run Time
@ 2004-03-10 18:23 Jander <jander@tecsoft.com.br>
0 siblings, 1 reply; 5+ messages in thread
From: Jander @ 2004-03-10 18:23 UTC (permalink / raw)
To: pgsql-sql
I have a application with a lof of reports. I need to break a report in Run Time.
How can I do this?
Thanks.
Jander Rebelo Luiz
Analista de Sistemas
tecSOFT - Tecnologia em Sistemas
jander@tecsoft.com.br
Fone - (48) 3025.2861
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Break a report in Run Time
@ 2004-03-10 22:09 Jonathan Gardner <jgardner@jonathangardner.net>
parent: Jander <jander@tecsoft.com.br>
0 siblings, 1 reply; 5+ messages in thread
From: Jonathan Gardner @ 2004-03-10 22:09 UTC (permalink / raw)
To: Jander <jander@tecsoft.com.br>; +Cc: pgsql-sql
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Break a report in Run Time
@ 2004-03-11 16:22 Jonathan M. Gardner <jgardner@jonathangardner.net>
parent: Jonathan Gardner <jgardner@jonathangardner.net>
0 siblings, 1 reply; 5+ messages in thread
From: Jonathan M. Gardner @ 2004-03-11 16:22 UTC (permalink / raw)
To: Jander <jander@tecsoft.com.br>; +Cc: pgsql-sql
-----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-----
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Break a report in Run Time
@ 2004-03-11 20:14 Jonathan Gardner <jgardner@jonathangardner.net>
parent: Jonathan M. Gardner <jgardner@jonathangardner.net>
0 siblings, 0 replies; 5+ messages in thread
From: Jonathan Gardner @ 2004-03-11 20:14 UTC (permalink / raw)
To: Jander <jander@tecsoft.com.br>; +Cc: pgsql-sql
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
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2004-03-11 20:14 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-03-10 14:29 Break a Report in Run Time Jander Rebelo Luiz <jander@tecsoft.com.br>
2004-03-10 18:23 Break a report in Run Time Jander <jander@tecsoft.com.br>
2004-03-10 22:09 ` Re: Break a report in Run Time Jonathan Gardner <jgardner@jonathangardner.net>
2004-03-11 16:22 ` Re: Break a report in Run Time Jonathan M. Gardner <jgardner@jonathangardner.net>
2004-03-11 20:14 ` Re: Break a report in Run Time Jonathan Gardner <jgardner@jonathangardner.net>
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