---
title: "dblink_error_message"
id: contrib-dblink-error-message
pg_version: "20devel"
---

<a id="contrib-dblink-error-message"></a>

# dblink_error_message — gets last error message on the named connection

## Synopsis

```
dblink_error_message(text connname) returns text
```

<a id="id-1.11.7.21.16.5"></a>

## Description

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

<a id="id-1.11.7.21.16.6"></a>

## Arguments

**`connname`**

 Name of the connection to use. <a id="id-1.11.7.21.16.7"></a>

## Return Value

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

<a id="id-1.11.7.21.16.8"></a>

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

<a id="id-1.11.7.21.16.9"></a>

## Examples


SELECT dblink_error_message('dtest1');