Re: [ADMIN] cannot get error message after dblink_exec execution

2007-08-19 Thread Joe Conway
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: ==

[ADMIN] cannot get error message after dblink_exec execution

2007-08-19 Thread Sofer, Yuval
Hi, I am using DBLink contrib module. I cannot catch the dblink_exec error messages. On the other hand, the pgadmin gui shows the error message under "DETAIL" section: The test function : CREATE OR REPLACE FUNCTION test_func1() RETURNS integer AS $$ DECLARE stmt text; conn