Movatterモバイル変換


[0]ホーム

URL:



Facebook
Postgres Pro
Facebook
Downloads
34.6. Canceling Queries in Progress
Prev UpChapter 34. libpq - C LibraryHome Next

34.6. Canceling Queries in Progress

A client application can request cancellation of a command that is still being processed by the server, using the functions described in this section.

PQgetCancel

Creates a data structure containing the information needed to cancel a command issued through a particular database connection.

PGcancel *PQgetCancel(PGconn *conn);

PQgetCancel creates aPGcancel object given aPGconn connection object. It will returnNULL if the givenconn isNULL or an invalid connection. ThePGcancel object is an opaque structure that is not meant to be accessed directly by the application; it can only be passed toPQcancel orPQfreeCancel.

PQfreeCancel

Frees a data structure created byPQgetCancel.

void PQfreeCancel(PGcancel *cancel);

PQfreeCancel frees a data object previously created byPQgetCancel.

PQcancel

Requests that the server abandon processing of the current command.

int PQcancel(PGcancel *cancel, char *errbuf, int errbufsize);

The return value is 1 if the cancel request was successfully dispatched and 0 if not. If not,errbuf is filled with an explanatory error message.errbuf must be a char array of sizeerrbufsize (the recommended size is 256 bytes).

Successful dispatch is no guarantee that the request will have any effect, however. If the cancellation is effective, the current command will terminate early and return an error result. If the cancellation fails (say, because the server was already done processing the command), then there will be no visible result at all.

PQcancel can safely be invoked from a signal handler, if theerrbuf is a local variable in the signal handler. ThePGcancel object is read-only as far asPQcancel is concerned, so it can also be invoked from a thread that is separate from the one manipulating thePGconn object.

PQrequestCancel

PQrequestCancel is a deprecated variant ofPQcancel.

int PQrequestCancel(PGconn *conn);

Requests that the server abandon processing of the current command. It operates directly on thePGconn object, and in case of failure stores the error message in thePGconn object (whence it can be retrieved byPQerrorMessage). Although the functionality is the same, this approach creates hazards for multiple-thread programs and signal handlers, since it is possible that overwriting thePGconn's error message will mess up the operation currently in progress on the connection.


Prev Up Next
34.5. Retrieving Query Results Row-By-Row Home 34.7. The Fast-Path Interface
epubpdf
Go to PostgreSQL 11
By continuing to browse this website, you agree to the use of cookies. Go toPrivacy Policy.

[8]ページ先頭

©2009-2025 Movatter.jp