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
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
