Movatterモバイル変換

dblink_error_message

dblink_error_message — gets last error message on the named connection

Synopsis

dblink_error_message(text connname) returns text

Description

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

Arguments

Return Value

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

Notes

When asynchronous queries are initiated bydblink_send_query, the error message associated with the connection might not get updated until the server's response message is consumed. This typically means thatdblink_is_busy ordblink_get_result should be called prior todblink_error_message, so that any error generated by the asynchronous query will be visible.

Examples

SELECT dblink_error_message('dtest1');