Postgresql 中文操作指南

dblink_cancel_query

dblink_cancel_query — 取消在指定连接上的任何活动查询

dblink_cancel_query — cancels any active query on the named connection

Synopsis

dblink_cancel_query(text connname) returns text

Description

dblink_cancel_query 尝试取消在指定连接上正在进行的查询。请注意，这不确定会成功（例如，远程查询可能已完成）。取消请求只是提高查询很快会失败的几率。您仍必须完成常规查询协议，例如通过调用 dblink_get_result 完成。

dblink_cancel_query attempts to cancel any query that is in progress on the named connection. Note that this is not certain to succeed (since, for example, the remote query might already have finished). A cancel request simply improves the odds that the query will fail soon. You must still complete the normal query protocol, for example by calling dblink_get_result.

Arguments

  • connname

    • Name of the connection to use.

Return Value

如果取消请求已发送，则返回 OK ；如果失败，则返回错误消息的文本。

Returns OK if the cancel request has been sent, or the text of an error message on failure.

Examples

SELECT dblink_cancel_query('dtest1');