dblink_exec: can it perform a remote function?
От | Thiemo Kellner |
---|---|
Тема | dblink_exec: can it perform a remote function? |
Дата | |
Msg-id | 56F12D83.9040102@gelassene-pferde.biz обсуждение исходный текст |
Ответы |
Re: dblink_exec: can it perform a remote function?
|
Список | pgsql-general |
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
Вложения
В списке pgsql-general по дате отправления: