Cancelling a database query

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
per
Posts: 2
Joined: Tue 17 Apr 2007 07:34

Cancelling a database query

Post by per » Thu 19 Apr 2007 08:05

Hello,

Is there a way of cancelling a query before it has been completely processed on the server?

I know that it is possible to cancel a query in pgAdmin, but is it possible to do in a controlled manner using "PostgreSQLDirect .NET"?

Regards,
Per

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Thu 19 Apr 2007 08:49

Yes, there is a way. Use PgSqlCommand.Cancel().

Post Reply