pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Break 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