Cancelling a database query

Cancelling a database query

Postby 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
per
 
Posts: 2
Joined: Tue 17 Apr 2007 07:34

Postby Alexey » Thu 19 Apr 2007 08:49

Yes, there is a way. Use PgSqlCommand.Cancel().
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43


Return to dotConnect for PostgreSQL