Обсуждение: 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

-----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-----

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