dblink_exec: can it perform a remote function?

[Thiemo Kellner <thiemo@xxxxxxxxxxxxxxxxxxxx>]

Hi all

I am trying to execute a function on a remote server using dblink to 
test stuff.

My function is:
create or replace function /*LOGGER.*/WARN(in P_MESSAGE text)
   returns void as
$warn$
begin
      raise debug     '%', P_MESSAGE;
      raise log       '%', P_MESSAGE;
      raise info      '%', P_MESSAGE;
      raise notice    '%', P_MESSAGE;
      raise warning   '%', P_MESSAGE;
end;
$warn$ language PLPGSQL;

I try to execute it with:
do language PLPGSQL
$anonymous$
begin
      set session client_min_messages to log;
      perform dblink_connect_u('pragma','dbname=thiemo password=XXX');
      perform dblink_exec('pragma','perform WARN(P_MESSAGE := ''Raise 
dblink test'');');
      perform dblink_exec('pragma','commit;');
      perform dblink_disconnect('pragma');
end;
$anonymous$

I get the error:
psql:test_02.sql:22: ERROR:  syntax error at or near "perform"
CONTEXT:  Error occurred on dblink connection named "pragma": could not 
execute command.
SQL statement "SELECT dblink_exec('pragma','perform WARN(P_MESSAGE := 
''Raise dblink test'');')"
PL/pgSQL function inline_code_block line 12 at PERFORM

If I try to execute it with:
do language PLPGSQL
$anonymous$
begin
      set session client_min_messages to log;
      perform dblink_connect_u('pragma','dbname=thiemo password=XXX');
      perform dblink_exec('pragma','select WARN(P_MESSAGE := ''Raise 
dblink test'');');
      perform dblink_exec('pragma','commit;');
      perform dblink_disconnect('pragma');
end;
$anonymous$

Isn't it possible to execute funtions through dblink? Any hint is 
appreciated.

Kind regards

Thiemo

--
Auf Gelassene Pferde kann man bauen!
+49 (0)1578-772 37 37
+41 (0)78 947 36 21
SIP/iptel.org: thiemo.kellner
http://www.gelassene-pferde.biz
Mitglied bei http://www.keep-it-natural.org
Öffentlicher PGP-Schlüssel:
http://pgp.mit.edu/pks/lookup?op=get&search=0x8F70EFD2D972CBEF

begin:vcard
fn:Thiemo Kellner
n:Kellner;Thiemo
adr:;;Landstr. 34;Weilheim-Bannholz;BW;79809;Deutschland
email;internet:thiemo@xxxxxxxxxxxxxxxxxxxx
tel;work:+49 1578 772 37 37
tel;cell:+41 78 947 36 21
note;quoted-printable:Auf Gelassene Pferde kann man bauen!=0D=0A=
	+49 (0)1578-772 37 37 (Mo, Di)=0D=0A=
	+41 (0)78 947 36 21 (Mi - Fr)=0D=0A=
	sip: thiemo.kellner@xxxxxxxxx=0D=0A=
	Skype: thiemo.kellner=0D=0A=
	http://www.gelassene-pferde.biz=0D=0A=
	Mitglied bei http://www.keep-it-natural.org=0D=0A=
	=C3=96ffentlicher PGP-Schl=C3=BCssel: http://pgp.mit.edu/pks/lookup?op=3D=
	get&search=3D0x8F70EFD2D972CBEF
x-mozilla-html:FALSE
url:http://www.gelassene-pferde.biz
version:2.1
end:vcard

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general