pg_cancelrequest
Prev | 4.4.Asynchronous Query Processing Commands | Next

## pg_cancelrequest

pg_cancelrequest — 進行中の非同期問合せを予約解除する Cancel an in-progress asynchronous query

## 構文 Synopsis

    pg_cancelrequest conn

## 説明 Description

`pg_cancelrequest` はデータベース中央集中処理系にpg_sendqueryによる現在の命令事項の処理を放棄する様依頼する｡ `pg_cancelrequest` asks the database server to abandon processing of the current command issued by pg_sendquery.

## 引数 Arguments

`conn`

  現在の命令を予約解消するべき接続の把持子｡ The handle of the connection on which to cancel the current command.

## 返り値 Return Value

なし､もし不都合が生じるとTcl不都合が発せられる｡ 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.

何かを返し､且つ返された結果把持子を扱う､通常は pg_result-clear によりそれを解放する迄､使用者は繰返し pg_getresult を呼出す必要がある｡ 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`.

この命令は PostgreSQL libpq function `PQrequestCancel`を使い模擬する｡ This command uses or emulates the PostgreSQL libpq function `PQrequestCancel`.

Prev | Up | Next
pg_getresult | Home | pg_blocking