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