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