dblink_is_busy (3) - Linux Manuals

dblink_is_busy: checks if connection is busy with an async query

NAME

dblink_is_busy - checks if connection is busy with an async query

SYNOPSIS

dblink_is_busy(text connname) returns int

DESCRIPTION

dblink_is_busy tests whether an async query is in progress.

ARGUMENTS

connname

Name of the connection to check.

RETURN VALUE

Returns 1 if connection is busy, 0 if it is not busy. If this function returns 0, it is guaranteed that dblink_get_result will not block.

EXAMPLES

SELECT dblink_is_busy('dtest1');