Re: cannot get error message after dblink_exec execution

Sofer, Yuval wrote:
> last_message := dblink_error_message('dbname=postgres
> user=postgres password=manager') ;

> Am I not using dblink_error_message correctly?

Yes, you are not using dblink_error_message correctly. From the docs:

==================================================================
Name

dblink_error_message -- gets last error message on the named connection

Synopsis

dblink_error_message(text connname) RETURNS text

Inputs

connname
The specific connection name to use.

Outputs

Returns last error message.

Example usage

SELECT dblink_error_message('dtest1');
==================================================================

It requires a named connection, you are trying to use an anonymous one.

HTH,

Joe