dblink_error

dblink_error_message
Prev	Up	F.12. dblink — connect to other PostgreSQL databases	Home	Next

dblink_error_message

F.12. dblink — connect to other PostgreSQL databases

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

connname: + Name of the connection to use. +

Return Value

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

Notes

+ 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. +

Examples

+SELECT dblink_error_message('dtest1');
+