I have problem with dblink_send_query function on Postgres 9.2.2
This work
do $$
begin
perform dblink.dblink_connect('internal');
perform dblink.dblink_exec('internal', 'set application_name=''dblink'';',
true);
perform dblink.dblink_disconnect();
end;
$$
But this not
do $$
begin
perform dblink.dblink_connect('internal');
perform dblink.dblink_send_query('internal', 'select dummy();');
perform dblink.dblink_disconnect();
end;
$$
I got error
ERROR: connection "internal" not available
SQL state: 08003
Context: SQL statement "SELECT dblink.dblink_send_query('internal', 'select
dummy();')"
PL/pgSQL function inline_code_block line 5 at PERFORM
It's works without problems on version 9.0
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Bug-dblink-send-query-not-work-on-9-2-tp5739365.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
