Supported Versions: Current (15) / 14 / 13 / 12 / 11
Development Versions: 16 / devel
Unsupported versions: 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1 / 9.0 / 8.4 / 8.3
This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the current version, or one of the other supported versions listed above instead.



dblink_error_message -- gets last error message on the named connection


dblink_error_message(text connname) returns text


dblink_error_message fetches the most recent remote error message for a given connection.



Name of the connection to use.

Return Value

Returns last error message, or OK if there has been no error in this connection.


When asynchronous queries are initiated by dblink_send_query, the error message associated with the connection might not get updated until the server's response message is consumed. This typically means that dblink_is_busy or dblink_get_result should be called prior to dblink_error_message, so that any error generated by the asynchronous query will be visible.


SELECT dblink_error_message('dtest1');