Description

pg_cancelrequest asks the database server to abandon processing of the current command issued by pg_sendquery.

Arguments

Return Value

Nothing. Throws a Tcl error if an error occurs.

Notes

There is no guarantee that the command will actually be canceled. For example, the command may have been completed before the database server can receive and handle the cancel request. If a request is canceled, and you were in the middle of a transaction, the entire transaction is rolled back.

You still need to call pg_getresult repeatedly until it doesn't return anything, and deal with all the returned result handles, usually by freeing them with pg_result -clear.

This command uses or emulates the PostgreSQL libpq function PQrequestCancel.