| Lists: | pgadmin-support |
|---|
| From: | "Jander" <jander(at)tecsoft(dot)com(dot)br> |
|---|---|
| To: | <pgadmin-support(at)postgresql(dot)org> |
| Subject: | interrupting a SQL query |
| Date: | 2004-04-29 17:16:56 |
| Message-ID: | [email protected] |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Lists: | pgadmin-support |
Hi.
I have an application in Kylix 2. In this application there is some reports.
I need to allow the user interrupt the process SQL query.
Example: The user press key "F6" to start de process SQL query. Now, he
needs to interrupt the process because it is slowly.
How Can i do this?
Please, help me.
Thanks.
Jander Rebelo Luiz
Analista de Sistemas
tecSOFT - Tecnologia em Sistemas
jander(at)tecsoft(dot)com(dot)br
Fone - (48) 3025.2861
| From: | Andreas Pflug <pgadmin(at)pse-consulting(dot)de> |
|---|---|
| To: | Jander <jander(at)tecsoft(dot)com(dot)br> |
| Cc: | pgadmin-support(at)postgresql(dot)org |
| Subject: | Re: interrupting a SQL query |
| Date: | 2004-05-02 18:36:51 |
| Message-ID: | [email protected] |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Lists: | pgadmin-support |
Jander wrote:
> Hi.
>
> I have an application in Kylix 2. In this application there is some
> reports.
> I need to allow the user interrupt the process SQL query.
>
> Example: The user press key "F6" to start de process SQL query. Now, he
> needs to interrupt the process because it is slowly.
You're on the wrong list; this is for pgadmin3 only.
In fact, this question isn't pgsql specific at all, it applies to all db
access.
You can analyze pgadmin3 to learn how to do that, in short: execute the
query in a thread, which can be cancelled.
Regards,
Andreas